I have a table in Access which is auto populating fields which I do not want to happen. If I list a number in a field, and then another number in the field below it, and then a third number, if those numbers happen to coincidentally follow a pattern (for example, 10322,10324,10326), the fields below are auto populating to follow the same pattern. I can't seem to figure out how to shut that off--it must have been a default because it wasn't purposely set it up that way. The whole table is set up that way.
It's Access 2003 that I am using, but the table itself was conceived in an earlier version some years ago.
I tried looking for how you DO set it up to do this, and then I would be able to undo it. But I have not had any success.
2 2558
I have a table in Access which is auto populating fields which I do not want to happen. If I list a number in a field, and then another number in the field below it, and then a third number, if those numbers happen to coincidentally follow a pattern (for example, 10322,10324,10326), the fields below are auto populating to follow the same pattern. I can't seem to figure out how to shut that off--it must have been a default because it wasn't purposely set it up that way. The whole table is set up that way.
It's Access 2003 that I am using, but the table itself was conceived in an earlier version some years ago.
I tried looking for how you DO set it up to do this, and then I would be able to undo it. But I have not had any success.
1) if this is an autonumber, then this is an expected behavior
2) if it is NOT an autonumber, then check the default value in the field properties to see if there is any kind if incrementing code. If so, remove it?
Are you sure that this functionality isn't needed throughout your DB??
Make a backup before you do this.
J
This appears to be a 'helpful' feature of MS Access. I can reproduce it as well (using Access 2003). However, it only shows up when entering a patterned value, then down-arrowing to the next field in the same column. If you tab to another field, it won't show up, if you up-arrow, then return, it doesn't show up.
This all is a little aside from the main point, though, which is that you should strongly consider interacting with your data through a form, not directly with the table... You can build in more levels of data validation through forms than you can in a table. If this is a database that other people would be working on, then you should definitely not even consider letting others input data directly into the tables.
Regards,
Scott
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: David Shorthouse |
last post by:
HI is it posible to auto populate an access database.?
I have 1 table structured
Index_ID. - Index & auto number
First_Name - Char50
Surname - Char50
Initals - Char50
Postcode - Char50...
|
by: BK |
last post by:
Hi,
I have a problem. I need to auto populate fields based on a value
entered in combo box. Initially, I put all the required fields in the
combo box, and hide it (set to 0",0",0", ...), then...
|
by: Jim |
last post by:
I have a new database in which I have a form where in one field I type
a letter A, B, C or D and the field next to it autofills (auto lookups)
with a description associated with the specific...
|
by: jacklindsay |
last post by:
Hello smarter people than me
I am creating a database for college, and have requested some help, but they are unable to help me. ( im obviously too eager)
anyway, im creating a database on...
|
by: joshua.nicholes |
last post by:
I have an access database that consists of two tables.A data
collection table and a species list table. The data collection table
has about 1500 records in it and the species list has about 600....
| |
by: zeilak |
last post by:
I am running Windows XP, Access 2002.
I want to know the VB code for the following:
I want to type in the ID # (it's the primary key and is auto-numbering) and then have the access form...
|
by: scolivas |
last post by:
I think this is a me thing. but can't remember how to do it.
I have a form that I am using and would like for a txt box to automatically populate based on what is selected in a combo box.
here...
|
by: whamo |
last post by:
I have the need to populate a field based on the selection in a combo box.
Starting out simple. (2) tables tbl_OSE_Info and tbl_Input;
tbl_OSE_Info has three fields: Key, OSE_Name and OSE_Wt...
|
by: paulyXvpf |
last post by:
Hi All,
FACTS:
> I've created a VB.NET 2005 form, with a SQL Server 2000 backend
> The form has about 30 fields that populate 30 columns in the SQL database
> The form has mostly text feilds,...
|
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...
|
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,...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
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...
|
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...
|
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 ...
|
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...
| |