Search results

  1. G

    How do I change primary key

    Hello, I have a database in Access 2000 that was written somewhat hastily. I would like to make some specific repairs. There are 2 linked tables. 1) tblContacts (containing contact info including street address without city, state, and zipcode) 2) tblTowns (containing city, state, zipcode)...
  2. G

    How to determine what objects use a query

    I would like to know how to do the following: Query 'X' is a sum query. How do I determine which other queries use Query 'X' I want to make some changes to Query 'X' but I want to be sure of which other queries will be affected. Thanks
  3. G

    How do I display array contents to user?

    I am using an inputbox( ) to accept job numbers to include in a particular process in a database. Each Inputbox( ) value is inserted into an array. After the user enters the last value, I would like to display a list of all of the values entered so that the user can confirm. The list does not...
  4. G

    How do I enter list into combo box for lookup?

    Hello, I have a database filled with "jobs." Each "job" contains information and a "job Number." I would like to, in a form using some sort of combo box, etc, enter a list of job numbers to make an identical change to. Example : I would like to change the salesperson_name for job # 12345...
  5. G

    How to Incremenet without Autonumber ?

    Hello, We are running a database that is accessed by up to 4 users at any one time. The main table (tblCaseData) in the database has a primary key (JobNumber - long integer) that is incremented without the use of Autonumber. The below code updates that number when a new record is saved : Set...
  6. G

    How do I scan sheets with barcodes into a DB?

    I would like to make a simple DB that stores handwritten information sheets for future recall. My stumbling blocks are: 1) How do I scan a sheet into Access? 2) Each sheet has a bar coded ID number displayed at the top. How can my DB read that bar code (without a barcode wand, etc...) off of...
Back
Top Bottom