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     
35 days 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    
35 days ago
Ignore my last post. The "user" who is somewhat dyslexic had changed the headings on the excel spreadsheet!!
Richard Rost    
35 days 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    
36 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    
35 days 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     
37 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    
37 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    
36 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     
38 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    
37 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    
37 days ago
count me in!
Add a Reply
Calendar Seminar Link 
Janice Daniels    
38 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    
38 days ago
It always comes down to spelling. What's the SQL statement?
Janice Daniels   
38 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
Print One Form Per Page Link 
Roy Zanca     
39 days ago
Thanks for all your past help
I want to be able to print one FORM  TO ITS OWN  single page
I have 600 phonograph records with all sorts of info which I want to print out on a single sheet. Read More...
Richard Rost    
38 days ago
For any kind of printing use a REPORT not a form. With a report you can put a page break after each record.
Roy Zanca    
38 days ago
Rick do you have a video session on inserting a Page Break in a report-If so please share. tks Roy
Add a Reply
Standardized Form Link 
Bob Joesel    
40 days ago
I'd like to save a form I've created to use with different/ multiple tables.  Any chance of doing this?
Richard Rost    
40 days ago
Sure, as long as your field names are all the same (FirstName, LastName, etc.) then you can use that form with any table you like. At the Beginner stage, you'll have to store multiple copies of it and just change the RecordSource property. Later on, when you get into programming, you could use the same form, and just change that property dynamically in the code of the button that opens the form.

Docmd.OpenForm "MyFormName"
Forms!MyFormName.RecordSource = "CustomerT"

It's not hard to do. This might actually make an interesting TechHelp question. I'll add it to the list. :)
Add a Reply
Custom Sort Order Link 
Richard Wilson     
41 days ago
Rick, This is an excellent tool.  I have fought with many of the problems you have solved in this little bit of a database, and I have solved some of them, though not as elegantly, in a manner similar to your solution.  There is another problem that I have encountered and that is sorting of items in a helper table.  For example Adjunct Professor would come before Assistant Prof, and Assistant before Associate and all would come before Professor.  I have solved this problem by having a "sort" field in what you have called the HelperT.  And it seems to work even if I add additional items.  I can change the sort field which is numeric, regardless of how well developed the database has become.  But I am sure there must be a better way to accomplish this and I look forward to your suggestions.
Richard Rost    
40 days ago
No, you're correct. A custom sort order field is exactly how I would solve that problem too. Custom Sort Order.
Add a Reply
Change Inventory Again Link 
Adam Schwanz     
42 days ago
Hello again Rick, sorry to bug you again on this. I got stuck again, I've gotten really close to having it work rewatching access 326 for the 10th time but it will only update the selected record not all included. Read More...
Richard Rost    
42 days ago
In my recent years after gaining much wisdom, I don't like passing recordset values as parameters. Try assigning rs!PartNum and rs!Qty to local variables first and then pass those.

Dim PartNum as String, Qty as Long
ChangeInventory PartNum, Qty

Why? It just WORKS sometimes.
Richard Rost    
42 days ago
Everything else looks solid. Your code is good. You must have had a good teacher. :)

If that doesn't work, maybe pass your values ByVal:

Private Sub ChangeInventory(ByVal PartNum As String, ByVal Qty As Long)

If those don't work lemme know.

Add a Reply
Chart Sizing Link 
Brandon Jackson     
42 days ago
Hello sir,

     I have an issue with the chart sizing in Access at work.  Different computers will size the chart objects differently, for some reason.  My laptop sizes them too small; my co-worker's sizes them perfectly, and my boss's PC sizes them WAY too small.  All of this occurs within the same database.  We are on a network here and have a contract with Windows for Office programs.  We are currently running different versions of Office on these computers.  The chart frame is sized properly, but the actual graph size will vary.  I appreciate any advice you may have. Read More...
Richard Rost    
42 days ago
Yeah, that's always been an issue with Access. Charts especially can be COMPLETELY different from version to version. That's the first thing I was going to suggest: make sure you all have the same Access version installed. Otherwise you really can't guarantee they'll look the same. Microsoft has changed Charts around a lot even since 2013 when I did my last charting class. Need to update that soon.
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:

11/21/2020Shortcut Keys Ctrl-Period Ctrl-Comma
11/19/2020Hide Page Footer on First Page
11/19/2020Single-Field Search Button
11/19/2020Get Username WScript
11/18/2020Access Developer 19
11/18/2020Access Developer 19 Lessons
11/18/2020Access Developer 19
11/18/2020DateAdd to Add Months
11/16/2020Properly Calculate Age
11/13/2020myNetWorkDays Function

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
Code Vault
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