Access 2007-2019
Access 2000-2003
Access Seminars
TechHelp Support
Tips & Tricks
Access Forum
Course Index
Topic Glossary
Insider Circle
Home   Courses   Seminars   Templates   Help   TechHelp   Forums   Contact   Join   Order   Logon  
Home > Forums > Access
Microsoft Access Forum

Welcome to the Microsoft Access Forum. Access is by far our most popular topic here at Computer Learning Zone. This forum is for everyone to read but only students (paid customers) can post here. If you'd like to become a student, all you have to do is enroll in one of my courses. After you create a logon, you will have full access to the Forums.

Subscribe to this forum and receive an email update whenever new posts are added. You will also be notified by email if any conversations you are involved in receieve new comments. Yes, even non-students can subscribe to update notifications.

Having problems with your Access database? Here are Rick's Rules if you want help. 

Rule #1: Before you ask for help with a WEIRD problem, meaning Access isn't behaving normally, then make sure you run down the Access Troubleshooter which covers solutions to many common problems. If you have a weird problem and you don't say "yes, I ran down the Troubleshooter" then I'm just going to point you to Rick's Rule #1.

Rule #2: Before posting your question, check to see if it's already been answered. You can use the Search feature to look for keywords. Save me some time having to only point you to another post where your question has already been answered.

Rule #3: If neither of those things help, make sure you post exactly what you're doing, what the specific error message is, what you've tried, and any other details we might need to help you. Don't just say, "I get an error." Tell us what the error is and what you're doing. We're not mind readers. I wish. Also, be sure to read this article on Context. It matters!

Rule #4: Links to files or images on other sites are NOT allowed. Don't try posting a link to your database on Dropbox or any other web site. If you have someone specifically offering to help you, you can email them your database. You can upload screen shots here using the Upload Images link provided on comments. Post your question, then you can upload a screen shot.

Rule #5: I encourage students to help each other out. I love seeing that. However, don't take advantage of someone else's good will and ask to send them your database for free tech support. I don't work on databases for free, and I don't expect my students to either. If you're looking to have someone else fix your database, you can post a request for service in the Access Developer Network. Not here. 

NEW: Access Developer Students, make sure you subscribe to the Developer Student Forum.

Click Here to Post a comment and start a new discussion


Access Developer lesson 16 1 Upload Images   Link 
Dalal Ajassim 
29 hours ago
I have gone through your VBA lessons and downloaded lessons 16 and 17.
I tried to apply my new knowledge to my access form but it seems I'm missing something.
I want to extract individual pdfs reports for each of our employees. Read More...
Add a Reply
PBKAC Error Upload Images   Link 
Richard Rost 
2 days ago
I just wanted to share the LOL with everyone. John Davy said to me in an email, "A professor in college once said "it is either the machine or the operator" Your code (the machine) works properly and I (the operator) did not put the code in the correct spot." Read More...
Adam Schwanz
2 days ago
A couple quotes I've heard that I can remember:

Code Never Lies, Comments Sometimes Can .

There's 10 types of people in this world. Those who understand binary and those who don't.
Add a Reply
SubForm Like ABCD Upload Images   Link 
Joseph Messina 
3 days ago
Hi Richard:

   I have my contact database setup like you have in the ABCD database with the EMail, Phone and Address tab.  I accidently deleted my database and thank god had it backed up so i had the Sub forms created for the EMail, Phone and Address and also added contact history and documents.  I was following your videos how to do the tabs like you have in the ABCD database did it step by step was following along with the vidoes.  I have everything all setup now an good to go.  I have question about my database.  When i click on a tab flashes.  I don't know why it does that when i click on each tab.  Can you help me with that please?
Adam Schwanz
3 days ago
When you click on a tab the tab flashes? Does it flash off and on or is it just a blink once?
Joseph Messina
3 days ago
Hi Adam:

Flashes once when i click on a tab.   Can I send you my database so you can see what it is doing?  Also I had a tab for documents and when I go to the documents tab to add a new document and I click on the browse button to add the file and after I do that and clickm opn another tab for example like email all the tabs turn black.
Add a Reply
Forms Upload Images   Link 
Mark Parsons 
3 days ago
Hello all, is there a way to only display certain fields when a specific selection is chosen from a drop down box?
Adam Schwanz
3 days ago
Yes, it requires VBA programming though. You can say something like

if DropDownBox = "Something" Then
OtherField.Visible = False
End If
Mark Parsons
3 days ago
Adam, thank you Ill give that a go....
Add a Reply
Access Upload Images   Link 
Mark Parsons 
3 days ago
Hiya, I have a very odd problem which Im sure is easily fixed. Within the fields property of my table, I have chosen to enter a combo box which the user can choose from. But when I create a form, it comes back and says that it belongs to another table or has been changed or deleted. Read More...
Alex Hedley
3 days ago
I'd use a related Table instead.
Mark Parsons
3 days ago
I only use one table with all fields included.
Add a Reply
Connect Database to the Web Upload Images   Link 
Abraham Breuer 
4 days ago
I want to take the seminar on asp with access but I saw in the preview that it is an old lesson, you are using the front page, should I take this lesson even front page isn't relevant, or there is an alternative to it? Read More...
Richard Rost
4 days ago
The Web Database Seminar is old. Most of it is still relevant, and works, but it does need an update. I used FrontPage for the web editor. Neither it, nor its successor (Expression Web) are available anymore, but the editor that you use doesn't matter. Everything in the course is just plain ASP and HTML. You could use Notepad if you really wanted to. The ASP is all valid. I do use an Access MDB file to connect to. Again, while that still WORKS, it's not the best thing to do today. Now I recommend using SQL Server. I'm going to be updating this seminar very soon (hopefully this summer) to use the newer technology.
Add a Reply
Database Updates Upload Images   Link 
Scott Adkins 
4 days ago
I again want to extend my thanks to Richard for this site and the service. It is unbelievable how much I have learned over the years. Kuddo's always!

