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
Allen Browne's 'Library Resource' by cinnie
hello gurus I have learned a lot by studying the 'Library resource' example on Allen Browne's web site. This offers a lot of good advice on the organization...
May 30th, 2010 01:32 AM
by cinnie Go to last post
8 1,163
Make Table v. Append to Table: Need Some Expert Design Inputs by MJ
I am working on updates to a couple related databases (not linked by any tables) and have a question about virtues of Make Table vs Append queries. Make...
April 13th, 2010 07:27 PM
by John W. Vinson Go to last post
8 950
A Complex Scenario by Scott Matheny
Say I have a tables of records that are tests, and each has a sponsor company and a test company. Also, there is another single table with all the companies'...
July 21st, 2004 05:59 PM
by Tim Ferguson Go to last post
7 175
Advice on table setup by Rick Vooys
Hello all, I am banging my head against the wall. We are adding some functionality to our database but I have two solutions for the problem and cannot decide...
August 2nd, 2004 11:19 PM
by LGC Go to last post
7 339
Table / query Design by sam
Hi, I'm wanting to set this up but am unsure of the best way to go about it. All I have is basically a 'service' which will belong to particular areas...
August 13th, 2004 03:32 AM
by Duane Hookom Go to last post
7 212
Setting Condition Expressions by heath
I am a new user in need of guidance. I have a db set to monitor recoveries of past due accounts. I have been instructed to set it up so the counter people...
August 6th, 2004 05:47 PM
by Duane Hookom Go to last post
7 157
Restaurant Database by Rashid Khan
Hello All Experts, I have been after this for quiet some time now :-(. I want to design a database for a Restaurant. As I am a newbie on the learning curve...
August 12th, 2004 12:12 PM
by Rashid Khan Go to last post
7 198
Designing tables by John G
I want to design a database for a business that manufactures UPVC windows and doors. My initial problem is that each product (especially the windows)can be...
August 16th, 2004 09:11 PM
by Go to last post
7 172
Prevent Deletions w/i Database by Aurora
I am using Access 2000 I made a Db program for non-Access users to use. But someone figured out that you can delete the record. So I set the form for no...
September 7th, 2004 07:02 PM
by Aurora Go to last post
7 168
Multiple Primary Keys by Mike
Hello, Can I have 2 primary keys where Access requires that they are both not the same. For example... Field1 Field2 a 1 a 2 b 2
July 19th, 2004 05:53 PM
by Craig Alexander Morrison Go to last post
7 386
add an integer to Date the get Date? by aa
I have a table "Invoices" containing, among other things, the date of the invoice, as type Date I have another table "Customers" containing, among other...
July 23rd, 2004 05:32 AM
by Tom Ellison Go to last post
7 303
Max number of fields by DaveS
I have a strange application where i need to place 389 fields on a report. Ideally the fields would come from one big table. I have tried to join eight tables...
May 11th, 2004 05:30 AM
by TC Go to last post
7 408
Multiple Many-To-Many Tables by Tom
Hello, I am familiar with using a junction table for a "many-to-many" relationship. However, I'm not exactly sure how I could string multiple "many-to-many"...
May 15th, 2004 03:47 AM
by TC Go to last post
7 2,160
Considering using Access by Joe Rivera
I own and operate a taxi company in CT and need to computerize my operation. A friend has suggested using access to store our accounts, reservations, print...
May 15th, 2004 03:47 AM
by TC Go to last post
7 392
adding logged in user to text box by dennis
What I want to do though is keep a record of who has made changes within the notes part of the database. We would like to have a button on the form that when...
June 7th, 2004 07:26 PM
by Dennis Go to last post
7 626
Lookup fields by Luis Miguel
One of the advices on MVPS.org is not to use lookup fields in tables, their commandment reads: 'thou shalt abhor the use of "Lookup Fields" which art the...
June 21st, 2004 02:54 AM
by John Vinson Go to last post
7 346
Many to Many Relationships by Lynn
Good morning. I am new to Access databases and to date I have done a considerable amount of research and reading but am unable to ensure the steps I am taking...
July 9th, 2004 03:08 PM
by Go to last post
7 515
Complicated Databse w/many relationships by Søren
Hi, I've had a look around in some of the questions here and especially the ones from Tina, Allan and Rebecca - but I'm a bit stuck; I need a little sparring...
July 13th, 2004 05:41 AM
by tina Go to last post
7 2,279
AutoNumber (Primary Key) by Gregg Knapp
I'm setting up an Access DB (v2003) for use as the backend of a web application. As the db grows I see the potential of upsizing the db to SQL Server. So I'm...
July 23rd, 2004 07:27 PM
by Craig Alexander Morrison Go to last post
7 312
Personalised Customer Orders by Neill
I am selling personalised gifts on the Web (very small time but hopefully growing). Using FrontPage and Access 2000, I have managed to create ASP pages to...
May 5th, 2004 02:01 AM
by tina Go to last post
7 428
Post New Thread


Display Options
Showing threads 1081 to 1100 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 06:33 AM.


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