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 Bilingual by Normand G @ Wed 1/9
We need to somehow have a bilingual system... we have both French and English customers. How do we go and do this?

Reply from Richard Rost:

I just covered one solution. I call it an External String Manager, and I covered it in Access Developer 12.
Show Just This Thread        Post Reply
Read Looking for an Access pen Pal by Roy Zanca @ Tue 1/8
Hello, I m an Access enthusiast not looking for a pen pal but an Access Pal to talk through some of our 599 Access Training Challenges. I m sure we all agree It s always helpful to have a phone visit when Access Challenges arise. If you feel as I then please email Roy At
Show Just This Thread        Post Reply
Read Uppercase by Sunil @ Mon 12/31
Thanks Alex..
Show Just This Thread        Post Reply
Read Beginner Level 7 by Normand G @ Mon 12/24
I am starting Beginner Level 7 and now when I open my CusomerF I have a "Enter Parameter" that opens and asking for "CustomerTFaxNumber".
I do I get ride of this?

Reply from Alex Hedley:

Does 'CustomerTFaxNumber' exist in your Table/Query?
Show Just This Thread        Post Reply
Read Fit to Screen by Joseph M @ Tue 12/18
Any chance of getting a future session on using some of the new fields in Access for screen adjusting? Looks like the tools are there and it would be great to get some education.

Reply from Alex Hedley:

Which New Fields do you speak of?

What's new in Access 2019
Show Just This Thread        Post Reply
Read Split database and network interuption by Karen R @ 12/13/2018
Hi...Just to reassure, I have had the same problem since our IT department moved our networked drives into the Cloud over 12 months ago.  It used to happen as frequently as eight times a day so very frustrating.  It has nothing to do with your database being encrypted and locked or with a backend/front end file as I have only just learnt how to do this.  Microsoft think it relates to letters being used for our networked drive.  They created a short cut for me on my desktop using Powershell which has reduced the number of interruptions a day so it is better but not great.  Give this a try.

Type in Powershell in windows search button. Select and type in

Get-smbmapping enter.  Will see all of the drives you have access to.
Select appropriate drive, copy, right click on desktop to create a shortcut and paste file into first field, then next , name as required and close.  Use this to access your access database going forward.  Hope this helps a little.
Show Just This Thread        Post Reply
Read Uppercase by Sunil S @ 12/8/2018
How can I make first letter uppercase in my field data, for eg. FirstName field, irrespective of, in whatever case, I type in that field.

Reply from Alex Hedley:

You can add Formatting on the Form

Show Just This Thread        Post Reply
Read State and City by david P @ 11/22/2018
On Access Expert Lesson2 video 4, I am trying to get the Forms!FormName!FieldName to work. I have two forms, State and City. I have a combo on State on City form, and when I use the "List Items Edit Form" to State, it doesn't go to the state I have listed when state form opens? I have put the Forms!,,, in several txtboxes on that form with no working results. Dont understand why this isn't working.

Reply from Alex Hedley:

Which state does it go to?
Show Just This Thread        Post Reply
Read Creating Invoices by Rajan A @ 11/21/2018
in which class the topic of invoices creation and disposal is covered?

Reply from Alex Hedley:

Show Just This Thread        Post Reply
Read Pasting from Excel by Gregory C. S @ 11/20/2018
Yes, you do need the same number of columns.  And each column in Excel must match the data type in Access.  If Access thinks 2018 is text, you have to format the year column in Excel to be text, too.  Except for AutoNumbers, Never use numbers unless you intend to do math.  Year, zip, etc are text.  If you have Autonumber in Access, you need a number column in Excel.  Use any numbers you want in Excel's first column.  Access will ignore them but they are necessary for the paste.
Show Just This Thread        Post Reply
Read Microsoft Access Forum by Gregory C. S @ 11/20/2018
Alex,  I wrote "unsplit" in the last line.  I think I am too ignorant to tell my Excel macros and Word (single record merge) templates how to find the tables.  I am willing to try the split again if it will help me get rid of some of the error messages and MSysCompactError tables that have shown up in this database in the last 3 months,  The dB has been stable for years. Richard's lessons, other than the splitting lessons, have been incorporated into my dB. I am starting to think our recent server, with its older switches and wiring, are the issue that has been erasing VBA in my forms.
Show Just This Thread        Post Reply
Read Split database and network interuption by Travis B @ 11/20/2018
Yes, this happens to all of the dbs several times daily. The error is- Your network access was interrupted. To continue, close the database, and then open it again." I assume this is due to security features on our network that momentarily cuts the connection. If a record is dirty, we have to acknowledge an error for each field on the form (appr 30) and this gets aggravating especially to non-computer friendly employees. Is there a VB Code to reconnect or even just close the db without the errors?

