I use copy and paste to duplicate tables to ensure a consistent structure for importing data from text files. Since I've switched to SQL to handle my databases...

Hello there I have table. Is there a way to add auto number field to table with vb code?

I had a question posed to me yesterday by someone in another deparment. I work in the IS department and just started working on ACCESS databases for...

I don't understand this. There must be a setting I can change somewhere. I have a spreadsheet with 294 fields. I use an import specification to bring the...

Upgraded to Access 2003. In Access 2000 I used to be able to insert a picture into a form, now I find I can only get a reference to a picture which when...

Is there a way to have only positive numbers in an AutoNumber field set to random? Thanks in advance, Matt

There doesn't seem to be much information around about Access Pivot Tables, and I don't do much in Excel. I'm specifically looking for how to do this ...

I have been told that you can improve performance of an Access database by turning off the Subdatasheet Name property of the tables that don't require this...

Hello. If I link a table to my Access DB from another Access DB the absolute path to this DB is used. When I upload the database to the server, where I...

Good Afternoon, I have a DB which tracks training of employees. The grace periods allowed with the training is that new training can be completed within 90...

My Office 2003 no longer works . it is asking for pro11.msi After searching my comp I find that it is no longer in it. any suggestions? (I don't have...

I have a Table called SNEEZE. It contains 6 fields eg A (date),B(name),C(invoice),D(details),E(units),F(price). Fields A,B,C are static and D E and F change....

I have a user who needs to put up to 25,000 lines of data in a table a year. We will be generating weekly and montly reports from this database. They have...

I ran an corrupted mdb through a third-party recovery utility and it recovered the tables but it changed the AutoNumber fields to Longs, all 200 of them. Since...

I split a database and made the install package with the developer extensions. I do encounter one problem and I just want to know if that is part of the...

I know this is 'off the wall'. I have to come up with a couple interview questions for a client to determine if an applicant is qualified technically to do...

I would like to be able to type a zip code into a form, and have it automatically return the City and State into their respectiver fields, or enter the city...

In my database, I have a Suppliers table and a Product table. A main/sub form is made based on these two tables. Supplier_ID is the primary key in Suppliers...

I have Office 2003 but need to keep a database in the 2000 format. When I go to linked table manager, it does not show any of the linked tables, however, if I...

I created a db in Oracle and then linked the tables in Access 2000. I'm having a problem with the triggers that I created in Oracle. Only one of my triggers...