Sponsored White Papers, Webcasts, and Downloads
TechRepublic 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
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
- 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
- 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
- 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
- Combine Records in MS Access
- Greetings,I've created a database for my office, but it needs some improvement. For each record in my database, there is the AutoNumber ID, and there is a unique subject ID for each person in this database. Sometimes, individuals are entered more than once w/ different IDs, but a...
- Tags: Social Security, Storage, Databases, Operational accounting, n.smith326@..., Microsoft Access, Microsoft Corp., W/O, database
- Discussion threads 2007-09-07
- 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
- 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
- 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
- Combo Box Trouble
- Hi guys,Here is code I am using to populate a combo box from the table. Set cnnConnection = CurrentProject.Connection Set rstRecordset = New ADODB.Recordset strSQL = "SELECT * FROM Country ORDER BY Country" rstRecordset.Open strSQL, cnnConnection, adOpenDynamic, adLockOptimistic...
- Tags: carterlangley@..., id
- Discussion threads 2007-04-02
- 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
- to recover yahoo id and password
- i am trying to open my yahoo id but it is not opening... it is hacked by someone...A few things to check...Are you typing your ID & password correctly?Have you got CapsLock turned on?Have you got NumLock turned on?If you have forgotten your password did you have a secondary email...
- Tags: ramji_londonwale@..., password, Yahoo! Inc.
- Discussion threads 2007-05-30
- Raffle Tickets
- I want to have it so that if some one pledges £5 on one table. At the click of a button another table is updated with 5 tickets allocated to this person.check out how this is done with the indispensible northwind.mdb sample database free for download from microsoft. the really...
- Tags: simonevans31@...
- Q&A 2005-01-26
- Pass Variables betweent forms
- I have an access database the is used to track project status. The part I am having trouble with is passing variables between forms. I have my project form and it has a subform that displays the tasks for the related project. The project ID would be...
- Tags: Programming languages, Databases, C1-1
- Q&A 2006-02-06
- login problem in 2003 domain server
- I'm having problem login to my domain server after expering user's id password my clients using windows 98. i have create new user id in server & try to connect with that user id it doesn't allow me to login. but it allow to login with other's user id. but...
- Tags: kath_man85@..., user-ID
- Discussion threads 2007-06-11
- DISK ID IMPORTANCE
- I have 5 disks configured for RAID5.[ID 0-ID4]If any expert could explain whether or not there is differencehigh or less importance between the Disk drives ID i.e! SAY..Does Disk Drive ID:0 have greater significancein case of recovery than the the other disk drives in the RAID5?say for example my...
- Tags: sma_ag@..., disk
- Discussion threads 2007-11-11
- My hotmail Id HAcked..
- sombody hacked my friend's Hotmail ID..he change my secret question..and also my location..How can i reover that..Plz Help me..BrahmPoint value changed by question poster.Call Hotmail technical support for assistance...Only way to fix this is to call hotmail support. When they fix it change your pw. don't use words....
- Tags: E-mail providers, id
- Q&A 2004-12-14
- << Previous
- page 1 of 1
- Next >>
