|
|
Linked Tables by
Daniel
Hi everyone,
I have a database with some linked tbales in it, but I
need to find out where the original tables are located
that these are linked to. If i...
|
September 2nd, 2004 08:24 PM
by Ian_
|
8 |
413 |
|
|
|
|
8 |
186 |
|
|
Crosstab Query should do this? by
Tails
Hi
I have been asked to do something for one of the departments in my office -
I thought it would be easier than it's turning out.
They have a years worth of...
|
|
8 |
183 |
|
|
When is a Table not a Table? by
Hank
I've inherited a database and I'm trying to reverse-engineer some of the
design to try and understand how it's put together. I've got this
query (below) and...
|
September 2nd, 2004 03:24 PM
by Hank
|
8 |
174 |
|
|
How do I create a calender in Access? by
Stevie
I am trying to create a calender in Access, but am unsure where to start. I
am a novice in Access. I haven't created any forms in my database yet,
because I am...
|
|
8 |
263 |
|
|
Using a variable in a query or filter? by
Maury Markowitz
Access 2003, all coding in VB.
I'm sure this is very easy, but...
I have a form that uses some simple SQL in the Record Source line to
populate a few fields....
|
|
8 |
271 |
|
|
Using expression builder in default value by
Copwriter
I want the default value for a date field (short date format) to have the
same value as another date field. I have tried entering this into
Expression Builder...
|
|
8 |
410 |
|
|
Weirdest Thing Yet in Access 97 by
John S. Ford, MD
Alright, I know everyone's going to think I'm crazy but I'm not making this
up. I've been working on an Access 97 application that has been acting up
lately. ...
|
October 6th, 2004 03:12 PM
by LeAnne
|
8 |
123 |
|
|
display currency by
ria
I would like to display in a different currency
eg Rs. 1,00,000 (placement of ,)
Also, I would like to display date in dd/mm/yy format ...so, oct 20...
|
October 21st, 2004 02:23 PM
by ria
|
8 |
121 |
|
|
generating sum totals by
steve
Hi there
I use Access 2000 for a very simple database of members.
I am reasonably confident with generating queries and
reports showing me lists of e.g. male...
|
August 19th, 2004 01:42 PM
by ¹Ú¹®¼ö
|
8 |
193 |
|
|
Time Format - Need all 4 digits shown by
scott
Hi,
I have an operations database that tracks our tug boat voyages and use the
standard 24 hour timeclock. The times are shown with the short time...
|
|
8 |
377 |
|
|
Should I use Access or Excel? by
Kelsey
I work in a company where Access is just starting to be utilized... and now all of a sudden everyone wants to use it. Since I am one of the few people with...
|
June 3rd, 2004 12:19 AM
by Troll
|
8 |
431 |
|
|
Minimizing use of mouse in Access ??? by
David
Does Access have any facilities for using the keyboard instead of the mouse?
Is there any way to set form/control properties in Design view without using the...
|
|
8 |
270 |
|
|
Help with Sum Function in Report by
S Jackson
I have the following Switch function in an unbound control in the detail
section of a report and it works beautifully:
=Format(Switch(="Other",,="Withdrawn
by...
|
|
8 |
124 |
|
|
Dates between by
Box 666
On an input form the user can query an item between 2 dates that they infill
in two unbound text boxes.
At the moment in the date field of the query criteria...
|
|
8 |
181 |
|
|
Text Fields in a Parameter Query by
Dumb Blonde
I imported a database from Excel. Have a field in a table called Bday. It's a text field (length 5). I recently added an input mask of aa/aa. I've got a...
|
|
8 |
167 |
|
|
Dealer Locator by
Galsaba
Who can help me with a script to do "dealer locator" when i have zip codes of
each dealer, and the zip code of the customer.
Joe
|
July 4th, 2004 02:49 AM
by Marc
|
8 |
208 |
|
|
|
July 23rd, 2004 11:29 PM
by Reggie
|
8 |
657 |
|
|
Addition to database design question by
Annelie
I have a going database for a contractor which tracks jobcost, mostly from
imported data from QuickBooks, but actual payroll is also entered.
Everything is...
|
July 24th, 2004 03:41 PM
by Annelie
|
8 |
343 |
|
|
Dropping Zeros from Avg by
AlCamp
I have 6 values (S1 - S6). Some of these fields have values, and some
contain 0 (zero).
I need to average these values... NOT including any zero values.
In...
|
|
8 |
222 |