Trying to set up many-to-many relationship with an intersection table, but having trouble with enforce referential integrity. Each table on the "one" side...

Background: I have a database I am rewriting in Access 2000 (split DB) that was originally written in VB 3.0 with Access 2.0. The database has about 70 tables...

Hi everyone I have a spreadsheet I want to import to access. The records are already numbered sequentionally after being sorted in alphabetical order. I...

I am using Autonumber to assign project numbers with a format 07-####, every once and a while it will skip a number example 07-1030 then it skips to 07-1032....

I have a table that contains over a thousand records. The primary key is an autonumber field. The form used to add records to this table, however, has just...

Can someone tell me how make an autonumber field begin at a predetermined starting point? For example, I want the number to begin numbering at 100 instead...

Ok, what I need is an anwser for the following problem: I would like to make a table for several stores, for each store I have a ID wich the user chooses for...

I have created a client database for individual clients, which is working well. My next assignment is to create a corporate database on Access 2000, which...

Hi there, I received some good advice relating to having an alphanumeric reference number, which I have been able to create and it works well in a query....

I have a back end database that contains a number of tables linked to one by an ID field. The ID field ("MainID") is the primary key in tblMain. The field...

Dear all, As a relative newbie to the art/science of database design, I was wondering if there was any consensus view on whether it's better to use an...

We are designing a new database for filing, tracking, and updating projects. These projects will have an alphanumeric id which will something similar...

Is there a way to disable autonumber in Access?

I have a text field PO# which is my key field. Every month the PO# changes (i.e. OCT 2006 - PO-FY601-001, NOV 2006 PO-FY602-001,002,003 etc). I have an...

respected MVPs, i am creating a form for based on table named "MCQ Test Registration" it has field named "RegistrationID" this is autonumber & "EventID" this...

Is there a way to create an autonumber by year, month, day, then sequential number for that day? Something like YYYYMMDD### I'm wanting to "try" and build a...

Can anyone advise whether it is possible to reset the start number on an Autonumber field? I am writting a billing database and it is to follow on from a...

I have a database with a little over a hundred records that we just revamped. My boss wants the new record ID to be an autonumber. The problem is that the...

hi, I have an primary key autonumber field that goes from 1, 2, 3... - 115+ records. I have manually deleted alot of rows till currently left about 45...

Is there a way to set up an Auto Number field that will start at 10,000 instead of 1? Thanks in advance for any help!