Database Design - Page 517 - 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.

Thread / Thread Starter	Last Post	Replies	Views
Relationship Question by Steve Haack I have a field called tblPeople. It has an AutoNumber field as its PK, it has a field called ID which is a text field, indexed (no dupes). I have another...	December 2nd, 2009 03:17 AM by Steve Haack	0	183
Relationship Question by Steve Haack I have a field called tblPeople. It has an AutoNumber field as its PK, it has a field called ID which is a text field, indexed (no dupes). I have another...	December 2nd, 2009 03:17 AM by Steve Haack	0	172
Relationship Question by Steve Haack I have a field called tblPeople. It has an AutoNumber field as its PK, it has a field called ID which is a text field, indexed (no dupes). I have another... ( 1 2)	December 3rd, 2009 04:35 PM by Gina Whipp	10	395
decimal display without rounding by Steve in Procurement I need to set up a field in a table and form that displays a number to the eighth decimal position. The display appears to round it to he 4th position, which...	November 23rd, 2005 04:51 PM by Allen Browne	1	144
Field properties by Steve J Hi i have a whole load of records with a field which currently contains a numeric figure. It is set to long . The figure represents the number of...	May 12th, 2005 04:32 PM by Allen Browne	1	100
Unbound Data Entry Form by Steve Muir Bit of a "noob" question but here goes.... I am using an unbound form for data entry purposes. I am using an unbound form as I have some VBA code which...	February 9th, 2010 12:41 AM by Al Campagna[_2_]	5	337
Help - Convert Access flat file to normalized tables by Steve Newton Folks, Hi. I have an Access file that consists of a single flat file table. I'd like to create a series of tables that are normalized. I would like to do this...	June 29th, 2004 08:27 PM by John Vinson	8	324
Excel field truncated on import...help? by Steve Newton Hi. I am using Access 2000 to import data from an Excel spreadsheet with the Get External Data command. A couple of the columns in the Excel spreadsheet...	July 30th, 2004 05:19 PM by Steve Newton	1	152
Normalizing table with repeating groups and existing relationships - How? by Steve Newton Folks, I have inherited an Access 2000 database that contains about 50 records. The database is not normalized, but I'd like to make it so without having to...	August 16th, 2004 04:35 PM by Steve Newton	2	350
New Linked Table by Steve S My database is split but now I need to create a new table. do I create it in the backend or in the mdb where the forms and such are? How do I do this? steve	May 17th, 2009 10:20 PM by tina	4	115
Primary Key/Read only issue by Steve S Hi: I'm setting up a table in an ACCESS 2003 ADP project. I don't want to assign a primary key because the data I'll be importing contains duplicate values in...	December 23rd, 2004 02:22 PM by '69 Camaro	1	167
Multi-field Primary keys by Steve S Have several tables where the primary key consists of 3 individual fields. Is there a way to fererence these fields as a group? Right now I have to...	January 23rd, 2010 03:14 PM by oldblindpew	9	361
Default Value =now() in table by Steve Stad I have a Default Value of =now() for a DateEntered field formatted as General Date. I noticed when I copy pasted a group of 4 records the DateEntered field...	February 1st, 2010 04:14 PM by Steve Stad	2	296
Email Validation by Steve Stad I was testing this email validation rule. Is Null Or ((Like ") Or (Like ") Or (Like ") Or (Like ") Or (Like...	January 28th, 2010 04:05 PM by Steve Stad	3	286
Data Fields Changing by Steve Stad I have a Master Table in a Master DB linked to a few sub databases. The input forms (to update Master table) are in the sub databases based on queries also...	January 13th, 2010 01:01 AM by Clifford Bass via AccessMonster.com	2	193
Can't change data type by Steve Stad I was trying to update field size in table design. I get a message saying 'You can't change the data type or field, it is part of one or more relationships....	January 11th, 2010 07:58 PM by Jeff Boyce	3	231
can't change the data type or field size by Steve Stad I am creating/editing updating fields in table design. I am trying to change the field size of the first field. But getting message.. 'You can't change the...	January 12th, 2010 12:59 AM by John W. Vinson	3	579
Data Validation Rule in Table Design by Steve Stad Can you tell me how to write a data validation rule I can use in the table design mode for a phone number field that will not allow blanks (eg Not null) and...	January 6th, 2010 05:22 AM by theDBguy[_2_]	5	244
Default Value in table -- LEN: Len([ID]) vs, =Len("BILL_ID2") by Steve Stad Hi, I would like to create a default value in a table which auto populates the number of charachters entered in another field (e.g., ID) in the same table. ... ( 1 2)	January 23rd, 2007 09:12 PM by John Nurick	10	123
No Duplicates for Full Name by Steve Stad I have 3 fields for Name. LastNm, FirstNm, and Middle Initial. How do I ensure the full name, i.e., "LastNm, FirstNm, MiddleInitial" combined are unique...	May 7th, 2010 09:20 PM by Steve Stad	7	904

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