Access 2007-2016
Access 2000-2003
Access Seminars
TechHelp Support
Tips & Tricks
Access Forum
Course Index
Topic Glossary
Insider Circle
Home   News   Tips   Glossary   Templates   Forums   Help   Logon   Order   Contact Us  

Sorry, but for security reasons, this feature only works for Thread descriptions that have only alphanumeric characters in them (A-Z,0-9). Richard still has to scrub all of the OLD descriptions from the system.


Microsoft Access Forum
By Richard Rost   Richard Rost on Facebook Richard Rost on Twitter Richard Rost on Google Plus Richard Rost on LinkedIn Email Richard Rost

This forum is for the discussion of Microsoft Access.

Access is my personal specialty. Have questions? Comments? Want to discuss how to do something? Post it here. Also, I get a LOT of questions sent to me in Email from people around the world. I'll post the interesting ones in here. Feel free to comment on them.

Click Here To Subscribe to this forum and receive an email update whenever new posts are added, just scroll down to the bottom of this page and enter your email address in the comment form.

Permanent Link
Keywords: microsoft access forum
Post New Topic

Read Make Table Error Message by Karen R @ Wed 9/19
Hi Alex, There is long text field called CustomerNotes in the table.  Will I need to remove this before being able to continue?
Show Just This Thread        Post Reply
Read Excel Calculations on Access by jannette j @ Tue 9/18
I have several Excel Equations and formaulas to put in access.
One of the equations or excel formulas is this
=IFERROR(SUM(COUNTIFS('Import Report'!E:E,{"CM","MMNRO","MMROI","PMCM","PMINS","PMOR","PMPDM","PMREG","PMRT"},'Import Report'!K:K,">="&(A2-1/24),'Import Report'!K:K,"<"&(C2+23/24),'Import Report'!F:F,"*COMP*",'Import Report'!O:O,">="&(A2-1/24),'Import Report'!O:O,"<"&(C2+23/24),'Import Report'!X:X,"LEWMXTCHE"))/SUM(COUNTIFS('Import Report'!E:E,{"CM","MMNRO","MMROI","PMCM","PMINS","PMOR","PMPDM","PMREG","PMRT"},'Import Report'!K:K,">="&(A2-1/24),'Import Report'!K:K,"<"&(C2+23/24),'Import Report'!X:X,"LEWMXTCHE")),0)

How do i put that in access?
Show Just This Thread        Post Reply
Read Email to SMS Gateway Text Messages by Richard R @ 9/17/2018
Q: I just completed your Access Email Seminar and I really enjoyed it. I'm putting it to use. I would like to see a seminar/course doing the same thing but with TEXT MESSAGING. I found texting is a lot more efficient than emails for URGENCY. ie: "John, your account is overdue $45 Please avoid disconnection. If you paid the balance please disregard this message."

A: Glad you enjoyed the seminar. Using text messages is basically the same thing as email. You just have to use an EMAIL TO SMS GATEWAY like I talked about in Lesson 29. The trick is to figure out who the cell provider is. Here are some popular ones:

Virgin Mobile:
US Cellular:

Now, if you're not sure what carrier a customer uses, there are different tools you can use online to determine that. Here's one I found. I tested it with my number and it's correct:

And yes, there are services, programs, and even APIs you can purchase to handle all of this for you automatically, but if you want a free solution with just you and your Access database, there you have it.

Show Just This Thread        Post Reply
Read Unicode Compression IME Mode by Richard R @ 9/17/2018
Q: What is Unicode Compression, IME Mode, and IME Sentence Mode for short text fields in Access tables? Do these settings ever need to be modified?

A: You basically never need them. The first has to deal with how characters are compressed when stored in the table, and the second two have to deal with foreign (Asian) character sets. If I haven't told you in class that it's important, it usually isn't. :)

