|
|
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 |
|
|
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 |
|
|
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 |
|
|
|
|
1 |
176 |
|
|
|
|
1 |
178 |
|
|
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 |
|
|
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 08:34 PM
by dave h
|
2 |
299 |
|
|
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 |
|
|
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 |
|
|
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 |
422 |
|
|
Read Only Link Query or Table by
Access 2003 User Names & Login issues
We have a peer to peer network in our office and use Access to store
confidential information.
I would like to create a secondary database with either a...
|
|
1 |
139 |
|
|
Photo in a database by
Hombreck
I have a church membeship database that I need to enter members pictures. Is
there a way of doing it? If somplease help out.
I am using MSOffice 2003.
Thank you
|
|
1 |
115 |
|
|
|
March 27th, 2005 04:40 PM
by DL
|
1 |
120 |
|
|
can i link two separate databases? by
SandyF
What I have at the present is one database with my accounts receivable
information. I am planning on creating another database with the accounts
payable...
|
|
2 |
114 |
|
|
Primary Key & Foriegn Key by
TSG
How do I mke sure that my related tables update the correct records in a one-to-many relationship. For example, I'm creating a database for teachers to use in...
|
|
3 |
160 |
|
|
How do I use CREATE VIEW in Access 2003? by
Scott Ayliffe
The HELP documentation gives me the EXACT syntax for how to do this. CREATE
and VIEW are even reserved words in the Jet Database. The DROP command even
lists...
|
|
6 |
251 |
|
|
Column Sum by
JRB
Hi, I'm using Access 2000. Ive got a table set up with a bunch of columns
that hold numbers. What I want is to add another column that holds the sum of
these...
|
|
5 |
102 |
|
|
|
|
8 |
188 |
|
|
|
March 28th, 2005 03:31 PM
by BruceM
|
2 |
348 |
|
|
Linking Tables SQL by
Gilberto Lawas via AccessMonster.com
Can someon please break down this code for me. I'm a little confused about
what it's supposed to do.
SELECT MdlLst.ID AS xyz_ID_xyz, MdlLst.MdlNum AS...
|
|
2 |
145 |