Access 2007-2019
Access 2000-2003
Access Seminars
TechHelp Support
Tips & Tricks
Access Forum
Course Index
Topic Glossary
Insider Circle
Home   News   Courses   Seminars   Templates   Help   TechHelp   Forums   Order   Contact   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? Before posting your question, check to see if it's already been answered. You can use the Search feature to look for keywords. There's also the Access Troubleshooting Checklist which covers solutions to many common problems. 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. LOL

Click Here to Post a comment and start a new discussion!


Import from Excel Splits Date Link 
Shelagh Fagan     
18 hours ago
I have been running VB code for some years that uses the DoCmd Import from excel. The first field in a date. Just within the last month, it splits the date into Date and Date1 with Date1 being a time field. I can do a quick fix like changing the query that accesses the fields to rename it to Time, but how did this happen?
Shelagh Fagan    
17 hours ago
Ignore my last post. The "user" who is somewhat dyslexic had changed the headings on the excel spreadsheet!!
Richard Rost    
10 hours ago
Ah... that happens. 9 times out of 10 when someone complains about something weird like this, it's human error, and of that, half the time it's spelling. :)
Add a Reply
Inventory Control in Access Link 
Jeffrey Bates    
2 days ago
Hi Richard,  Absolutely love your work.  I have purchased up to Advanced 1,  but only got through the lessons to Expert 9 so far.

Do any of your lessons cover the requirements to create an inventory control database.  If so which are they.  My intent is to work through all the lessons but I might like to take a sneak peak. Read More...
Richard Rost    
10 hours ago
Properly handling inventory control isn't easy, which is why I wait until well into the Developer classes to cover it. You really need to know VBA Recordsets first, or at least SQL so you can modify values in table from code. There is a way to do it without programming, but it's kinda sloppy. I may show it as an example in an upcoming TechHelp video, but you really should do it the RIGHT way if you're going to run a business on it.

I haven't covered inventory in my current Developer series yet. It's coming up soon. I just got to Recordsets in Developer 16. In my older Access 2003 lessons, inventory took me 4 classes (Access 326-329) to cover properly. I'll be revising all of these lessons for Access 2019 over the next couple of Developer lessons, so if you want to start learning this stuff now, grab Developer 16 and 17.

I will be including proper inventory control as a module in the ABCD after I build the order entry module, so that's going to be a little while. Hopefully I'll get to it in the next month or two.
Add a Reply
Text Format Dropdown Link 
Doug Rettig Sr     
3 days ago
My access 2016 program no longer offers any choice in the text format property list.  When I click on the Format down arrow all I get is an empty drop down box.  The microsoft help is NO HELP!
Richard Rost    
3 days ago
Doug, it's context sensitive based on the data type of the field. For text fields, you won't see anything. For date fields, you should see a list of options like General Date, Short, Long, etc. For currency values, you should see General, Currency, Euro, etc.
Doug Rettig Sr    
2 days ago
"ICY "SAID THE BLIND MAN AS HE SLIPPED ON THE ICE AND FELL!  I was trying to get to point "TEXT FORMAT" thru the "FORMAT" property - can't get there from there.  I should have reviewed Lesson 1 from Beginner 2 first.  Sorry to have needlessly bothered you.
Add a Reply
Progress Bar Link 
Juan C Rivera     
4 days ago
Hi Richard looking to see if you have something to show how to make a progress bar.  I.e. Making PDF files I put a msgbox at the end report are done.   I like to see a bar showing progress.  Do you have this in a course already done or can you make this a tech tip?   Read More...
Richard Rost    
3 days ago
It's funny you mention this - I just added building a Progress Bar to the next Developer class (18). As we're covering Recordsets, it's nice to know how long a LONG process is going to take, so I was going to cover this. Yes, there is a plugin you can use, but I like to avoid plugins whenever possible. Coming very soon...
Juan C Rivera    
3 days ago
count me in!
Add a Reply
Calendar Seminar Link 
Janice Daniels    
4 days ago
Hi, I hope somebody can help me.

I am in the middle of the Calendar Seminar, I have added a list box, then when I close the form and re-open it, I get a parameter box showing the following.
Richard Rost    
4 days ago
It always comes down to spelling. What's the SQL statement?
Janice Daniels   
4 days ago
As I couldn't get it to work, I used your Embedded Calendar and changed all the commands in the list boxes, it was completely messed up and I couldn't get it to work no how so I have deleted the calendar completely from my Database.

Are there any instructions how to put your Embedded Calendar into the Monthly Calendar Form?

Stay Safe.
Add a Reply

Show Older Comments...
View in Table Format

Post a New Comment or Question
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:

10/12/2020Store Multiple Phone Numbers
10/10/2020ABCD Part 1: Core Database
10/10/2020Create Your Own Custom Function
10/8/2020Update Query from Another Table
10/5/2020Access Business & Contact Database
10/5/2020How and Why to Split Your Database
10/2/2020Multiple Nested Continuous Subforms
9/28/2020Access Developer 18
9/28/2020Access Developer 18
9/28/2020Access Developer 18 Lessons

Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
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 The Site
Waiting List
Production Schedule
Collapse Menus
Live Chat
Customer Support
WalkThru Tutorials
Consulting Services
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Video Tutorials
MYOLP Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Terms of Sale
Live Chat
General Info
Support Policy
Contact Form
Email Richard
Mailing Address
Phone Number
Fax Number
Course Survey
Facebook    Twitter

YouTube Channel    LinkedIn

Blog RSS Feed   
Keywords: microsoft access forum  PermaLink