A quick search of my site shows I did table about these in Beginner 4. Wow, that was a long time ago. LOL
Show Just This Thread        Post Reply
Read Connection to SMTP Servers by Eduardo B @ 9/17/2018
I am having trouble connecting to SMTP server to Send email with out Outlook.  Im using Godaddy with for SMTP and Port 587 as instructed.   I am also trying gmail with port 465 with no success.   Did somtheing change in CDO method?   Any advice?
Show Just This Thread        Post Reply
Read convert excell calculations to access by jannette j @ 9/13/2018
i have a table with the following fields.

I have excel calculation That i need to put in access but dont know how any ideas would be great.

for the caculations i need to put this in access

(%) PM Compliance [>95%]   Staus (COMP or FCOMP)) And ActLAborHours(>0) And ActStartDate

                                                       Divided By

                                                          WorkType(PMINS0PMOR,PMPDM,PMPDM,PMRT) and Status(Not

                                                            "Canceled") and TargetStartDate.

I know i have to do this in query but not sure how to set it up.

Show Just This Thread        Post Reply
Read Microsoft Access Forum by Michael R @ 9/13/2018
Can I create an action button on a form that will allow the specific form to be emailed to a customer?
Show Just This Thread        Post Reply
Read Making corrections in table by Charlotte K @ 9/10/2018
In trying to replace the number of an item in a table with the correct number the table would not accept it. Also it would not accept correction in words.  Help, please.
Show Just This Thread        Post Reply
Read Make Table Error Message by Karen R @ 9/5/2018
Hi, yes as above, my Customer Notes field is set to Long Text.
Show Just This Thread        Post Reply
Read Send email using VBA by Tom D @ 9/2/2018
I'm using late binding to send an email. Using the Set olEmail = olApp.CreateItem(0) the .VotingOptions show up in the displayed email, but not on the email received by the recipient. I can use a template to get around this problem, but that adds baggage. What am I doing wrong?
Show Just This Thread        Post Reply
Read Help with database by Neven M @ 9/1/2018
Thanks a lot. I have created a junction table GenerationT with Three foreign keys: School, SchoolYear and Grade.

Show Just This Thread        Post Reply
Read Database questions by jannette j @ 8/30/2018
Good day,
I have a meeting tomorrow on designing a database for a department. I need some examples of questions to go to the table with when designing a database.

Reply from Alex Hedley:

Thats an open question!
You basically need to get a list of requirements, what data are you storing, how will you get this data, what Reports do you need etc.
Show Just This Thread        Post Reply
Read Make Table Error Message by Karen R @ 8/29/2018
I've been following the archive lesson in access expert 17.3 exactly as described. I get an error message when I try to run 'MakeCustomerBACKUPQ' which states 'Multi-valued fields are not allowed in SELECT INTO statements.' I haven't used the lookup wizard in any of my tables including my CustomerT so can't work out what's going wrong.  I just have the same regular fields shown in the training example but have included one for Customer Notes which is set to long text. Any help will be much appreciated.

Reply from Alex Hedley:

Any Long Text / Memo Fields?
Show Just This Thread        Post Reply
Read Combo Box Issue by Christopher V @ 8/27/2018
I am using Microsoft Office Professional 2016.  When trying to create a combo box on my form the combo box wizard only gives me two options.
"I want the combo box to get the values from another table or query"  and
"I will type the values that I want". I am not getting the third option like there is in the video "Find a record on my forum based on the value I selected in my combo box". Why am I missing that third option?

Reply from Alex Hedley:

Combo Box Find Record Missing
Show Just This Thread        Post Reply
Read Dates by Selby H @ 8/26/2018
Dear Richard, Can you please help. I have one date field and want to show the days between each record in a text box or label when I move from one record to the next. Want to display the number of days from the last record date to the next date in the table. Is that possible. I have been looking at the DateDiff function, but seems like you need a start date and end date. I want to move between one date field and show the days. It might be like the running sum technique, not sure.
Your Help would be greatly appreciated
You might have already covered this and have searched everywhere with my records. Cannot find.
All the Best Selby.

Reply from Alex Hedley:

