This one's pretty basic, but I really need help.  I have two tables,
one with customer information and another which looks up prices
depending upon size in united inches.
It works fine if I input the united inches value in the form, but if it

Im using abbreviated field names on a form to optimise space, but would like
to display for example, the status bar text of the control, onto the form
header, when the control has the focus.
I'm trying to use the screen.activecontrol, with the oncurrent event, but am

I am hoping you can help me.
I am using MS Access 2000 for this. Here is the scenario:
I have two tables:
tblMain

How do you programatically get a list of subfolders in a folder?
Thanks!
Tom

I have a table that contains a bunch of pictures.  When the user selects a
particular image in a form, I need a way to extract the selected bitmap
image (stored in an OLE Object table field) to the file system so the user
can do stuff with "somePicture.bmp", for example.

Is it possible to use two different tables with the Report Design
Wizard?  My report requires data from two different tables and I can't
figure out how to get the wizard to accept the second one.
Also, my report uses a bunch of fields which I then rearrange so that

Public Function GetLastDayOfMonth(ByVal dtDay As Date) As Date
'**************************************************************************
' Accepts a date. Determines month & year of the date. Returns
' the date of the last day of that month (in the same year)

A2003.  I am getting this error message when I try to set a report's
recordsource to an SQL statement or a saved querydef that uses sub-queries.
I've debug.printed the SQL, and run it as a stand alone query, as a
rowsource for a list box and as a recordsource for a form.  There's ...

I've been playing with Allen Browne's audit code and found it very
useful. I need to track record insertions, deletions, and edits for
several tables. I am planning to replace Access with Microsoft SQL
server for my back end, but continue to use Access for the front end.

Before I go on, let me just say I'm fairly new at this so excuse me if I
say the wrong thing or use the wrong term.
Anyway, what I am trying to do is to set up something where I can have a
database of images and associated details. I want to run the system on a

A97 incorporates a new twist on the use of db-clik. If you use A97,
you know what I mean. Maybe it deserves explanation...
Let's say you have a macro and you open it to browse. Lets say
it has an OpenQuery action in it and the query name is

Could someone please show me how to write an update to:
Set the daily.Expense field to the total of the transactions.amount
field where transDate = #07/05/04#?
I have tried this with the query builder or wizard and it says my

I have a report that shows a date along with many other fields, I am trying
to keep this date field as small as possible to make room for other fields
so I want it to be a 6 digit date.
My problem is that Windows default Short Date uses 8 digits not 6 so when I

I'm strictly an amteur. Self taught via the help files.
Here is an example of a DB I've done. It is quite simple to some of the ones
I do for my workplace, but it is an example of the way i work. I have
received enormous help from this NG over the years, and I was wondering if

I'm trying to set an (within options table, tblOptions) a setting that can
be read, whehter all reports should be printed or previewed.  I'm happy to
email a sample db if required. When I use the setting I get a Run-time error
'13' Type mismatch!!