Sponsored White Papers, Webcasts, and Downloads
Additional Resources
- Reset ID Autonumber counter field on Table in Access
- Hi, I import data from a text file into an existing table. The text file has no column headings, so I delete all records from my existing table and populate it with data from the text file each tim. I need the ID autonumber field. However, the...
- Tags: chris.chetty@..., DAO, ID, ID Autonumber, Microsoft Access, software, SQL, text-file
- Discussion threads 2005-06-24
- WordArounds for Access' AutoNumber data type
- Access’s AutoNumber data type automatically generates and inserts a unique consecutive value for each record, as you enter data. The process is internal; you don’t do anything but set the data type. There are a few inherent behaviors that you should consider when using an AutoNumber data type: You can’t...
- Tags: Microsoft Office, Access
- Blog posts 2007-04-19
- Access-AutoNumField on ImportSpec
- How do I add an AutoNumber Index Field on the Import Specification in MS-AccessChris, you can't add an autonumber field to an import spec.You need to add the field after the importrun imporrt then to add an autonumber to your table run the following SQL, modifying as required.alter table table1...
- Tags: Field1
- Q&A 2005-06-27
- Access Autonumber
- My Primary key in one of my tables is autonumbered. I have a form based on the same table why won't it autonumber. When I go to the next record it doesn't fill in the next sequential number. Is there a fix for this? What am...
- Tags: ddevans888@..., Microsoft Access, software
- Discussion threads 2005-05-24
- Access weird index
- We have an Access database that has just decided to go wacky. All of a sudden the Primary Key index is creating some odd numbers instead of autonumbering like it always has. Here is an example: "-1183110303". I deleted the records that started appearing with these strange...
- Tags: AutoNumber, ddevans888@..., Microsoft Access, Primary Key, Value at Risk
- Q&A 2005-04-25
- Stop number appearing in memo field
- HiI have a user who has constructed a simple database in Access 2000. The last three fields in the database are number, number, memo.What happens is that if "1" is entered in the first number field, then "2" is entered in the second number field, when the focus is shifted...
- Tags: Databases, Blackcurrant
- Q&A 2005-10-11
- Access 2000-auto fills data
- I'm trying to find out why Access 2000 will auto fill my data entries. I've noticed that after I enter a number in a field that in the next record, in that same field, the next number is automatically inserted in that field. For example, in my Order...
- Tags: Microsoft Office, Databases, Order
- Q&A 2006-04-03
- vb 6 DataReport
- hi,I made a database application by VB 6 and I have two problems:1-I cannot find a way to have one field in my Data report with serial numbers (1,2,3) and in the same time these number should change automaticlly if I add or delete any record2-I have to messages when...
- Tags: Databases, sitaminy@...
- Q&A 2005-08-17
- Alter query in access to add autonumber column
- I cannot add a AutoNumber column in Access By running a Query through the application coded in vb.netuse the following VBSQLcode = "alter table yourtablename add column yourcolumnname counter(1,1);"DoCmd.RunSQL SQLcodeNote the counter(1,1) will start the auto number at 1 and increment each time by one.KindRs,Dan
- Tags: Microsoft development tools
- Q&A 2005-05-09
- HELP! How To VB Form2 Opens Showing Current Record From Form1
- Form1 not datagrid works great (add, delete, edit, scroll, etc..). Form1 uses table tbl_Offenders. tbl_Offenders has fieldkey called CARDS_ID. CARDS_ID is a numeric, autonumber field.Form2 not datagrid works great also. Form2 uses table tbl_Vehicles. tbl_Vehicles has a fieldalso a key called CARDS_ID. CARDS_ID is a numeric text field. Form2 opens...
- Tags: Microsoft development tools, Programming languages, Databases, wbwalsh@..., Microsoft Visual Basic, VB Form2, CARDS_ID, Form1, tbl_Offenders, tbl_Vehicles
- Discussion threads 2007-09-03
- MS Access 2003 Reports
- I've set up a simple database in Access 2003.It has one table with 5 fields. 1 Primary index autonumber, 1 Date field and 3 fields filled from lookup tables.I want a report that will count records in this one table and specifically for the different values of one of...
- Tags: Databases, Microsoft Corp., gasdoc@..., lookup table, Microsoft Access
- Discussion threads 2007-08-30
- Split database question
- I have a split database with the linked tables set up on our server so everyone has access to them. My problem is, I need to link 2 of the tables together for a query but they have a mismatch in the design, one has number and the other...
- Tags: database, mark.silver@..., windows, new field
- Q&A 2006-03-07
- Access Query for next record
- Ok, here's what I got.I have a form used for Data Entry to add records to an Access DB. The table I am adding to has 2 primary keys, taskNumber and taskYear. Both are manually entered. What I am trying to do is when the user presses the Add button,...
- Tags: Goliathkutaa, Microsoft Access, software, taskNumber
- Q&A 2005-06-16
- MS Access Field Data
- I have a fixed length ASCII table that has 55,000 records in it. I have imported the table into MSAccess 2003 and established an Autonumber field as an index. Each record is an ACCOUNT record and has detail about the transaction for each account record.The problem; the first record for...
- Tags: Databases, comrev@..., Microsoft Access, Microsoft Corp.
- Discussion threads 2007-06-20
- Look in field on form
- How can I get Access to look for the last number in a field on a form and add one to that number? (Ex: 258 would become 259)technet.microsoft.com has articles how to do a counter in vb code. which is what i think you want.you would hook macro doing the...
- Tags: Dim curY curY, DLast, lwwilliams@..., programming, Rework Number, rookie, Table ACC2000, technet.microsoft.com
- Q&A 2006-03-24
- Access Programming
- In my access database I have a form with a subform.This subform is used to enter multiple lines of data and ofcourse is all stored in various tables.I want each line in my subform to show an item number, starting at 1 and increasing by 1 each line and the...
- Tags: item number, Microsoft Access, programming, software, Sprocket, subform
- Q&A 2005-04-12
- Work with autonumber
- I would like to give me any example for using auto number in Oracle 10G XE table.I use visual basic 6 for my windows aplication.
- Tags: Application servers, kireandreev@...
- Discussion threads 2007-04-10
- Regarding article: A simple solution for tracking changes to Access data
- I came across this article and it is perfect for my needs. However I have tabbed subforms that when I put the before update event in the subform properties I get a run-time error 13 type mismatch. I am just starting to learn VBA so I am kind of stuck....
- Tags: ithopkinton@..., Microsoft Access, subtable
- Discussion threads 2007-08-07
- Teach your Access users to be wary of AutoNumbered primary keys
- Too often, end users don't realize the importance of choosing the right primary keys for their Access tables. This article outlines the potential problems that can occur when using an AutoNumbered primary key.As an active Microsoft Access developer, I’ve got a good view of one side of the database development...
- Tags: Microsoft Office, Databases, ignorance, Peter Nelson, primary key, Microsoft Access, AutoNumbered
- Technical articles 2002-02-05
- << Previous
- page 1 of 1
- Next >>