You could use a combination of DMAX, DMIN, DateDiff
Show Just This Thread        Post Reply
Read Join table with 3 foreign keys by Neven M @ 8/20/2018
Hi all!
In my db I have tables: schooltschoolyeart and department. To  get the unique combination of these three, i ve made a junction table generationt with fields generationid(pk), and 3 fk s: schoolid, schoolyearid and departmentid.
The generation is for example

Nikola Tesla Zagreb - 2017/2018 - 1a
( school named Nikola Tesla, school year 2017/2018 and department 1a (freshman year)

Is this the right way? Can I makewith only two foreign keys.
Thanks in advance
Show Just This Thread        Post Reply
Read Access Email Using Outlook Template by Steven D @ 8/19/2018
I would like to set up my database to send emails with attachments using an Outlook template. The template would have variables which need to be replaced with data from the database.

Reply from Alex Hedley:

The Email Seminar might cover something similar
Show Just This Thread        Post Reply
Read Set Focus by jannette j @ 8/17/2018
i would like to set the focus to due date after i press approved but i get an error  microsodft access can not move the focus to control. I user me.Tduedate.setfocus  and i doesnt like that command. please help

Reply from Alex Hedley:

You could try
Show Just This Thread        Post Reply
Read Change Backcolour to orange by John McFarlane @ 8/16/2018
I want to change my backcolour to orange (in this case) using the If Function but keep getting errors: -

Private Sub Form_Load()
Dim Orange As Long
Orange = RGB(255, 165, 0)
If [Date] - [EDEStartDate] <= 330 Then [30DaysDate.BackStyle] = Orange
     Else: [30DaysDate.BackStyle] = 0
    End If
End Sub

I am unsuer if this is the correct function - any advice please?

Reply from Alex Hedley:

I don't think you need the [] around the BackStyle
Show Just This Thread        Post Reply

Show Older Posts         Collapse All Topics


Post Your Comments or Subscribe
    If you would like to be notified of new posts on this forum,
    just enter your email address below. It will be kept private.
If you just want to subscribe to get email updates when this forum is updated, then enter your name and email address and check the Notify Me box below. If you would optionally like to add your comments below to be posted, they are welcome.
  Your Name:  Required
  Your Email:  NOT Public


Sorry about this step. It's just to keep the spam bots away:
  Verify: What is 9+8:
  Notify me when the this forum is updated
  Remember Me for my next comments
Please do not use this form for Customer Service inquiries! If you have questions about your account, shipping info, courses you've ordered, need passwords, etc. please use the Customer Service Center instead.

I value your comments. They will be displayed on this page (above). Your name will be displayed, but your email address will not be.
As always, I promise to never give away your personal information to anyone else, ever.

NOTE: If you don't leave your name and email address, DON'T expect a reply. I can't promise a personal reply to everyone who posts here. I TRY my best, but I cannot guarantee it. If you don't leave your real name and email address, I won't even bother. I usually just hit DELETE. -Richard



You may want to read these articles from the 599CD News:

8/25/2018NEW: Access Dev 9, 10, 11
8/25/2018Microsoft Access Developer 11
8/25/2018Microsoft Access Developer 10
8/25/2018Microsoft Access Developer 9
8/23/2018Access Dev 11 is ONLINE
8/17/2018Access Dev 10 is ONLINE
8/15/2018Access Tip: Search Form
8/15/2018Access Tip: Locked v. Enabled
8/15/2018Access Dev 9 is ONLINE
7/31/2018Microsoft Access Developer 8

Visual Basicindex
Account Login
Online Theater
Lost Password
Free Upgrades
Insider Circle
Student Databases
Change Email
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search Our Site
Waiting List
Production Schedule
Collapse Menus
Live Chat
Customer Support
WalkThru Tutorials
Consulting Services
About Us
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Video Tutorials
MYOLP Memberships
Idiot's Guide to Excel
Volume Discounts
Payment Info
Terms of Sale
Gift CDs
Live Chat
General Info
Support Policy
Contact Form
Email Us
Mailing Address
Phone Number
Fax Number
Course Survey
Facebook    Twitter

Google Plus    LinkedIn

Blog RSS Feed    YouTube Channel
Richard Rost Microsoft MVP