Search results

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

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