I am trying to create an AutoNumber that will begin at a number that I specify. I have followed all instructions in MS Access Help, but it is still not working. I continue getting an error message that 1 record has a validation rule problem, but I cannot figure out what it is. I don't have anything in the validation rule fields on either table. I've checked everything in both tables. What can I be missing? This is very frustrating...
I am simply trying to set my AutoNumber to begin at 1000 instead of 1. My temporary table begins the numbering at 999 and is a "Number" in the field type. My primary table that I am trying to append to is field type AutoNumber. The field names in both tables are the exact same.
HELP!!!
5  4593   FishVal 2,653
Recognized Expert Specialist
I am trying to create an AutoNumber that will begin at a number that I specify. I have followed all instructions in MS Access Help, but it is still not working. I continue getting an error message that 1 record has a validation rule problem, but I cannot figure out what it is. I don't have anything in the validation rule fields on either table. I've checked everything in both tables. What can I be missing? This is very frustrating...
I am simply trying to set my AutoNumber to begin at 1000 instead of 1. My temporary table begins the numbering at 999 and is a "Number" in the field type. My primary table that I am trying to append to is field type AutoNumber. The field names in both tables are the exact same.
HELP!!!
Hi, there.
No matter whether field names of both table are the same or not. Access refuses to append records bkz you try to set value of appended records autonumber field which by all means is read only.
If you don't care your temporary table numeration will be replaced with autonumbers, then exclude temporary table number field from the append query.
Regards,
Fish
Hi, there.
No matter whether field names of both table are the same or not. Access refuses to append records bkz you try to set value of appended records autonumber field which by all means is read only.
If you don't care your temporary table numeration will be replaced with autonumbers, then exclude temporary table number field from the append query.
Regards,
Fish
Fish-
I still don't see how this will work. If I exclude the temp. table number field from the append query, then how will I accomplish my end goal, which is to customize the autonumber field in another table to begin with 1000 instead of 1.
Thanks,
jnice
If you've got Table1 and the autonumber field is ID: Create a new query, don't add any tables, but switch into SQL View and paste in this, and then run it:
INSERT INTO Table1 ( ID ) SELECT 999 AS Expr1;
After you run that, subsequent appends will begin with 1000. After you do your first append, you can go back and delete the 999 record.
Hope that helps.
FishVal 2,653
Recognized Expert Specialist
Fish-
I still don't see how this will work. If I exclude the temp. table number field from the append query, then how will I accomplish my end goal, which is to customize the autonumber field in another table to begin with 1000 instead of 1.
Thanks,
jnice
Add dummy records until autonumber get to 999, then delete them, then run your query.
wvmitchell-
It worked!!! thank you, thank you
Fish- thanks for your helping get to the right direction as well.
Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: John Baker |
last post by:
Hi:
I know this is a strange question, but I have inherited a system where files are copied
and records re auto numbered (as an index field) )frequently, and I am wondering how high
the number can go without the system crashing.
An ancillary question is how one resets an auto number so that the sequence starts again
at 1.
In the case...
|
by: jonhanks |
last post by:
I'm trying to copy a table and its structure from DBase into Access.
One of the fields is a primary key and contains numbers from 0 to 20000
and then from 30000 to 40000. How can I make this column in access an
autonumber? Because the data is already set to a 'text' field, access
wont allow me to change it to an 'autonumber field'.
Any...
|
by: mathilda |
last post by:
I have a situation where I need to put back in a deleted record to a
table whose primary key is an Autonumber. And of course the autonumber
has to match what it was before. Any way of saving my butt on this one?
|
by: M Fisher |
last post by:
Is there a way to get the autonumber of a newly inserted record?
I am working with unbound forms, and using an append query to insert a
record into a table. I am then using a select query that returns the max ID
(the autonumber field) of the table. This gives me the correct number.
However, could this go wrong in a multi-user environment. ...
|
by: marko |
last post by:
I would like my autonumber field to start at 100000. How can i do that?
| | |
by: Alan Mailer |
last post by:
A project I'm working on is going to use VB6 as a front end. The back
end is going to be pre-existing MS Access 2002 database tables which
already have records in them *but do not have any AutoNumber* fields
in them.
Correct me if I'm wrong, but I'm assuming this means that I cannot now
alter these existing Access tables and change their...
|
by: Tom_F |
last post by:
To comp.databases.ms-access --
I just discovered, to my more than mild dismay, that some tables in my
Microsoft Access 2003 database have duplicate numbers in the
"AutoNumber" field. (Field Size is set to "Long Integer", and New
Values is set to "Increment".) I know that an old version of the Jet
database engine can cause this problem,...
|
by: PeteCresswell |
last post by:
Got a table with "RecordID"=AutoNumber=PrimaryKey.
Call it "tblIssuerRating".
Ran a query that appends to that table from a work table.
Inadvertantly appended from the work table's "RecordID", which was not
autonumber and, in fact, contained a zero.
The query ran successfully and I would up with a tblIssuerRating
|
by: ashes |
last post by:
Hi,
I am creating an ecommerce website using Microsoft Visual Studio, VB.Net and MS Access 2003. I am new to VB.Net
When someone wants to register on the website, they fill out a form and the contents of the form is inserted into the MS Access database.
The Customer table in the database already has 30 records (with CustomerIDs 1 - 30)...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language...
| | |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it. ...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...
| |
