Database Design - Page 109 - 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
calculated fields by Dermot I want to create a database that uses calculated fields. The results would be printed in a report The calculations are basic as follows: Calculation... ( 1 2)	March 3rd, 2007 03:09 AM by Dermot	13	233
Auto Updating Data by Judy Rose I have a field where a date of completion for a project is entered. I want the system to automatically switch the field where open/completion is indicated... ( 1 2)	September 18th, 2006 02:40 PM by Duane Hookom	13	233
Register one record for each date or one record from and to date? by Jan T.[_2_] What is best practice? Either to 1) Register one record for each date or 2) Register one record with from and to date? Let's look at an example. If I...	September 26th, 2008 03:59 PM by Jan T.[_2_]	6	233
many to many self join by thadson I'm faced with a unique problem. many-to-many self join I have a list of drawings. some drawings include subdrawings and those subdrawings can have more...	October 10th, 2008 05:35 PM by Barry A&P[_2_]	2	233
Dlookup syntax by JD McLeod Can someone provide me with some quidance on how to write a dlookup formula. I was able to create on for a form, but I am trying to create one that looks up a...	June 23rd, 2005 04:55 PM by JD McLeod	2	233
Can't open .mdb file by Judy Ward HELP! I just created a small database that I expect more than one user to be able to open and use at a time. This has been working for me--please don't...	February 2nd, 2009 04:12 AM by Gina Whipp	6	233
Two tables, one link of date, multiple entries in one table per da by Harriet I am trying to create a query to run two tables; sinle relationship of transaction date but one table may have multiple entries of a transaction while the... ( 1 2)	September 14th, 2009 08:32 PM by Harriet	11	233
Make information "autocomplete" in a database by Miked I would like the ability to enter specific information, such as a SSN, or Drivers liscense #, and have a form, or query automatically enter the rest of the...	April 14th, 2005 02:02 PM by Lynn Trapp	1	233
Site info Table Design by DWright I am a coordinator for the local AARP tax aide program. I want to create database for the local sites that I run. Site table. How can I construct the Site Info...	April 7th, 2005 12:52 AM by John Vinson	1	233
Enforce Referential Integrity not available. by .Len B I have a db that will eventually be split. tblChild has PK ChildID and is a linked table tblNote has FK ChildID (long). Relationship window will allow me to...	December 18th, 2009 10:49 PM by David W. Fenton	6	233
How to insert fields of different tables in one form? by deepak Suppose I create two tables to store information. I want to desing a form where I can have the fields of both tables. I want to know how to access the fields...	September 9th, 2008 06:00 PM by John W. Vinson	2	232
LOOKUP Tables: How Do I Design and Join Them Properly? by T. Hulot[_2_] This message is for John, but, of course, I'd like anyone to respond. John, I'm having trouble understanding the lookup tables concept that you described in... ( 1 2)	April 2nd, 2008 05:49 PM by John W. Vinson	13	232
Convert Negative values to zero by Majic I calculated downtime using a query and now I need to change negative numbers (not downtime) to zeros. Please let me know how I can do that. Thank you ( 1 2)	July 26th, 2007 09:18 PM by BruceM[_2_]	15	232
Adding a second employee to an event by rickzman I have built an Operations Log database. In the database I have built built the following tables. tblLab(Lab where testing will occur) tblCustomer(customer...	March 8th, 2010 03:52 PM by KARL DEWEY	2	232
How do I create a main access page for my database by JaceeJHG I have created a database using Access 2000 but what I want to do is create a main page, so when you open up the database, the first thing you see is a page... ( 1 2)	May 10th, 2006 06:54 AM by Jeff Conrad	10	232
Creating a survey that needs to store comments by [email protected] I have designed a survey using asp and MS Access In this survey, currently, I am storing all the results in two tables. SurveyResult - (9 fields) for storing...	September 19th, 2005 03:33 AM by [email protected]	2	232
How to create a web-based timesheet DB in Access? by Fed Gov.au Any suggestions (including "out-of-the-box" solutions) can you recommend for creating a web based time recording tool that is not based on calendar days (ie...	June 10th, 2005 12:21 PM by Sharkbyte	1	232
One to many relationships by Sarah I have a master database called "Master List". It contains ID, Name, Address, phone, etc. I have a detail database called "Transactions" It contains, ID,... ( 1 2)	February 21st, 2007 12:41 AM by John W. Vinson	10	232
How do I organize my CD collection in Access by dkenn1967 I have a new CD changer that holds 300 CDs, and I want to organize my CDs so that I can play any CD whenever I want without having to scroll through the whole...	November 2nd, 2004 04:09 PM by Rick B	1	232
How do I unlink tables? by Riley Walker I have a table that I have moved from Works. It is linked to another table so I can't modify it. Any Help would be wonderful. Riley Walker	June 10th, 2004 08:35 AM by Maggie	4	231

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