I vaguely remember some mention in the forum about a "updater" seminar. I believe I read something of it in one of the forums here. Admittedly, it could have been stuffed away in my own little "wishful thinking" file....HaHa! Read More...
Richard Rost
4 days ago
Thank you Scott. I believe this is what you're looking for... Access Updater
Add a Reply
Navigating Lessons Upload Images   Link 
Keith Armstrong 
5 days ago
I always see pre view of lesson .I never see lesson with videoed a hour long . can you explain more about the lesson . may be if I get the hand book that would help .beginner learning guide.
Scott Axton
4 days ago
Keith -
I see that you posted this in the Tech Help so...  Maybe wrong area?
The Tech help videos are mostly short videos dealing with specific subjects

Richards COURSE videos are very rarely more than 30 minutes INDIVIDUALLY,  the total course is almost always at least 1 hour long and in some instances much longer.

How are you accessing the course?  You should be able to move from lesson 1 to lesson 2 to lesson x.  OR start in the middle where you left off.  Once you sign up for a course you can keep coming back and watch them as many times as you want.

Hand books ??  Personally, this depends on how you learn.  It's kind of nice to have a document open that you can refer to when building a data base.  Easier than watch video hit pause. Work on db.  Watch video. Repeat.

Keith Armstrong
4 days ago
thank for the advice I'm new customer trying to navigating  the course . I guess I need more time .
Add a Reply
Conditional Formatting Upload Images   Link 
Kaibaua Airam 
6 days ago
Hello Everyone

Please help me how to apply conditional Formatting on TimeField in my Report using Between

In my Rule I used Expression Is:- Between Minute([SentTime])>1 and Minute([SentTime])<30 Read More...
Richard Rost
5 days ago
You can't always use functions like that inside conditional formatting. Make Minute(SentTime) an actual field in the underlying recordset and then you can use its value for CF.
Add a Reply
Access Invoicing Upload Images   Link 
Emile Dellieu 
6 days ago
Dear Richard,

I own a used goods store in South Africa where we sell anything and everything.
I have looked at several of your free vids and Beginner 2 ($1).
My system uses several tables, however, the vendors vouchers are reports originating from one table and we sell using a different table. I fdid this because I could not get the invoicing to work from the main table that included Vendors, Stock items and customers. Now, it is a procedure to copy the stock items from the vendorsT to the productsT so that we can make an invoice. I have tried AppendQ, UpdateQ etc... But no joy. Read More...
Adam Schwanz
6 days ago
By taking the normal courses you'll learn how to do this along the way. Around expert 8 or 9 I think it starts getting into invoicing. I would suggest going this route as I'm sure you'll learn some other things along the way that you didn't know. I strongly recommend doing them in order and not skipping ahead.

More Advanced Option - If you have some access/vba experience, here's a few links that may help.
Richard Rost
6 days ago
Hi Emile. Doing all of that isn't easy. I take several lessons to show how to do all of that, and to do it RIGHT involves some VBA programming. Adam started you off with some good links. I'd start here: Invoicing. Watch the pre-requisites that go before it if you don't know how to build a basic database, like the Blank template video. Honestly, if you want to build the best solution, I'd suggest signing up for the Learning Connection. Finish the Beginner Series and at least Expert 1 and 2. By the time you're up to about Access Expert 10, you'll be able to do what you need.

Just like a doctor has to go through pre-med and medical school before he's a doctor, you've got to put in some time learning Access and going thru the pre-requisites before you jump right into building a full invoicing system.
Add a Reply

Show Older Comments...
View in Table Format

Start a NEW Conversation
Only students may post right now. Click here for more information on how you can set up an account. If you are a student, please LOG ON first.

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

5/2/2021Split Commissions
4/30/2021Close Form
4/30/2021Close All Forms
4/29/2021Quick Queries #3
4/26/2021Combining Names
4/8/2021Age, Part 2
3/30/2021Accounts Receivable
3/28/2021Time & Billing
3/28/2021Time & Billing Template

Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Account Login
Online Theater
Lost Password
Student Databases
Change Email
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Customer Support
Web Site Tour
Consulting Services
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Video Tutorials
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Terms of Sale
Contact Info
Support Policy
Email Richard
Mailing Address
Phone Number
Fax Number
Course Survey
Blog RSS Feed    Twitter

YouTube Channel    LinkedIn
Keywords: microsoft access forum  PermaLink