Access 2007-2019
Access 2000-2003
Access Seminars
TechHelp Support
Tips & Tricks
Access Forum
Course Index
Topic Glossary
Insider Circle
Home   News   Courses   Tips   Templates   Forums   Help   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.

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

New TechHelp Videos Link 
Richard Rost 
Sun 8/9
Howdy Access Lovers. I just wanted to make a quick post to let all of you know about the new TechHelp videos I've posted in the past week or so.

I'll post this here as a digest maybe once a week or so. If you want to get notifications as soon as I release new videos, make sure you Subscribe to either my YouTube channel or the Computer Learning Zone News page. The TechHelp videos have become kind of like a daily video podcast for me. I love making them, answering questions, etc. Read More...
Add a Reply
Contact Form Link 
Austin Ritner    
Sat 8/8
When I select a customer to add a new contact in the subform, I select them from the combo box, type the message in the notes section, save and close.

I open the contactR and the name doesn't show up. I feel like something is linked wrong.
Alex Hedley   
Sat 8/8
If you open the ContactT does the record exist?
If so what is its CustomerID (foreign key)?
Richard Rost
Sun 8/9
Make sure you Refresh the record before opening the report. If the little pencil is still showing in the record selector, the record is dirty which means it hasn't been saved to the table yet. The report won't see it. Refresh then Open Report.
Add a Reply
Referential Integrity Error Link 
Austin Ritner    
Sat 8/8

I'm trying to form the relationship on the OrderID field for my OrderT and OrderDetailT. When I select referential integrity it gives me an error.

What are your suggestions?
Richard Rost
Sat 8/8
OK. Glad to help. :)
Add a Reply
Open Form Specific Record Link 
Dg Ewing    
Fri 8/7
Hey Richard,

I have consumed all the "mycourses" and most of your free videos....which course should I purchase to develop the ability to click on a record in a continuous form to take me to xxxx (another form, table and/or query) Read More...
Richard Rost
Fri 8/7
Well, there's a combo box method that's easy but lacking in options in Access Beginner 7. You can create a command button to do that Access Expert 2. You can open a report to a specific record in Access Expert 5. You can do it with a macro in Access Advanced 1. With VBA I teach DoCmd.OpenForm in Access Developer 1. I teach the On Double Click macro event in Access Advanced 5. With VBA I teach the OnDblClick event in Access Developer 4.

So basically what you need is an OnDblClick event in your Customer (or whatever table) list form that runs a DoCmd.OpenForm with specific criteria. I'm pretty sure I have done this in a lesson before, but looking over my outline, I can't find it! I see that I've covered it in various seminars like the Work Order Seminar. It's something I build ALL the time.

Perhaps I should make a TechHelp video out of this... hmmm.... I'm trying to make them from popular topics, and I think you just made the list. Stay Tuned...
Richard Rost
Fri 8/7
I moved your post to the Access Forum. This comment is so you get the email with the updated link. Sorry. I usually do that before I approve it and post my reply.
Add a Reply
Different Languages Link 
Maurice Lubert     
Fri 8/7
Following the Developer_12_External_String_Manager Lesson, I have a question:
My current language is Hebrew (which is written with a different alphabet, from right to left). Changing from one alphabet (and direction) is not a big deal in Windows, but there are cases when this is not the best of solutions. In Excel, I am used to programmatically change the start language of a control according to various criteria. After several unsuccessful trials, I now do this with an API call, and I this might be what I have to do in Access. My question is: is there a simpler way to solve the problem? Read More...
Richard Rost
Fri 8/7
Honestly, Maurice, I've never given this much thought. I only speak English and the only other language I have experience with is Latin which I took in high school back in the 80s. Let me put this out on the Access Forum and we'll see if anyone else has experience with it.
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:

8/9/2020Access Odd or Even?
8/9/2020Access AutoNumbers Good or Bad?
8/6/2020Access Sync Up Remote Database
8/6/2020Access Customer Codes
8/5/2020Access Custom Sequential Number
8/4/2020Access Restore Deleted AutoNumber
8/1/2020Access Custom Sort Order
7/30/2020Access SharePoint Seminar
7/29/2020Microsoft Access Developer 16
7/29/2020Is There a Free Version of Access?

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