Recent content by glenn69

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

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

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

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

To answer the question of whether it matters that the numbers are contiguous...Yes, because it determines invoice numbers. The IRS frowns upon missing invoice numbers when declaring income. So it is important.

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

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