Recent content by twimms

Sorry for the confusion my threads have caused. I did comment in the previous post that I was starting a new one because I was starting from scratch. The confusion shown in my questions is representative of how many times/ways I've tried to accomplish what I need. My head was spinning so much...

Re: Form error handling help needed - starting from scratch I will certainly do that. Unfortunately, I have to leave for class for a few hours. I will post it later tonight though in case anyone would like to check in later. Any additional help I can get in understanding this would be...

Re: Form error handling help needed - starting from scratch Sorry if my post was confusing. I am starting the code for these particular issues from scratch, yes. I understand what Steve is trying to do and I appreciate his input, but to be honest his code is way over my head. I was really...

Re: Form error handling help needed - starting from scratch There is no specific command button for what to do when the user has completed the form. Instead, the user chooses one of several command buttons depending on what they want to do with the data next. Because of this, I assumed the...

I have a form with several required fields. I have created a custom message in the before update event of the field that gives the user a friendly message if any of the required fields are left null. It works fine. However, an additional error can be encountered that states "You cannot change...

Thank you for the offer of help, but actually that won't be necessary as I've figured it out. I'm completely embarrassed to even admit this, but apparently my ADD was kicking in hard today. I created tblCaseDetail in an older version of the backend that I use sometimes for development/testing...

Bob - I appreciate the fact that your code is more up-to-date. I simply stated what I had used first. I tried my code first. I then took it out and tried the code you supplied with no better luck. So, while I will use the code you provided in the future, I'm afraid it had no impact on my...

Just tried it...no luck though :(

Thanks for the suggestions. Bob - I tried your solution, but it didn't work for me. PNGBill - No, this isn't a form/subform situation. I'm using a command button to open frmCaseDetail and trying to insert the required ID number from tblCase (that is - the current record on frmCase) into the...

I have a 2 tables (tblCase and tblCaseDetail) linked via CaseID. CaseID is the Primary Key in tblCase and a foreign key in tblCaseDetail. Referential integrity is enforced and there are currently no records in tblCaseDetail. I have a form (frmCase) that is used to display data from tblCase...

I have a continuous form with a command button to delete whatever record the user needs deleted. It worked perfectly until an addition to the database required me to change the record source of the form slightly (I had to add a left-join to another table). Since that time, although it appears...

Hi! I'm hoing you all can give me some help here. I have multiple listboxes on my form. When a user selects data from the listboxes, the choice is highlighted. But, if they move on to a new record, and then go back to the old record, the choices they previously made are no longer...

Hi...Newbie here! This might be long, but I want to be clear... I'm working on a database for my agency in which clients are assigned to specific staff through use of a staff id number. For administrative purposes, we have one *generic* client that is not assigned to a specific staff member...

I should have searched a little harder before I posted. Found the answer in another post... Thanks anyway! :)

I have a similar situation as the previous post about crosstabs. Same type of error message, "Microsoft jet does not recognize [1] as a valid field name" etc. My particular query has worked in the past, but no longer...Not sure why. I have posted the problem field below in hopes that someone...