Search results

Bump. I know my problem is a syntax issue and any help from you VB experts would be greatly appreciated. D.Gagnon

Dear Lister, Thank you for taking the time to respond to my message. I understand your point about testing for a Null condition but the actual implementation escapes me. The reason is because the option group tests for different conditions and the Null condition is just one of several that...

Hi All, I'm posting this code for a AfterUpdate event hoping that a resident expert can give me some guidance. I never took VB in college and my skills are very crude to say the least. On my form I have a Option Group and it is used to populate text boxes that are normally hidden. The values...

Also ensure that the date format that your database uses and your computer date format is the same. For example, if the short date format for your database is dd/mm/yyyy then it needs to be the same for your computer system settings. This will negatively impact your queries if they aren't. In...

Thanks Len Dear Len, As I sat at my desk I made almost every change you suggested without even seeing your post. Seeing that you've recommended most of the same things gives me confidence. I even made the combined key in the CompletedTrainingRecord as I couldn't see another way of joining the...

Dear Experts, I am a Access rookie. While browsing these forums I've noticed that the people here seem to be very knowlegable about database design and normalization. I'm writing because I need expert instruction on a database I'm working on. I've posted a couple times concerning my issue but...

Premature Happiness Edited. I've posted my problem in the Design and Theory thread. Thank you. DG

Thank You! Len, I went back and reviewed my relationships armed with the your suggestion. Your guidance has helped me make tremendous progress today and I want to thank you. I've already been able to solve almost all the problem I was having and I've produced an acceptable report. The...

Please accept my apologies for the multiple posts. The network was unresponsive and I didn't know my earlier attempts at posting had been successful. DG

Good Morning, I am new to Access and I welcome expert guidance on the relationships of my database. The database will be used to track employee training and although I've enjoyed limited success so far I'm hoping that eventually I'll get it right. The database has to do just a few things so it...

Good Morning, I'm hoping that someone here, who's knowledgable, can assist me in solving this problem. The problem I'm having is that I need to be able to report training events that have and have not been completed. I'm working on a training database that is to be used at my work place and...

Thank You! Mark, Thank you for the help. I followed your instructions and it worked like a champ. I was concerned that the combo box was still available before a button was selected and I tried modifying the statement to include a Null possibility. Eventually I set the combo box 'enabled'...

Resident Experts, I am currently working on a database to track the employee training for my company. Access is the only tool that is available and I'm definitely a novice. I'm working on a form to enter training event information and I have an option group and combo box problem. How can I...