|
|
Validation rule across table link by
The Grape Hunter
Access 2003. Database was split using splitter to Objects (Forms and Queries)
and DataTables. Links all appropriately and automatically established by
Access....
|
|
3 |
201 |
|
|
Cancel a Form's DB Action by
dave h
Hi,
I have a case where I don't want to save a record to a table if the user
clicks the X in the upper right corner of the form.
In the before update event, I...
|
February 26th, 2005 10:48 PM
by dave h
|
0 |
150 |
|
|
|
|
0 |
215 |
|
|
|
|
1 |
148 |
|
|
|
|
2 |
143 |
|
|
cross tab insert by
Roy
hi
got a table with Week code, Product Code, Quantity
now i have done a crosstab with product code as row, week code as column and
quantity as value.
the only...
|
|
1 |
134 |
|
|
Beginners Question on Primary Key by
The parawon
Is there a way to set a primary key in the queries tab of Access? I would
like to set the primary key before I run my select query or make-table query.
Is...
|
|
1 |
151 |
|
|
Help with database structure! by
Tony Williams
I'm looking for help on database construction. We have a current database
that would appear to be not normalised so I am looking for help on the
correct...
|
|
8 |
243 |
|
|
table design by
aylin_sk
I created a survey table in database...But my question is how can you create
tables and name columns for a survey, if you were me??Are these enough...
|
February 25th, 2005 07:17 AM
by aylin_sk
|
4 |
131 |
|
|
Table Analyzer and Normalization by
BI_Specialist
Hi,
I'm trying to build a datamart using Access as our database. Ideally I'd do
it in SQL server, but I belong to a business group and SQL server would...
|
|
4 |
222 |
|
|
|
February 24th, 2005 10:26 PM
by Rick B
|
1 |
160 |
|
|
|
|
7 |
253 |
|
|
|
February 24th, 2005 05:05 PM
by Rick B
|
1 |
152 |
|
|
Filter repeated records by
YuWing
I am trying to filter out all the repeated records. I sorted it. I want to
know how to filter out all the records that have been shown in precious
records.
It...
|
|
1 |
204 |
|
|
|
|
1 |
162 |
|
|
|
|
0 |
146 |
|
|
Setting a Counter? by
Lance Kates
I run Access 2003 and I'm creating a database to track shipments returning to
my company. I have about 6 or 7 different reasons for these returns, and...
|
|
0 |
164 |
|
|
Foreign key with SET NULL: possible? by
Jamie Collins
Is it possible to create a Jet 4.0 FOREIGN KEY with SET NULL for the ON
UPDATE and ON DELETE rules?
I've seen it mentioned in two Microsoft...
|
|
5 |
164 |
|
|
|
|
4 |
179 |
|
|
Table Normalization by
Jonathan Brown
I didn't normalize my database as well as I wish I had. I have a table
called EmpInfo that's built essentially as...
( 1 2 3)
|
|
27 |
980 |