Search results

  1. I

    Copy fields data to a new record

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

    Using COMBO Box to Query a second combo box.

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

    Upgrade Access 2000 to 2003 problem

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

    Assign next record number

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

    Record locking error

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

    Locking records in a form

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

    Still need help finding a record where 4 criteria must match

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

    Summing yes/no fields

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

    Switchboard problem

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

    Finding a record where 4 criteria must match

    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, description, type and date. Thanks J
  11. I

    Remove 1 set of dup records

    :confused: I am importing a file from excel into access. The table has about 6300 records. Some records are duplicates or even triplicates. How do I write a querie to leave only 1 of of these records and rmove the duplicates. Second, I will be importing new files weekly that after I do the...
  12. I

    Calculating new date and returning dates within a range

    I am tring to add a number of years to a dob. I'm doing this by adding my date+years*365.26 I get a string of numbers. I then convert the number in the next column to actual date again. I'm getting the correct date. I've tried unsuccesfully to use the dateadd function.Now I want my criteria on...
Back
Top Bottom