Database Design - Page 15 - 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 15 of 581

Threads in Forum : Database Design

Forum Tools

Search this Forum

Thread / Thread Starter	Last Post	Replies	Views
Dsum() Expression by Wantula How do I use the Dsum() funntion in a TABLE(e.g Quantity field) and later on subtract from another Dsum() funtion in another TABLE(Quantity field)	October 31st, 2004 10:04 AM by Brett Collings [429338]	1	119
SQL Syntax Error by Wantula Lynn Trapp asked me to post the actual SQL code so that it can be checked for error. The error is "Syntax error in FROM clause." SELECT Stock.Item,...	November 9th, 2004 01:01 AM by David Seeto via AccessMonster.com	3	230
db design question by WannaKatana I have a situation that I'm not sure which is the best way to model. I have the following relationships: Department - Group - Team - Subteam My problem is...	January 11th, 2006 05:36 PM by WannaKatana	7	79
Date Issue for viewiing by Walter Steadman Greetings all, I am trying to work on a DB to allow Aviators to track the number of hours they fly in a given flight period. I have the following tables...	May 28th, 2005 02:40 PM by Marshall Barton	1	101
Formatting a field by Walter Steadman Not sure where I am messing up on this one. have tried in Format and Input Mask. I have my Primary Key called PilotID (it is a text field) I need the...	June 24th, 2005 06:11 PM by Tim Ferguson	2	87
Date Question, not sure which forum by Walter Steadman Greetings all, I have built a DB that tracks pilot hours and it is working (but very clunky, and bad design). Here is where I am stuck. Pilots hours are...	June 30th, 2005 06:29 AM by Walter Steadman	2	97
open an Employee record (in FORM View) using a drop-down menu of n by Walter Mills I have created a bunch of employee records in my data base. I would like to have a Drop-down menu that has all of the last names of the employees and a button...	November 12th, 2005 06:52 PM by Duane Hookom	1	134
table relationships by Walter I am working on a DB to store mileage and fuel records for a trucking company. The data would come from trip sheets turned in by drivers with OD entries for...	January 20th, 2005 05:58 PM by Walter	4	228
Assembly/Sub-assy/Part tree by Walt E I posted this question in the Reports section, but am thinking maybe it is more of a basic design issue than report issue. I have a basic db of part numbers...	August 13th, 2007 05:44 PM by Walt E	4	145
Using a form from an existing database in my redesign by Walt D. I am currently working on a resign of a database. I was wondering if there was some way for me to "Import" the forms from the current database into my new...	November 4th, 2005 08:28 AM by StopThisAdvertising	3	170
database design by Walmondo Kelly http://robertkelly-carrollia.com/dbrelationships.html This size table should be coming off the inventory table I think. How do I do it? -- rjk	February 2nd, 2009 03:17 PM by Duane Hookom	2	143
Searching a table and displaying the results in MS Access 2003 by WalMatt23 I know this is a somewhat basic question, but the last time I programmed anything was in high school, about 10 years ago. Anyway, I am trying to create a...	November 17th, 2008 08:32 PM by Daniel Pineault	1	237
DB Structure Question by wallymeister I have 3 tables (Models, Check Items & Parts) Models Table has fields; , , (e.g. 120 records) Check Items table has; , , (e.g 40 records) Parts Table has;... ( 1 2)	April 3rd, 2009 08:29 PM by Guy	11	240
Design ? by wallymeister My question is this..... Can I create a form that when a new record is added, a subform on that form will automatically add all items that are in another...	January 28th, 2009 05:03 PM by wallymeister	2	83
Referential Integrity Q by wallymeister Is it Possible to change a common relationship between two tables to Force Referential Integrity after the data has been entered. I have two tables joined...	May 5th, 2010 12:08 PM by wallymeister	3	702
More Table Structure Help PLEASE by Wally Steadman Greetings all, I am killing myself on structure here I started building a DB to track Computers/Devices. There are multiple Sites and at each site there are... ( 1 2)	September 21st, 2006 03:43 AM by tina	12	236
Formatting a Number(IP Address) by Wally Steadman Greetings all, I have building a DB to track IP addresses of machines in many different builldings at many different locations. I have the following...	September 8th, 2006 02:19 AM by DavidC	1	61
Setting up a Table not sure where to start by Wally Steadman Greetings all, I play an Online Game and in the game a person can have more than one character. I was thinking of starting a database to track the members...	August 28th, 2006 08:32 PM by Cheese_whiz	3	71
How to assign unique, sequential user IDs (like B-102) by Wahine15 I'd like to get my db to auto generate a unique user ID based on first letter of last name and the number (say, Don Baker is first B, so he gets B-0001). Is... ( 1 2)	March 27th, 2007 06:25 PM by BruceM	17	180
WAGGS by WAGGS trying to find the trefoil symbol that represents Girl Guides Association	September 27th, 2004 06:44 AM by John Vinson	1	111

Page 15 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 01:04 PM.