Search results

Worked like a charm. Thanks alot.

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

Thanks That did it. Thank for your help

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

Thanks Thanks going to forms property and changing to edit record did the trick. i appreciate your help:) :)

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

still need help I'm still stuck on this anyone have any Ideas? Thanks j

Default open mode is shared. Default record locking is no locks Open data base using record level locking is checked.

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

great... Thanks for your help John

-------------------------------------------------------------------------------- How do I set up a search on my form where 4 fields must match exactly to return the correct record? I must match - persons name (text), description (text), type (text) and date (date). I would always search on all...

How do I report on the number of times yes or no was selected on a given record. I have a data base where I'm collecting information on errors made. I need to report on which errors were overturned and who the auditor was that called the specific error. I also need to summary giving how many...

Yep I still need help. The other 3 fields are al text field. I pretty new at this so I'm sure about SQL. I was trying to do this with a macro. Thanks for your help. J

I created to switchboard to open other forms used in my database. It works on all forms but one. When I try to use the switchboard to open this one form access freezes up and I have to exit the program. Anyone have any Idea's why this would be happening? Thanks john :confused:

I'm guessing the criteria will need to be all 4 fields must match exactly. Then return that record. I need to be able to find the correct record to add additional information to other fields. I will have all the info for these 4 fields when the record is created but won't have all the other info...