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
Brain Cramp Db design by BABs
I am building a new db from excel spreadsheets. One spreadsheet has gauge information: (each row/record is a different gauge) gauge serial number -...
(Multi-page thread 1 2 3)
December 2nd, 2009 03:22 AM
by Tony Toews [MVP] Go to last post
24 586
Need guidance for Inventory dbase, want to avoid calculated field. by plisvb
Hello All, I've searched through countless "calculated fields" threads but I've never found an answer to my question. I'd like to know the best way to set...
(Multi-page thread 1 2 3)
November 5th, 2009 02:44 PM
by plisvb via AccessMonster.com Go to last post
24 503
New Database - Primary Key by Trini Gal
Hello, I've read a lot of the threads referencing Primary Key and I need a little help. I'm creating a database for my company to track changes to channels....
(Multi-page thread 1 2 3)
June 15th, 2009 02:10 AM
by Tony Toews [MVP] Go to last post
24 677
Tables - Membership DB - advice needed by Lisa - NH
Hi. I have placed a few other posts in the new user forum and have received some help. I've been using Excel. I jumped into Access before doing...
(Multi-page thread 1 2 3)
March 7th, 2008 03:36 PM
by Fred Go to last post
24 661
help with tables by LTOSH
(Using Access 2000) I have a 3 tables. Client Table...ClientID(pk), first name, last name, address etc. Exercises Table...ExerciseID(pk), exercise name,...
(Multi-page thread 1 2 3)
April 6th, 2009 05:49 PM
by John W. Vinson Go to last post
23 472
Format number field to show Percent by Kaylen
How do I format a field so whenever a number is enter, the field automatically make that entry a Percent. I tried formattting the number to Percent but when...
(Multi-page thread 1 2 3)
January 26th, 2009 11:32 PM
by Clifford Bass[_2_] Go to last post
23 421
autofilling a field based on values of 6 other fields by babs
From Previous Post I have a table that has a delivery yard, pickup yard, and type of material(2choices). Based on that combination of what is in those three...
(Multi-page thread 1 2 3)
October 20th, 2006 04:42 AM
by Duane Hookom Go to last post
23 264
Database Design Idea by andycambo
I’m looking to create, in my view, a complex database in Access 2007 and would like your advice and views on my design plan. First I will explain what the...
(Multi-page thread 1 2 3)
July 29th, 2009 02:02 PM
by Gina Whipp Go to last post
23 779
Last entry +1 help....Reset when desired. by Fletcher
I have a number field on a form that I would like to count up to 20 from one for each entry. This is probalby something easy, but is avoiding me at the...
(Multi-page thread 1 2 3)
August 3rd, 2006 04:46 AM
by strive4peace Go to last post
23 533
Modifying the Standard Inventory DB to allow for individual items? by Swin
Hi all, I'm looking to create a stock control log where by we can record goods moving in and out of our company. We are a Not for Profit organisation that...
(Multi-page thread 1 2 3)
August 14th, 2009 12:03 PM
by BruceM[_4_] Go to last post
23 1,127
Primary Key Autonumbers by David M C
I've been reading lots of posts regarding not showing Primary Key autonumbers to users. Could I ask, why is this a bad idea? I've designed a DB for handling...
(Multi-page thread 1 2 3)
April 29th, 2006 12:23 AM
by Brendan Reynolds Go to last post
23 455
Lookup Evils by HelenJ
I have been reading all about the evils of lookups in tables, however could someone please explain how you avoid using them - is the answer to have many tiny...
(Multi-page thread 1 2 3)
March 28th, 2008 08:31 PM
by Jessi Go to last post
23 844
how to handle meter readings by deb
i have to create a table that will import meter readings my first instinct is to just have a simple table that has meter number, location and then readings...
(Multi-page thread 1 2 3)
November 17th, 2009 08:00 AM
by deb Go to last post
23 665
Table design question re duplicates fields by lmcc007
I am using Access 2007. I am trying to create a job searching database. The problem I am having is the phone number field. Sometimes there may be six...
(Multi-page thread 1 2 3)
May 13th, 2009 02:52 PM
by Fred Go to last post
23 394
Design Problem -- only get partial results on multiple join by GIraffe
Thank you for your time and patience. This board has been a wealth of information and knowledge. I hope you can help me with my latest Access challenge. ...
(Multi-page thread 1 2 3)
April 15th, 2008 09:54 PM
by Evi Go to last post
22 481
Complex (for me) custom counter question.... by Fletcher
Hi, I would like to set up a custom counter for processes in my facility. I'll list my table structure first, then explain: *ProcessXData* DataID, where I...
(Multi-page thread 1 2 3)
August 7th, 2006 08:17 AM
by Jamie Collins Go to last post
22 373
Records will not append to another table due to Key violations and by faxylady
I have several tables I am trying to append to a comprehensive table called the BIGTable. I am having trouble with my append query giving me an error...
(Multi-page thread 1 2 3)
July 19th, 2006 05:40 AM
by faxylady Go to last post
22 308
Connecting Tables by James
I am making a scheduling system. I have a table that will have many records (One record is one date) and it has 20 fields (one field is one...
(Multi-page thread 1 2 3)
October 4th, 2005 05:06 AM
by Duane Hookom Go to last post
22 416
Relationship feature/bug/accident by Peter Danes
I have a strange (to me, anyway) relationship setup that I haven't found addressed in any of the forums, online help or any of my manuals. Of course, maybe I'm...
(Multi-page thread 1 2 3)
September 11th, 2005 11:15 PM
by Albert D.Kallal Go to last post
22 599
Design problem and suggestions... by Access rookie
Hello, I need some design advice. I have a database that takes care of clients; it also has a table of doctors. I have a many to many relationship between the...
(Multi-page thread 1 2 3)
February 21st, 2005 03:07 PM
by Mike Sherrill Go to last post
22 624
Post New Thread


Display Options
Showing threads 61 to 80 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 12:50 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.