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
Separate PK in Jxn Tbl? by Neil
Whenever I've created junction tables in the past, I always made the PK of the junction table the combined pks from the two other tables. Ex: Table1 PK=A;...
(Multi-page thread 1 2 3 ... Last Page)
February 8th, 2008 02:11 PM
by Gerry Hatrick[_2_] Go to last post
222 3,116
Data Primary key vs. Artificial (Autonumber) primary key by M.
Dear all, Although many Microsoft Access books advise to set an autonumber field as primary index (a so called pseudo primary key),...
(Multi-page thread 1 2 3 ... Last Page)
December 14th, 2007 09:10 AM
by Jamie Collins Go to last post
73 1,021
Pointless debates on the finer points of naming your objects (moved from Combo Box Requery thread) by Robert Morley
I still don't buy that this is either product-specific or amateur-specific. I've seen countless numbers of experienced, formally trained (and who learned it...
(Multi-page thread 1 2 3 ... Last Page)
July 21st, 2006 01:18 AM
by david epsom dot com dot au Go to last post
60 866
Autonumber Fields by Denis
Access allows a table to have an autonumber field which could be considered a record number. In an application I am involved in developing there are a number...
(Multi-page thread 1 2 3 ... Last Page)
September 29th, 2005 02:14 PM
by BruceM Go to last post
59 782
How do you mulitply in a field? by wazabbbi
I created a table with two fields named "projectestimate" and "inspectionfee". The inspection fee is 5% of the project estimate. I want the "inspectionfee"...
(Multi-page thread 1 2 3 ... Last Page)
September 3rd, 2007 11:42 AM
by Jamie Collins Go to last post
56 843
Table/Forms Design Question by Damian
I am Trying to create Daily Reports for my company. I created tables for Carpenters, Laborers, Surveyors, Ironworkers etc. Each of these has fields *_Name,...
(Multi-page thread 1 2 3 ... Last Page)
July 29th, 2009 06:43 PM
by Damian Go to last post
54 1,032
Prospective Client Tracking Database by TGC
I am new to Access 2007 and recently reviewed all the online tutorials on the Microsoft website and reviewed the provided templates (none of which fit my...
(Multi-page thread 1 2 3 ... Last Page)
January 28th, 2010 07:31 PM
by Gina Whipp Go to last post
51 1,197
I think I'm almost there...except for... by scubadiver
my table relations. From left to right: "Employees" Payroll (PK: 1) Employee Work Status Rate
(Multi-page thread 1 2 3 ... Last Page)
May 25th, 2006 03:34 PM
by Jamie Collins Go to last post
47 626
PK - To AutoNumber or Not To AutoNumber - That is the Question! :- by dee
Seriously... if I have, for example, employee numbers in an Employees table, should I use the employee number (will never change) or should I add an...
(Multi-page thread 1 2 3 ... Last Page)
August 9th, 2007 08:52 AM
by Jamie Collins Go to last post
40 617
Many-2-many relationships: Can I be told ... by scubadiver
....what I am missing? If I have training courses and employees, I know that each employee attends many training courses and each course is attended by many...
(Multi-page thread 1 2 3 ... Last Page)
November 10th, 2006 07:51 PM
by scubadiver Go to last post
40 458
Question about a default table or method by Joe Cilinceon
What is the best way to have defaults in one location but available to the whole application. Some examples would be Sales Tax rate, Late Fee charge...
(Multi-page thread 1 2 3 ... Last Page)
November 14th, 2005 06:51 PM
by PC Datasheet Go to last post
38 770
How to enforce subtypes/supertypes in Access 2000? by Bob
Hi folks, I am creating a client database in MS Access with the following (simplified) table structu tblContacts: ContactID (pk - autonumber) ContactType...
(Multi-page thread 1 2 3 ... Last Page)
August 14th, 2006 09:06 PM
by Bob Go to last post
37 540
Hostel Database Setup by andreainpanama
Thanks to all of you for all of your help. I have a small backpackers hostel and I am currently working on a database to help me keep track of all of my...
(Multi-page thread 1 2 3 ... Last Page)
July 26th, 2006 04:01 PM
by andreainpanama Go to last post
36 610
invoice number by cjgav
I would like to add an invoice number to report which is generated only when the invoice is printed can anyone explain how to do this please
(Multi-page thread 1 2 3 ... Last Page)
June 17th, 2009 10:01 PM
by cjgav Go to last post
36 577
A2007 - OLE vs. Attachements by Jay Oken
I would like to add a picture to a record but do not know the best way to do it. From what I can see OLE gives the option to "link" to the picture file...
(Multi-page thread 1 2 3 ... Last Page)
November 20th, 2009 10:28 PM
by johnlute Go to last post
36 793
Task List with tasks link to daily, day of week or other by MSEMD
I am attempting to build a database that will generate a task list for multiple workstations. I have tasks that need to be completed either daily, on a...
(Multi-page thread 1 2 3 ... Last Page)
November 30th, 2005 04:29 PM
by John Marshall, MVP Go to last post
35 591
I was told "Fields are expensive, records are cheap" by Dennis
Hi, I just have a self education question. In response to one of my questions I stated that I added a lot of fields (a lot was 30 fields) to my table. The...
(Multi-page thread 1 2 3 ... Last Page)
March 1st, 2010 03:25 AM
by David W. Fenton Go to last post
34 769
do I need more indexes? by jmoore[_2_]
After reading several posts here I have changed all of the lookup fields to text fields in my table and deleted the relationships to the lookup tables. I...
(Multi-page thread 1 2 3 ... Last Page)
July 17th, 2009 08:45 AM
by Keith Wilby Go to last post
33 614
Membership database updates by Pennington
I have created a membership database for our local branch of a charity and designed various queries and reports to analyze particular trends. The source...
(Multi-page thread 1 2 3 ... Last Page)
April 7th, 2008 12:21 PM
by Pennington Go to last post
33 593
Monthly Vendor Report by DRoads
Need help and don't know where to start. Working in Access 2007 and need to create the following....... Need to create the following report V# Vendor...
(Multi-page thread 1 2 3 ... Last Page)
October 22nd, 2009 12:25 PM
by BruceM via AccessMonster.com Go to last post
30 847
Post New Thread


Display Options
Showing threads 1 to 20 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 11:42 AM.


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