Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- Sequential Numbering in MS Access
- I have a table with existing Job_Numbers.(17 Job numbers). Each month I will match this table with another new table via the serial number. For each new record, could be one or many, I want to apply a new sequential Job_Number. i.e. in this case start at Job_Number 18 then...
- Tags: AutoNumber, AutoNumber Field, Microsoft Access, Microsoft Corp., rhouse@..., software, temporary table
- Q&A 2005-10-11
- 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
Additional Resources
- 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
- 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
- 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-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
- 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
- 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
- Access Database
- I am working on a software inventory database. I have run into a major problem. I do not know how to set it up that I can enter in 1 software type with more then one license key. I have my main software table then there is a license table...
- Tags: Tools & Techniques, Databases, Microsoft Access, CookieOrc@..., software, database
- Discussion threads 2007-10-25
- 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
- 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
- Autonumber Macro that disables when file saved?
- I have a macro on an excel workbook which increases the document number in a Cell by 1 each time the file is opened. However when that file is then saved as number X and then re-opened it becomes X+1. However i need the file to stay as...
- Tags: charlie-cooper@...
- Discussion threads 2007-11-15
- 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
- Ease Access database maintenance with the Alter Table command
- do it in table designWhile not just alter the table in table design. Seems quicker then typing SQL code in a query.You have to be careful with some gui table designersInstead of executing a number of alter table commands they create a temporary table with the new structure, construct an...
- Tags: ALTER TABLE, database, hardware, Microsoft Access, solson@..., SQL, table design
- Discussion threads 2006-03-16
- 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
- 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
- ACCESS 2000 - TEXT/NUMERICS
- I am making a list ncorporating letters and figures such as:N1201PN20EGN249AUN41135N42NAN6391CN642XLI need it to look likeN20EGN42NAN249AUN642XLN1201PN6391CN41135Ant ideas how this can be doneThank youWell I can't see any logic to the orderAdd another column of type integer. Number the items in the order you want them to come out and sort...
- Tags: mickparsons4428@..., Microsoft Access, off-topic, security
- Discussion threads 2007-02-26
- 10+ tips for designing flexible and efficient Access tables
- The way you build your Microsoft Access tables makes all the difference in the world in terms of performance and reliability. These concise guidelines explain how to effectively employ Access tools and features to make sure your table design is optimum. Access expert Susan Harkins offers practical...
- Tags: Microsoft Access, Microsoft Office, Databases, Office Suites, Software, Enterprise Software, Data Management
- Download resources 2007-03-08
- 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
- Autonumbering Problem
- I have two forms that populate one table. This table's primary key generates an autonumber. Everything works fine (ie: a new number is generated for each new entry) except when I go to close the form after the entry. Doing so generates a prohibiting error message:"The changes you requested to...
- Tags: logregg@...
- Discussion threads 2007-08-18
- << Previous
- page 1 of 1
- Next >>
