Hi, I have a table that already has about 55,000 records. I want to add an autonumber in order for this table to have a uniquID field. However, I want it to...

how can I rename a column in vb6 code using either ADO or a SQL statement? the database is Access 2000.

I have compiled my data into several tables (maybe cart before the horse), that includes the following: Airport Table.. (All "From" and "To" airports are...

Good Morning! So I finally got the invoicing database done that my boss requested (which was quite a challenge because I'm a beginner :-)), and now he would...

I have the following problem: When I try to enter data in a date time field of a new record, I get the following message: "The value you entered isn't valid...

For many years I have been using a ledger based on the Northwind sample database, and this has the...

I'd like to modify the sample MS Assets management database to include a history of asset ownership. For example, if a user is assigned an asset (such as a...

I have a DB that will keep track of employee info per their supervisor. I will create a FE for each user but I'm not sure how I should create the table. ...

I am a new Access user. I just got the program and some tutorial books. I am not sure how to relate my tables. I have 3 tables: 1) tblLender (Lender...

Hi...need help again.... Access 97 database. I have a form for associate work hours. As associates work a trailer, they put down their name, start date,...

I have a database with four tables that I use and each month I get a new database with the same four tables in them with updated and current data. I have...

I'm trying to create a database for a construction company I work for, i can't seem to figure out how I can make the table share similar information. Any...

My primary table in 2003 will store numerical inputs for (2) types of instruments. Instrument #1 only requires an ID field plus 3 fields for test points. I...

I work at a health center where there are numerous research studies done. Part of my job is software support, and while I keep reading everywhere that...

I am trying to take a date field and a text field and combine them to make a third field , which would be an Invoice number. The problem I have is the date...

Is there a size limit to Access 2000 Databases? I have a database that has over 40,000 records. Ordinarily I wouldn't think that was a problem, but I ran a...

I need help in defining the logic on this busines flow: Invenory arrives on a INBOUND TRUCK and is documented on the Inbound Form as ONE TRUCK ID to MANY...

Greetings We are developing a complex system, which will run on Oracle, MS SQL Server and MS Access databases. All the databases are to be replicated. We are...

i'm trying to get dlookup to pull a value from a query in the details section of my report. this way, it will reflect the value i need it to as the groupings...

Does anyone have any tips on minimizing front end growth in fe/be splits? In specific, I noticed these: #1: While under development, my db's tend to grow,...