Recent content by DL101

Thanks for all the help Colin, it was greatly appreciated!!! I continued to try disabling the button in the form and subform with every different check I could come up with; IsNull, IsError, Nz, etc, and wasn't able to get any of those suggestions to work. So, ultimately I just decided to check...

Thanks for the suggestion Ridder. What would you suggest to disable to the button. I tried variations of the following, including IsNull and IsError, in the On Current event in both the form and subform and didn't have any luck with disabling the button. If...

I have a search form that users can open an existing repair order or create a new repair order by selecting from the search results that show in a subform. I want to do some error handling and the one procedure I'm having issues with is when a user types in a search and gets NO results but then...

Hey Paul, I've been working on redesigning my Form, NewRepairOrder, with your suggestions, including basing it on the RepairOrders table. You were spot on there. Everything works correctly when I open an existing Repair Order from the CustomerSearch form. I implemented "DoCmd.OpenForm...

Thanks Paul!!! I think I tried some combinations of that but didn't hit on the right thing. Thank you for all the suggestions and the fast response, greatly appreciated. I'll work on implementing them now. -Dustin

Thank you again Tony for all your help, it's much appreciated! -Dustin

Thanks Tony! I haven't received any replies yet. How do I bump it up?

I'm relatively new to the Access journey. I've been using computers since the Zork days on an 8086 with a green screen. :) I'm working on two Access projects now, one at work that I was volun-told for ;). This work inspired me to help out a friend that is using a very old DB that is starting...

Hello all, I'm fairly new to Access but I've been working hard at learning it. I appreciate any help you guys can offer. You have an amazing forum here, and I've already found it invaluable to my Access learning. I’m working on making a fairly simple automotive repair order database for a...