|
|
Problem with Ref integrity by
Tanis Dimitrios
I have the following problem.
In a database, I want to keep records as historic, before making any changes
to them (historic in the same table). One of these...
|
|
9 |
407 |
|
|
Editing mSysRelationships by
Jim Tanis
Is there any way I can edit the contents of the System table mSysRelationships
(aka Change mode from readonly to read/write) so as I can edit...
|
|
1 |
149 |
|
|
Time to open a table seems unusually long by
Paul Ponzelli
I've noticed in one of my databases that it takes about 5 secondes to open
any of the tables in datasheet view (after double-clicking on the table icon
in the...
|
|
2 |
156 |
|
|
Date Format by
dave h
Hi,
I have a table with a date field. In my form code I have a query with a
WHERE clause that looks at this date. I want to check that date to see if
it is...
|
March 25th, 2005 09:34 PM
by dave h
|
2 |
298 |
|
|
Table desing re-do by
Stephm
Hi. I am sad because I think I need a re-do. There are
two inter-related criteria that need to be met. The
current table structure takes care of one of the...
|
|
3 |
117 |
|
|
|
|
1 |
178 |
|
|
|
|
1 |
176 |
|
|
suppressing alert messages by
tvt
Hi,
I set a string variable equal to my "insert" query and run it with:
DoCmd.runSQL myStr
Everything works fine but there's alway an alert message that...
|
|
1 |
119 |
|
|
alternative/mutually exclusive foreign keys by
Julian Fowler
Part of a database I'm working on has three tables: City, State,
Country. For cities in the US I want to have a reference from City to
State (stateRef in the...
|
|
3 |
141 |
|
|
LINKING TABLES by
Gilberto Lawas via AccessMonster.com
I'm so close.
I've got a table full of parts that I have to marry up to table full of
model numbers.
I've gotten the two to link Via
SELECT .ID, .PrtNum,...
|
|
1 |
178 |
|
|
|
|
1 |
132 |
|
|
converting access database by
jon mich via AccessMonster.com
I have to convert an access database to an oracle database.
Does someone has tips or can someone tell me how to do that?
--
Message posted via...
|
|
7 |
142 |
|
|
Relationships: Main and detail by
CLY
I am having trouble figuring out how to relate a number of tables. I have a
Main Table Compl_Main that will end up also being my Main form (Unique...
|
March 24th, 2005 06:33 PM
by CLY
|
0 |
99 |
|
|
|
March 24th, 2005 05:06 PM
by Rick B
|
1 |
104 |
|
|
Database for double data entry by
Enfantcherie
I'm trying to create a database in MS Access set up for double data entry
purposes with input messages, error alerts and automatic formulas for
calculation. It...
|
|
0 |
189 |
|
|
|
|
1 |
111 |
|
|
Setting up a database for training by
Jan Buckley
I need a database for 6 different types of training that must be taken by all
members of a purchase card program. Some training must be taken annually,
some...
|
|
1 |
286 |
|
|
|
|
2 |
101 |
|
|
How to design database by
Carol Shu
i am working for a used car dealer rship, and
i'm trying to bild a database, my questions is, like vehicle make by
Chevrolet are cavalier, malibu, lumina,...
|
|
1 |
104 |
|
|
|
|
1 |
85 |