Reply from Alex Hedley:

Are you connecting via a UNC path or a mapped drive?
Show Just This Thread        Post Reply
Read Pasting from Excel by Jan H @ 11/18/2018
My experience with copy/pasting from excel is that you need an empty cell to allow access to generate the primary key. An example: If you want to copy the column A,B and C you need to add a (new) empty column A as the first column. So when you now copy you copy A (empty), B, C and D.

Regarding the type it is (in my experience) enough that what you see in a cell is aligned with the type definition in the access table is enough. I.e. if a cell is defined as text but contains the value 1.23 its ok to copy that to a field in access defined as Double.
Show Just This Thread        Post Reply
Read Booking calendar by Vesna D @ 11/18/2018
I bought your Calendar Seminar and I saw how to make one calendar, but I need like a 30 calendar working at the same time for booking calendar in hotel (I make 30 calendar for every room but Access can not run 30 queries at the same time). I also want to know how to color booked days for every room.

Reply from Alex Hedley:

You could add an extra column for Room, add that to the Create Form, then have an extra column show up on the day with the Room Number.
Listboxes don't allow for much customisation so changing colour if you want to do it per row, but you could use other controls on the form.
Show Just This Thread        Post Reply
Read Reduce height of header by Hugh C @ 11/9/2018
I can't reduce the height of the header. I cut and pasted some labels in the header. They appeared higher up in the header than where I had cut them and I then moved them down to the bottom of the header. However, when i try to reduce the height of the header it will only decrease to to highest point the label had been (when I pasted it). How can I reduce it to just big enough for the labels?

Reply from Alex Hedley:

Were the Fields added with the Wizard? This usually joins a Label to a TextBox and then you delete one and not the other and it's still there, check there isn't anything in the way.
Show Just This Thread        Post Reply
Read Is there a Restricted number of linked DB by Dottie A @ 11/8/2018
If I create 1 main DB and then have 12 separate databases that link tables to it, is that possible or even recommended?  If not, what are my alternatives?

Reply from Alex Hedley:

How many Tables will you be linking?
There is an Access limits article from MS which likely tells you this but 12 should be fine.
The next option is to upgrade to MSSQL Server and pull the data from that. Create Views to join your Tables, Queries in Access.
Show Just This Thread        Post Reply
Read Booking calendar by Vesna D @ 11/8/2018

Can you make a lesson that would relate to the booking calendar in the hotel? Thank you

Reply from Alex Hedley:

There is a Calendar Seminar

The Access Work Order Seminar also deals with Scheduling, this might be useful too.
Show Just This Thread        Post Reply
Read Pasting from Excel by Jeremiah T @ 11/7/2018
Why is pasting from excel proving to be so difficult?  I get a gamut of error messages no matter what I do.
If i just copy the specific cells, I get this error--- "The value you entered isnt valid for this field"
If I try to copy a whole row, I get this error--- "Too Many Fields Defined"

These errors make sense as a sum of the words, so ive made sure that what Im pasting is formatted identically to the  fields in Access.  Im at a loss.  please help..

Reply from Alex Hedley:

Do the columns you have in your Excel workbook match the fields in your Access Table?
They need to be the same order.
Show Just This Thread        Post Reply
Read conditionally Format continuous subform by Gina D @ 11/5/2018
Hi Alex/Richard,
I would like to conditionally format a field in a continuous subform located on a Main Form.
VERY Basic Layout:
Employee Profile is the Mainform   EmployeeID as Primary Key
TrainingNeedsSubF - Continuous Subform, Record Source is from NeedsQ, CourseNameID is a field in the form.
EducationSubF - Continuous Subform, Record Source is from EducationQ, CourseNameID is a field in the form.
I would like the TrainingNeedsSubF CourseNameID to highlight GREEN if the CourseNameID on the EducationSubF is the same.
Unfortunately, I am unable to change any of the forms format, they have to remain as continuous forms, I have dependent comboboxes.
Your guidance would be appreciated.
Gina D

Reply from Alex Hedley:

What Formatting having you tried so far?
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 2+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:

11/20/2018Microsoft Access Developer 12
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

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