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? 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

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

Click Here to Post a comment and start a new discussion


Questionnaire Upload Images   Link 
Leo Rivera 
11 hours ago
Rick please give an heads up I am preparing a quality control questionnaire that will  be completed for all accounts an I am stuck I do not have idea how to relates this tables.  Any idea? Or any course you recommend me to see?
Richard Rost
9 hours ago
Well, I haven't done this exactly. I did create a Test Taker database in Access Developer 9 and 10, which is a very similar format. You basically need a SurveyT, a QuestionT, and assuming it's multiple choice an AnswerT. Then another table to hold the responses. Another option, you could use the ABCD to track questionnaire responses in the Misc Data fields. However, this would make a cool TechHelp video. There are a ton of questions from members in front of you, however. How soon do you need a solution?
Add a Reply
Continuous Form Format Upload Images   Link 
Richard Lanoue 
22 hours ago
Hi Richard,
I always forget this.  Is there a way to format a continuous form where certain fields on certain records change (as in make invisible) while other fields do not (remain visible).  I've done something like this before but always forget how. Read More...
Richard Rost
12 hours ago
Yeah, you have to use Expression Is. See Hide Field Continuous Form.
Add a Reply
Blank List Box Upload Images   Link 
Jacey Cortega 
28 hours ago
I just completed Access Developer 8. I'd like to know how to start the list box without any client information. I will have over 300 records and do not want to deal with the extra load time.
Richard Rost
27 hours ago
Good question. You could leave the RowSource property empty when the form loads. And if you really want to speed things up, don't fire the event to requery it until it's length is at least 2 or 3 characters.
Add a Reply
Hyperlink Combo box shows URL Upload Images   Link 
Mark Fannin 
30 hours ago
I made a form using a combox box to find open job numbers.  The Job Number field is a hyperlink in the table.  The combo box brings the hyperlink URL text. How do I get rid of the URL text and just see the job number?  Picture attached.  I've gone through all the properties and it's driving me nuts.  Many thanks.
Mark Fannin
30 hours ago

Richard Rost
27 hours ago
This is one of the reasons I tell people NOT to use the Hyperlink data type. In fact, I'm re-recording Access Beginner 1 now, and I specifically told people NOT to use it for the email address field, which I did the last time I recorded it in 2013. It's just a mess. You have to use the HyperlinkPart function to decode it and pull it apart into its pieces (address, visible name, etc.). I cover it in Access Expert 5. Since you're a Platinum member, I'd be happy to do a TechHelp video on it since I haven't covered it yet. Let me know.
Add a Reply
How to round a field which sum Upload Images   Link 
Michelle Seidelin 
3 days ago
Hello Richard.
please look at the photo above as you will see I have been able to divide the minutes giving me the right amount of minutes except minutes come out at  2.45 to get this total I  divide the total minutes by 60 but I don't know how to round the last part where would the round go I've tried a couple of places and not sure do you have any videos on how to round a sum these results show up in a form as you can see not a query or data view will uploao phota as soonit lets me Read More...
Michelle Seidelin
3 days ago

Michelle Seidelin
3 days ago
Have done more tests and discovered things are not as close as I thought they were when I put in a 30 minute AND it comes out wrong what I have done of course the void maximum minutes divided by 60
So there must be a more accurate way to do this hope someone out there can help
Add a Reply
Clearing Combo Boxes Upload Images   Link 
Joseph Messina 
3 days ago
Hi Richard:

    I was watching Beginner 8 in my courses.  I see in beginner 8 has how to create combo boxes and also to use a combo box to search for a record in a database.  How can i clear the combo box after I search for a record?
Richard Rost
2 days ago
At the Beginner level, with that kind of a combo box, you really can't. You can do it at the Advanced level with a macro, or some VBA at the Developer level using an AfterUpdate event.
Joseph Messina
2 days ago
I understand what you are saying.  I was able to get it work to clear the combobox after i do a search.  I created a button to clear it and wheni click the clear button clears the combo box and and data in the form and also created a button to show all data again.  The combobox i have in my form for contact name to search for contact it field I have in my contact table labeled contact name.  I have lastname and firstname.  I would like to have the combo box in my form to show contacts names not be able to enter the new contact in the combobox every time i neter a new contact in my contactf.  I don't want  to go back to the table to enter the contact in the contactname field.  I wnt to have the combobox with lastname, firstname and for the contact to go in the combobox after I enter new contact in my form so I don't have to go back and forth from the ContactF back to the ContactT everytime.  I understand if you are very busy and swamped.  If you want me send you my database so you ca se
Add a Reply
Late Binding vs Early Binding Upload Images   Link 
Ray White 
3 days ago
Late Binding vs Early Binding..
What is it and when to use one or the other?
Richard Rost
2 days ago
Good topic for a video! Give me a little bit to present this topic... properly. :)
Add a Reply
String Function Upload Images   Link 
Tim Schmidt 
3 days ago
Could you assist me in what I am doing wrong in the following.  I am just trying to add a *  at the end of a text field named LastName so that the total lrngth will be 50.
= [LastName] &   & String(50-Len([LastName],*))
Richard Rost
3 days ago
In the AfterUpdate event for that field, try this:

LastName = LastName & String(50-(Len(FirstName)),"*")

That's if you want to CHANGE the field. You could always just use a query to display the data that way.
Richard Rost
3 days ago
I'd throw an extra space in there too, and use a Monospaced font (like Courier) if you want all the letters to be the same width.
Add a Reply
New Developer Student Forum Upload Images   Link 
Richard Rost 
4 days ago
Hey guys. I just set up a new Forum for Access Developer Students. If you're still at the Beginner or Expert level, this Forum is fine for you. The new Forum is to discuss topics at the Developer level (upcoming class material, etc.)
Add a Reply
DevOps Upload Images   Link 
Alex Hedley 
5 days ago
Found an interesting tool:

Could work well alongside the vcs
Ray White
4 days ago
Is DevOps a custom Access install builder to install your custom Access Apps to end users?
Never heard of it.
Ray White
37 hours ago
Alex Is DevOps a custom Access install builder to install your custom Access Apps to end users?
Never heard of it
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:

2/28/2021Barcode Scanning
2/24/2021Access Developer Forum
2/24/2021Widows & Orphans
2/23/2021Access Runtime
2/22/2021Table-Level Validation
2/20/2021Not Updateable
2/19/2021Filter Records

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