I would like to allow an employee to work off the network on a copy of a database with an autonumber field. she will need a copy of the database...

I have created a look up from another table in a database that I am redesigning. I made a few changes and then went back to the original table and found that...

Hi, Iam trying to do a project for uni and i need to have a letter infront of the id number that is generated. pls help! I have 15 unique ids and 3...

Hi All, I have an ID field that is an AutoNumber. This database has been working well. Know all of the sudden the AutoNumber is trying to re-assigning...

Hey guys, I need some help very bad. I'm creating a registration database for a convention. I've created 4 tables. There setup is...

I have a primary key in a table that contains records input via a form. This data is then transferred to another table for storage and is deleted from...

I created a database for a certification authority meaning that all certificates must have a continuous numbering. My client reported that today the database...

Hi, i am creating a database and i'm not that experienced at present. i a mcreating tables ok but cannot get around this problem. as i am planning...

Hello, I have created a Linked table via ODBC. My ultimate goal is to create a 'differential' report in Excel. By this I mean I want to display data that...

Hello, quick question for you all Is their any way to use referiential interigty with autonumber fields? I can't use Autonumber with assoative entities,...

Dear whoever-can-help, I have a table of customers within an Access 2000 database, each with a unique reference number (autonumber). As this table is...

I am trying to design a database for my company, but my knowledge of access is somewhat limited. I have two tables: Customer (which holds all of the customer...

I am working on a database which holds details of clinical studies. The main table holds the main data and is the ‘one’ of the relationship with...

I have a table with an autonumber key which has records with autonumber 1-75 I need to import to this table some older records which must have earlier...

I want my auto number to be in the form of todays date and then the record number e.g., 10070901. If I enter a new record tomorrow, I want it to start with...

I have a databse that uses autonumbers for a specific field. Over the years several have been deleted for whatever reason. is there a way to make access go...

I would like to design a DB which would track the expenses of 40 customers ..The problem is i need to understand the concept of using the autonumber or the...

I have a table called tblProject with a primary key JobNumber. Another table, called tblPunchItems has fields JobNumber and PunchID on the "many" side of a...

Hello, As far as a Primary Key is concerned (for an Employee Table) I have read numerous times on the boards NOT to use the Auto Number feature, I'm not sure...

I have a table with an autonumber that I need to start with the number 20801. Access help says to change the New Values property. I don't see that property...