|
|
|
November 8th, 2004 04:31 PM
by bw
|
4 |
229 |
|
|
Setting Table Relationships- Why? by
el zorro
When I first started working in Access, I would set
relationships for all the tables.
THen when I got "clever" and began writing lots of
queries, I noticed...
|
|
4 |
445 |
|
|
SQL by
Wantula
I decided to repost this question because the response i got didnt work, it
was giving me this error" Syntax error in the FROM clause".
Lynn Trap,...
|
|
3 |
158 |
|
|
SQL Syntax Error by
Wantula
Lynn Trapp asked me to post the actual SQL code so that it can be checked for
error. The error is "Syntax error in FROM clause."
SELECT Stock.Item,...
|
|
3 |
230 |
|
|
SQL Statement by
Wantula
I have two SQL statements, one is giving me the total Quantity
available(from Stock table) and the other one is giving me the total number
of Quantity sold...
|
|
2 |
224 |
|
|
One to Many Relationships by
Pointy Haired Boss
I am trying to build a one to many relationship where the One is a normal
field named 'UserID' within the first table while the Many is a Primary Key
named...
|
|
8 |
178 |
|
|
|
|
1 |
241 |
|
|
|
November 9th, 2004 11:18 AM
by Randy
|
3 |
183 |
|
|
Automatically Check Checkbox by
CMD
I'm building a database in which I would like to have checkboxes
automatically checked on a summary form once certain other information has
been entered into...
|
November 9th, 2004 11:42 AM
by Randy
|
5 |
143 |
|
|
how do i calculate age by
Shelley
I have tried using the current formula online ...namely...
=DateDiff("yyyy", , Now())+ Int( Format(now(), "mmdd") Format(
, "mmdd") )
but the program ...
|
|
7 |
161 |
|
|
Direction needed with a field conundrum by
Jeff Conrad
Hi,
I'm helping a local county office with a fairly big project. This county office does Assessment,
Taxation, Survey, etc. We're just at the beginning stages...
|
|
8 |
220 |
|
|
Membership Databases by
Geoffers B
Does anyone know of an existing template for Access which I can use as a base
for a club membership system. The 'Contact Database' template which comes
with...
|
|
1 |
82 |
|
|
how to use check boxes on a spread sheet by
NAVY GIRL NEEDS YOU!
I don't know too much about access but all that I know I am learning from
mistakes. I have built a database that will help all administrative types in
my...
|
|
2 |
320 |
|
|
creating a table without multiple entries by
talktobatchu
There is some information regarding a disease for which the number of cases
and case rates are stored for each year and for all the counties in a state.
When...
|
|
1 |
174 |
|
|
Database Design by
Mike
Hello All:
I know how I have my access application right now that isnt quite right, but
it works. But I would like to know the proper way to do this. I have...
( 1 2)
|
November 10th, 2004 03:19 AM
by Squid
|
12 |
363 |
|
|
why is my form blank? by
Sherilyn
I'm creating a form and while going and back and forth I can no longer view
my form!
|
|
2 |
108 |
|
|
table size by
rudwan
hi
how i could know teh size of my tables ? also my forms
( 1 2)
|
November 10th, 2004 07:58 AM
by rudwan
|
11 |
180 |
|
|
relating two tables by
george
Hi to all,
I work on an insurance project.I have a table,
tblPolicies, which has a triple primary key: BranchID,
CompanyID, PolicyN. To this table I want to...
|
November 10th, 2004 08:22 AM
by george
|
4 |
141 |
|
|
|
|
7 |
171 |
|
|
Currency or Double for currency values by
Tim Zych
I have a table here that will store currency values. I've been reading up on
the differences between the datatypes available and there seem to be 2
viable...
|
|
8 |
347 |