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 / Thread Starter Last Post Replies Reverse Sort Order Views
junction tables for 3 many to many relationships by LAF
Imagine 3 tables: A, B, C, with many-to-many relationships among all pairs (AB, AC, BC). Three junction tables can be used to deal with the...
(Multi-page thread 1 2)
January 5th, 2005 05:01 PM
by LAF Go to last post
17 738
I need to calculate in time, out time and lunch... by Kelvin Beaton
Hi there I'm working on a data base to replace our Excel time sheet. I need input on the data types for these fields. Currently I have them setup this...
(Multi-page thread 1 2)
May 8th, 2007 05:47 PM
by Douglas J. Steele Go to last post
17 191
Database and Relationship Advice by Claire
PLEASE HELP I am trying to produce a database that will allow me to store my client information and also log events such as telephone calls and and emails...
(Multi-page thread 1 2)
May 10th, 2007 07:51 PM
by Steve[_10_] Go to last post
17 204
One Master LU Table vs. Many LU Tables by KitCaz
In a long-term fit of normalization, I designed my application to have one master lookup table with a "type" column (where the lookup values were commonly...
(Multi-page thread 1 2)
June 12th, 2007 09:51 AM
by Jamie Collins[_2_] Go to last post
17 307
Database relationships design by Catalin
Hi everyone, I am developing an Access database and I need some help to figure out how to link the table in the proper way. I have the tables which look...
(Multi-page thread 1 2)
July 8th, 2007 01:32 AM
by John W. Vinson Go to last post
17 193
Designing a DB for Tract Home Models w/ Many Options and Categorie by billyradd
I’m relatively new to Access but I have a fairly good understanding of the basics. What I am faced with is creating an application to create, maintain and...
(Multi-page thread 1 2)
July 30th, 2007 04:00 PM
by billyradd Go to last post
17 430
Access should allow field names to be alphabetized by Norman Simoneau from ProSo.Net
When in Table Design please add a way to alphabetize the fieldname list. It's very tedious to manually move the fields up /down one by one to sort the...
(Multi-page thread 1 2)
September 27th, 2007 04:26 PM
by Jamie Collins Go to last post
17 379
Table vs. multiple tables by jenniferspnc
So I had a database that served it's purpose; however, there have been lots of changes in the information captured so I think I'll need to start from scratch...
(Multi-page thread 1 2)
January 4th, 2008 10:40 AM
by Jamie Collins Go to last post
17 203
replace table without damaging the data after split by Frank Situmorang[_2_]
Hello, I have distributed my database to be used. I have split it to the FE and BE. I found it later that I need additional field in the table and I want to...
(Multi-page thread 1 2)
June 19th, 2008 05:12 PM
by Jeff Boyce Go to last post
17 267
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...
(Multi-page thread 1 2)
March 27th, 2007 06:25 PM
by BruceM Go to last post
17 180
Table Design by debraj007
Hello and thanks for your time. Maybe I'm making this too hard, I'm not sure. I'm trying to help my church set up a database for the school projects. My...
(Multi-page thread 1 2)
March 8th, 2007 01:08 PM
by Jamie Collins Go to last post
17 168
Do not want data to auto sort by [email protected]
Rick B wrote: Tables do not reliably sort data. The word 'reliably' makes no sense here. A table cannot sort data. A cursor sorts data. Tables are...
(Multi-page thread 1 2)
August 11th, 2005 10:15 AM
by Terry Kreft Go to last post
17 278
One to One Relationships by Matt K.
I thought I was getting a grasp on the whole table/relationship design, but the more I read the more I feel like I am spinning my wheels. QUESTION What is the...
(Multi-page thread 1 2)
July 18th, 2006 09:57 AM
by Jamie Collins Go to last post
17 429
Storing Foreign Key in a table by CoachBarkerOJPW
I was wondering after reading some comments about table design. Is it wrong to use a lookup in a table to store the text of the foreign key to make the table...
(Multi-page thread 1 2)
August 10th, 2006 03:40 PM
by jahoobob via AccessMonster.com Go to last post
17 245
training records (part 2) by scubadiver
I've been sorting out my design for this and I *think* I have come up with something that should pass the test! As far as I can see, none of the fields or...
(Multi-page thread 1 2)
November 24th, 2006 12:49 PM
by scubadiver Go to last post
17 165
Working Hours database by scubadiver
Earlier in the year I devised a database to hold working hours information for members of staff. Because I didn't know any better I used a 1:m relationship...
(Multi-page thread 1 2)
December 5th, 2006 10:35 AM
by scubadiver Go to last post
17 167
By Year/Quarter by chickalina
I have a table that each record needs to be tracked by year/qtr. Ex: Vendor taxes. I need to do the following: - Track by Quarter for every year...
(Multi-page thread 1 2)
November 26th, 2006 09:51 PM
by chickalina Go to last post
17 208
Database Design by Percy
I have a table which looks like the one below Country Product Family AllocatedCost 1 AllocatedCost 2 EventCost 1 EventCost2 Uk Car ...
(Multi-page thread 1 2)
December 23rd, 2006 02:48 PM
by Douglas J. Steele Go to last post
17 154
Primary Keys by Nanette
I have a table with two primary keys (its a linking table). I'd like both the fields to be able to accept null values. Is this possible, and if so, how do I...
(Multi-page thread 1 2)
January 12th, 2007 01:40 PM
by BruceM Go to last post
17 133
Perpetual due dates by Jan :\)
Hi all, Access 2007, Vista Ultimate I am setting up a monthly budget and need to address a few areas that I have not quite figured out, and hoping I can get...
(Multi-page thread 1 2)
July 16th, 2008 10:02 PM
by John... Visio MVP Go to last post
17 258
Post New Thread


Display Options
Showing threads 161 to 180 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:12 PM.


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