A Microsoft Office (Excel, Word) forum. 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.

Go Back   Home » OfficeFrustration forum » Microsoft Access
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Post New Thread
Threads in Forum : Database Design Forum Tools Search this Forum Feed Icon
  Thread Reverse Sort Order / Thread Starter Last Post Replies Views
Automating Data entry by Steve Chaffin
I want to generate data based upon comparing two fields. In field one i have a text character and in Filed two i have a different text. I want field 3 to...
March 22nd, 2008 03:59 PM
by Rick Brandt Go to last post
1 144
automating field conversion by dtighe
I have a pre-designed table that contains a memo field which I need to convert to a text field for use in analysis. I'd like to automate the process rather...
May 18th, 2007 05:54 PM
by dtighe Go to last post
2 67
Automating My Application - Overall Design Problem & Need Help by Curtis Stevens
I'll explain how I have it setup now and what I was told I should do, can you please tell me if this is the best approach and how to fix the one bug that comes...
July 24th, 2006 04:42 AM
by Curtis Stevens Go to last post
0 80
Automobile table design by Jack
I am creating a db for a private investigator and am having difficulties figuring out how to design the automobile section. I have created tables with the...
March 23rd, 2006 08:15 PM
by mscertified Go to last post
1 69
autonum keyfield by WWV
I was worrking with a clients db and without going into details, they issued 2 new records in a table then I restored it. I need to put these records in and...
November 24th, 2004 07:00 PM
by John Vinson Go to last post
6 204
Autonum problem by Cathy
I have an autonum field in table1 that is the relational field to table2. It is an indexed field in table1 that will not allow duplicates, but is not the...
June 19th, 2008 02:03 AM
by Ken Snell \(MVP\) Go to last post
3 112
autonum re-setting by NJS
Good day people. does anyone know why an autonum field suddenly starts re-using numbers that were deleted long ago? This table has 9000 records, the first 4000...
September 9th, 2005 12:42 AM
by NJS Go to last post
2 152
Autonum, but not? :S by NateBuckley
Hello, I have two tables - One is "Employees" and the second is "Holidays". Each Single Employee within Table Employees can have many holidays, the problem...
May 20th, 2008 10:55 PM
by Jeff Boyce Go to last post
6 101
autonumber by SHETTY
Dear Friends I have got 2 sub table with autonumbers -both are primey keys There may be problem while consolidating data of 2 tables in querry So I want to...
June 6th, 2008 03:49 PM
by Michael Gramelspacher Go to last post
3 124
AutoNumber by FLGuy
I am converting a database from 2002 to 2007. The old databases first record started out at 700. I would like to renumber these records starting at 1. Then I...
February 24th, 2009 03:20 PM
by BruceM[_2_] Go to last post
7 151
Autonumber by EMILYTAN via AccessMonster.com
I have a field which is a primary key field in that table. In another table, I set this field as autonumber but it disallow me to do that because I have...
May 17th, 2007 10:22 AM
by EMILYTAN via AccessMonster.com Go to last post
3 77
Autonumber by Brian C
I was trying to add a first record to a table called BOOKING with the primary key defined as AUTONUMBER. I made a mistake because I needed to put a dummy...
April 26th, 2004 05:33 PM
by Tim Ferguson Go to last post
1 1,057
AutoNumber by Cindy H
Hi, I'm designing a new table to replace an existing table that is populated with data for the current application. The old table uses an AutoNumber...
January 28th, 2005 02:29 AM
by Ken Snell [MVP] Go to last post
1 382
Autonumber by Stig
Hi I want to add an Autonumber field to a table and its form. I want the format of it to be six digits no matter what the number (ie - 000001,000002). Is this...
January 27th, 2005 07:50 AM
by Stig Go to last post
2 228
AutoNumber by Brook
Hi All: I am setting up an invoiceing table with a form/subform. My invoice numbers start with KI-then a number (I.E. KI- 100). I want to set up an...
(Multi-page thread 1 2)
August 5th, 2004 11:14 PM
by Tim Ferguson Go to last post
10 278
AutoNumber by Charlie
I need an autonumber field to be incrimented by more than 1. I would like it incrimented by 5 on each new record. I use the autonumber to give me import order...
June 22nd, 2004 08:35 PM
by Roger Carlson Go to last post
3 500
AutoNumber by Pam
Hi, I have a table that holds information for jobs. The job number is an auto number field. It has grown to a 5-digit number and users want to start over...
(Multi-page thread 1 2)
April 14th, 2010 01:40 PM
by Fred Go to last post
15 1,216
AutoNumber (Primary Key) by Gregg Knapp
I'm setting up an Access DB (v2003) for use as the backend of a web application. As the db grows I see the potential of upsizing the db to SQL Server. So I'm...
July 23rd, 2004 07:27 PM
by Craig Alexander Morrison Go to last post
7 312
Autonumber - starting number by Matt, Sheffield, UK
How can you change which number your autonumber starts at, its also my primary key but i want to start a number range from 7000000 then have the database count...
March 18th, 2006 02:08 AM
by Ken Sheridan Go to last post
5 130
Autonumber 0ne-One by acss
I have an invoice table and an invoice details table and i need to have the design accept duplicate invoice numbers since we receive same invoices from...
(Multi-page thread 1 2 3)
August 4th, 2009 02:06 PM
by BruceM[_4_] Go to last post
22 776
Post New Thread


Display Options
Showing threads 1141 to 1160 of 11610
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread 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 09:31 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.