I'm trying to figure out the following in order to get around the 255 field limitation per table: Table:Details Table:Apps When a record is created in...

Hi I would like on a form, to complete some fields. EG am detailing an order placed by a customer. The customer details are stored in a seperate table. I have...

I have a table with all my employee's information, name, date of hire, ssn, etc. I have a table I want to use that will track there leave of absence,...

I have a file I am importing into a table and if the number begins with one or two 0's they are missing from the data in the new table. How can i set up the...

I have a table called 'client'. In it is a field called dateclosed. There's also another one called 'casestatus'. When someone enters a date into the...

creating a vehicle servicing database (300 vehicles) vehicles have annual MOT and 6 monthly servicing intervals. Am trying to set up a database/spreadsheet...

It's not good database design to have hidden data in a column e.g. the year 'hidden' in a primary key. Stick with the autonumber primary key and put the year...

Is there a way to automatically increment a numeric field when a new record is created? I want to do this with an existing field, if possible. For...

Simple question, hope I can get an answer.... Ok, I have created a table and form for our company to keep track of incoming inventory. Being that we work...

I have two datasheet forms, one linked to the other using a textbox link. The fist datasheet form I have an auto increment field, and working fine. In the...

hi i have a table called invoice. the primary key supposed to be not only a number, but also a string. i thought of making the primary key as follows....

Hello all! Newbie to Access 97 here. I'm trying to figure out how to automatically increment a specific alphanumeric so I can have Access 'assign' the...

I have following tables tblcoursepayment with autonumber invoice number field. tblitemSalesPayment with autonumber invoice number field. how can I generate...

Ok, with my DB everything is hinged on the "Log Number� This is the number that is the relationship between most of the forms/ and sub forms/tables. This...

Is it possible to set an auto number in a table , which is the primary key, to start with a defined number say...1000. Thanks

I have two tables one will house the main account information and the second will have the monthly amount charged, on the second table, I want an autonumber...

I am using Access 2003. I need a column where the number increase by 1 for each new record. I created the file as an "autonumber" type but can not remember...

I have a auto number field which works. Since I am on the test step, I need reset it while I am testing. any way to reset to 0. Thanks in advance,

Hey guys, I have a key number that I need to create a sequential number based on that number. For example: C-202743 and when you enter new record I wanted to...

hi all !! i need to have an auto number in a new table but i need the auto number to start from a certain number not zero. how can i do this ??? any help...