Database Design - Page 59 - OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

		Home » OfficeFrustration forum » Microsoft Access
Database Design

Home

Page 59 of 581

Threads in Forum : Database Design

Forum Tools

Search this Forum

Thread / Thread Starter	Last Post	Replies	Views
Autonumber Already Exists by Tom[_6_] All, Anybody ever see an autonumber in a small table (3000 records) create an autonumber out of sequence? I can't add a new record without getting an error...	August 6th, 2008 09:31 PM by John W. Vinson	5	147
Autonumber and record adding abounding by A.Niaki In a table, I need a field as a counter of each record, unique, sequential and sorted by the sequence of data entry of each record; the field by autonumber...	April 29th, 2006 10:22 PM by Steve Schapel	1	106
Autonumber as primary key by J E Jensen Hello NG I have a huge access database that is maintained with a rather old application (VB6). The way the data is maintained is by using RecordSet.AddNew...	September 10th, 2009 03:30 AM by Allen Browne	8	223
AutoNumber behavior in linked table by genojoe I have a table (Table1) with two fields (recID, title) in an Access 2000 file format database. The recID is AutoNumber and a Primary Key. If I use the append...	December 10th, 2005 05:07 AM by Allen Browne	1	154
autonumber column by BG Hi-I'd appreciate if anyone can help on this. I am trying to create a query that inserts the top25 results to a table with an autonumber column for...	September 13th, 2004 07:45 PM by Tim Ferguson	2	270
autonumber data type field is skipping numbers by Remi Not sure why this happened all of a sudden, but my autonumbering field is skipping numbers. Normally the numbers are generated in integers of one. But the...	October 5th, 2009 10:18 PM by John W. Vinson	2	216
Autonumber doesn't start at 1 by Dorci Access 2000 - I always include the autonumber ID field when I create tables, and they always start with the value of 22 instead of 1. This occurs in... ( 1 2)	June 11th, 2004 03:39 AM by david epsom dot com dot au	16	456
Autonumber duplication between tables on the desktop and a PDA by Caimari Hi, I have an Access 2003 database that I am running on a desktop and a mobile PC running in Windows Mobile 2005. The mobile database is built using Visual CE...	March 23rd, 2006 12:15 PM by Caimari	2	208
AutoNumber Field (Access 2007) by Jeff Gaines I am having some problems with a table in an Access 2007 database which has an AutoNumber field to keep a record number. It holds a record of various actions...	October 29th, 2008 03:39 PM by Jeff Gaines	5	205
Autonumber field changes to random from sequential by Anthony Fontana I design a table with the key field set to autonumber - sequential. I then append records to it from another table imported from an Excel Spreadsheet. Why...	June 26th, 2009 05:00 PM by Jeff Boyce	3	162
AutoNumber field question by Damian I have been playing around with adding things into tables and deleting them BUT now when I enter a new value the auto Number starts from whatever its been...	July 30th, 2009 09:58 PM by John W. Vinson	5	129
Autonumber Field Re-started at a Lower Number by MartyTheMSAccessGuy I have a table in a database that I received an error on that there were duplicate values in the indexes being created.... I initially thought it...	January 27th, 2006 05:48 AM by Allen Browne	1	112
autonumber field type by Revned hi, is there anyway i can have a result of 001 in an autonumber field type iam using ang autonumber to one of my field in my table.. thanks again	July 28th, 2009 08:18 PM by Piet Linden[_2_]	2	188
Autonumber Fields by Denis Access allows a table to have an autonumber field which could be considered a record number. In an application I am involved in developing there are a number... ( 1 2 3 ... Last Page)	September 29th, 2005 02:14 PM by BruceM	59	2,069
Autonumber fields gone haywire by Stephen Raftery Hi all, can anyone help with a wierd problem? I have been using a database for soem years, which involves a number of related tables. I have a table of... ( 1 2)	October 31st, 2006 08:40 PM by Joan Wild	13	254
AutoNumber for Primary Key by MT DOJ Help Desk Access 2000 Is it possible--or wise--to use the AutoNumber data type for the primary key? I seem to remember reading that it's not a good idea but I...	May 15th, 2004 04:52 AM by Allen Browne	4	351
Autonumber foreign keys and subforms by Ed Havelaar Hi, Hope someone can help. Here's the scenario: I have two MSAccess tables MainTab and SubTab. MainTab has an autonumber 'id' column as primary key. ...	May 12th, 2004 07:34 AM by John W. Vinson	3	898
Autonumber IDs and Text by Debbie Nuding via AccessMonster.com This may be a design flaw on my part, but how do you get the text output from an associated autonumber ID? When I run one of my queries using several tables...	March 21st, 2005 09:10 AM by Jamie Collins	6	172
Autonumber in Design by jk TABLE-Customer (one-to many--invoices) CusCtrID -Primary Unique CusNum CusName CusCity TABLE-Invoice InvID--Primary Unique InvDate InvDecrip	May 3rd, 2007 10:48 PM by Scott McDaniel[_2_]	3	87
autonumber in relationship database by Katharine Jansen I work for a small newly established company and am setting up a database in Access on Office 2000 Premium to store client information and account information....	August 5th, 2005 03:35 PM by Katharine Jansen	3	182

Page 59 of 581

Forum Tools	Search this Forum
Mark This Forum Read View Parent Forum	Search this Forum : Advanced Search

	New posts		Hot thread with new posts
	No new posts		Hot thread with no new posts
	Thread is closed

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is Off HTML code is Off

Forum Jump

All times are GMT +1. The time now is 05:56 PM.