|
|
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...
|
|
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
|
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
|
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
|
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.
|
|
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
|
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
|
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...
|
|
4 |
66 |
|
|
|
|
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...
|
|
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)...
|
|
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...
|
|
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
|
|
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...
|
|
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...
|
|
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...
|
|
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
|
3 |
111 |
|
|
|
October 22nd, 2004 01:05 AM
by jk
|
8 |
311 |
|
|
|
October 21st, 2004 10:33 PM
by Belinda
|
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
|
|
4 |
145 |