I have a form in which auditors complete error information for data entry techs. In many instances the next record will be the same auditor and dadat entry tech. I would like to create a button that will make the next record auto fill the data entery tech and auditor name. This will make it...
Still need help
The article was helpful in that it showed me how to use cascading combo boxes. I need to know how to write the statement that makes the second box only return items that begime with the letter selected in the first combo box. Any help is appreciated.
Thanks
John
Hi I am a new user. I'm sure this is simple but I just can't get it. I want to use a dropdown box with letters A-Z to return records in a second drop down box that begin with the lettered selected in the first dropdown box.
Any help would be appreciated.
Thanks
Hi
At work I was just updated to access 2003. I am trying to update a data base that I created in access 2000. Whenever I try to open a data access page I get the following error. "The installer encountered an internal string error. Installation failed." I've updated the Web components and that...
I'm using a form in acces 2003 to enter data into a table. I'm using auto numbering in my table. I want to create a macro that automatically assings the next number when the form is open. presnetly a number isn't assigned until data is entered in the first field and the field is exited.
Thanks...
:confused: I created a data base in which 4 users enter information using a form. I have no record locking applied. When 2 or more of the users enter the form at the same time but have not entered any information they get a record lock error when one of them tries to enter data. The company...
Be sure the Options | Advanced "Default Record Locking" 'No locks' radio button is pushed.
The settings are set as you indicated but it still happens. I think it's becasue meither person is actually in a record. They are both on a blank form and haven;t started to add a record yet. When one...
We're using access 2003. It happens when 2 or more open the form in add mode. A record number isn't assigned until the user enters the first bit of data to the form. If the first person to open the form (in add mode) doesn't enter any data and a second person opens the form in add mode they both...
I have 4 users entering data via aform. The database is located on a shared drive. They are getting errorsthat the record is locked. I believe this happens when 2 or more people open the form and are trying to enter data at the same time. Is there a way to have each person lock a new record on...