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 Reverse Sort Order Replies Views
Avoiding duplicates in tables by dawnecia
I have a table with ID (auto number) as the primary key (A97 – multi-user environment). There should only be one entry per User ID per day. I am currently...
October 27th, 2004 12:09 AM
by Rick Brandt Go to last post
3 223
how do I create a stock control database by Wantula
sIm running a small shop and I need to have database of all stocks available(eg jeans,ladies shoes,troussers), this should be such that, when I sell an item,...
October 26th, 2004 05:46 PM
by Rick B Go to last post
1 128
reasons to link tables by Christopher Glaeser
I understand the importance if identifying all table relationships during the database design phase for the purpose of good design, but what is the purpose of...
October 26th, 2004 03:41 PM
by Bruce Go to last post
6 100
Access DB File size don't size down... by NIL
Here is the scenario, My Access DB File grew upto 500MB. I opened the file and deleted the table which contained most of these data. After the delete I noticed...
October 26th, 2004 10:01 AM
by NIL Go to last post
2 320
unbound text box by Ghutch
In Access 2000 , when entering text in unbound text box it repeats for every record. Does not do this at home only at church office.
October 25th, 2004 10:14 PM
by John Vinson Go to last post
2 77
database design by cgacker
i need to create a database that will document visits to people, at different locations, on different days. the summary report needs to include the...
October 25th, 2004 09:33 PM
by cgacker Go to last post
2 92
Compact and Repair Error by AccessDbGirl
I have a large database 91MB that, when I compact and repair it only gets half way through then says "Access Has Encountered An Error and Now Must Close" then...
October 25th, 2004 03:13 PM
by Sandy Go to last post
2 257
How do I do this? by Wayne Robinson
OK all of you knowledgeable folks, I have got one for you (it should take you all of 10 seconds, but I'm a tax guy). Deal Tax research database that stores...
October 24th, 2004 11:59 PM
by Wayne Robinson Go to last post
4 66
employee database by u2smile
Please I looking for a employee database.
October 24th, 2004 06:16 AM
by John Vinson Go to last post
1 94
Table Design & Relationship problem... by Niko
Hi all, I'll try to explain as much as I can what I want to do. I want an incoming notice paper to be in an access file along with some data... So we got one...
October 23rd, 2004 02:10 PM
by Brett Collings [429338] Go to last post
7 438
keyword search in Access by lavesely
What I want to do is kina like adding the function on a query. It prompts the user to search based on a number. This is what I want to do: Retrieve record(s)...
October 23rd, 2004 01:38 PM
by Jeff Boyce Go to last post
1 172
Record Level Locking by Sirocco
We have an Access 97 backend, Access 2003 front end. Under tools/options/advanced is a check box for "Open database using RecordLevelLocking". I read...
October 23rd, 2004 04:30 AM
by Allen Browne Go to last post
4 163
Tab control page by Ashley
Hi, Can the tab page be disabled to prevent user from going from tab to tab? I have command button that control where the next control will be. Thanks
October 23rd, 2004 03:30 AM
by Rick Brandt Go to last post
1 113
Primary Key in a Linking Table by Dkline
I'm wrestling with a linking table as the centerpiece on a many-to-many. Since every table should have a Primary Key, do I designate each Foreign Key as a...
October 23rd, 2004 02:55 AM
by John Vinson Go to last post
3 127
auto-populate a table? by Jerry Crosby
I want to design a table with two fields. Field 1 is a number and Field 2 is a date/time field. Field 1 is merely a shortened version of Field 2 that I use...
October 22nd, 2004 05:37 PM
by Jerry Crosby Go to last post
1 112
Lookup Table vs. Validation by Dkline
I understand the arguments againt lookup tables. I also have a need to prevent bad data. In lieu of a lookup table is it acceptable practice to use a...
October 22nd, 2004 04:04 PM
by Jamie Collins Go to last post
3 126
Database designs by boydn1
Is there a place to find databases that are already created? I'm looking for a CD and DVD database and am too lazy to recreate the wheel. Thanks!!
October 22nd, 2004 04:28 AM
by Apple Go to last post
3 111
How to limit the digit in number data type field by field size
im facing some difficulty here, i got one field which is number data type, but i want to limit the digit enter into this field is limit to 8 digits. i dont...
October 22nd, 2004 01:05 AM
by jk Go to last post
8 311
Deleting links without deleting the table. by Calaska
Access suggests that one can delete a link to a table without deleting the table itself. I have never been able to do this. I cannot export an .mdb...
October 21st, 2004 10:33 PM
by Belinda Go to last post
2 480
Linked Tables by PJ Usher
Hi Access 2000 Is there a way to find out the location of the source table from a database's linked tables? Thanks in advance PJ
October 21st, 2004 10:20 PM
by Tim Ferguson Go to last post
4 145
Post New Thread


Display Options
Showing threads 10581 to 10600 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 08:39 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.