Hi I need help with my Access database. I have an autonumber column which was working beautifully...until some one imported data from a text document which created an error in this column. So now instead of the numbers counting up in order, i.e. 2218, 2219 and so on, there is a new, larger number ie, 3376546 in the column and that is starting to count up with each new entry. how can i get back to the original autonumbers? I have tried deleting all the data with the wrong numbers, but everytime I try to put data back in the wrong auton numbers starts to fill in in the column!! HELP!
smat
I'm getting a unique error when I attempt to add an AutoNumber field to a table that I created. The table itself has ~110,000 records but it will not let me create an ID tag for the records so that I can create a primary key.
I have two tables linked to each other in one to many relationship. Instead of auto number, the date and shift (Text) is being used as the primary keys (Composite Primary Key). Here is the tables structures,
The tables Payouts and Bills has one to many relationship. One payout row can have many bills. The problem is that I want to start the Autonumber in bills table everyday from 1. As date and shift are different for every day so even if i start bills from 1 everyday, it wont make same primary key. I can do it manually but I want to make it automatically.
Has anyone had this problem: You make an access mdb database "X" with table "A"- which includes autonumber field and few more fields (text or something else). Than You make another mdb file "Y"- which contains link to table "A" in mdb file "X". When You open mdb file "Y" and You open linked table - You can not see data from the table - instead it showes "Autonumber" (text) in every field (autonumber field and other text fields). Then You close the linked table and open it again and everythnig is ok. And every time it shows this error on first opening. On another computer (with the same windows instalation) everything is ok. I tryed to reinstall windows (on the machine with the error) - clean install - and the problem is fixed. Another time I install the same windows again - and the error is back. Then I reinstall the windows again (clean install) - and this time error is still present. I tryed to install another access (2003 instead XP) - but it doesn't help. What is going on ?
I have a question. I would like to be able to have an autonumber in the main form be applied to text boxes on the subform. So If I enter a name in the main form, an autonumber is generated, then that number is automatically entered into the boxes in my subform. My subform is a datasheet view with many records. I want all the records to have the autonumber generated in the main form. Is there a way to do this. Currently I have the boxes in the subform retrieve the autonumber by setting it equal to the autonumber text box on the main form. I would think that there would be an easier way to accomplish this seemingly simple task.
hello, I am using SQL INSERT INTO where I insert values from my form Me!value1 etc I have an autonumber in the table where I am using INSERT INTO, and when I exclude the autonumber it says that the number of columns does not match. I tried assigning a number manually in SQL and it works fine, but I can't use autonumber anymore. Is there a way to use autonumber and still do INSERT INTO or is there a way I can find the highest number and put the next highest in there through VBA?
How do I assign an autonumber to a table after the table is created. I know it ask after you create a table, but I answered no. Now I want it to assign each record an autonumber?
Is there any way you could renumber the autonumber, I have deleted some records in my table and the numbering orders have a gap and I would like the numbers to rearange automatically as the record or records are deleted.
I have a problem which I couldn't solve. I have two tables. There're relationships is one to many (1:N). The first one is Order and the other one is OrderItems. Order(order_ID,...) and OrderItems(order_ID, lineitem,...). The compound key of the relation OrderItems is order_ID and lineitem). What I exactly want? I want for every new Order_ID to have restarting count of lineitem.
I have a fairly small database I recently built that includes a particular table in which I meant for the primary key to be an Autonumber field. Apparently I forgot to set it this way and it currently sits as just a Number field. There are nine tables in this database with a couple hundred records in the main tables.
Is it possible to change this field to an Autonumber at this point? I have attempted to change it and it wants me to remove all the relationships. It also seems to be necessary to copy all the records out before reseting and then copy them all back in or it will not let me proceed.
Will doing it this way work? Is there a better way to do it? Please advise. Thanks.
Good Morning, Is it possible to have an autonumber field start at a given number, say 9999999 and count backwards?
I have a program that is generating badge ID numbers but I have a bunch that already exist and going backwards seems like the easiest way to mesh the 2.
Id like to know if there is a way to create an autonumber field via a create table query. ive been searching a lot but without any success. any help would be appreciated.
The record I was using as a key changed from an incremental to a random number. When I try to change it it won't allow me. I created a new project and imported the tables from the old one but all the attributes followed. Short of starting from scratch, what can I do to change back to incremental autonumbering.
I am creating a database for my company to register projects. And each project needs to have a unique Project ID number, which (due to the conformity of another software tool) must be 4 characters long. The first character is a specific letter based on the group the project is created by, followed by a 3 digit number. So, for example, one of the group code letters is C, so the first "C Project" would have the ID 'C001'.
I want my database to assign these automatically after selecting the group.
I have a autonumber function in my form, but i have deleted all the records and want to start again but the autonumber has not reset back to 1, is there a way to do this??
I have an access database that I have used autonumber to assign order numbers for several years. I am now wanting to split the database and it is causing a problem with the order numbers. My situation is different than other posts because I delete orders from the table when I assign serial numbers, but I still do not want to use that order number.
Example: Enter order number 1000 Enter order number 1001 Assign a serial number to Order 1001 and delete that record. Enter a new order, need order number to be 1002
Because I delete 1001 but still do not want to use 1001, I can't use any max number function that I've seen in some other posts.
Could I make a table to somehow keep track of the next order number. I am not very knowledgeable about access so please bear with me.
I have genreated an autonumber in my table, at this is used as key. after importing 135 records it starts to jump 48 records before it creates a new. This means that with every record i import after 135 i have a space of 48 between each. So what sort of thing can cause this? and even better how do i fix it?
