MS Access 2003 - using a split database.
I am using a switchboard. I have set in Options to "Compact on Close".
What code do I put behind the Exit button on the switchboard so the
database Compacts the FE on Close and closed the MS Access Window?

I have a FE / BE setup on my database.  One of the main reasons that
I
did this was so that I could edit the front end and upload it without
causing problems with day to day activities.

I have a search form with a subform that holds the results.
Three text boxes are search criteria:
First Name
Last Name

I've been searching for a few hours on how to check the available disk
space (on a Flash disk actually) from within MS-Access.
Basically, I want to ensure there is adequate room on the Flash drive
before a Backup is attempted.

I have a continuous form with three fields: id, date, score. I am
trying to add total field on the form footer to show total score for
certain year.
I created a unbound textbox and set the control source as:

I need to import a call log and determine the datetime of each
person's fourth out of potentially many more calls (ordered by date).
Obviously this is only for those with four or more calls.
1/1/2007 5pm

I'm trying to put the mousehook code in the load event of a switchboard,
since this is the first form that is opened when a user logs on. I know zero
about code, so what do I need to write in the load/unload event sections of
the code for the switchboard to turn it on and off? I'm ...

I'd like to be guide to do that:
I have 2 tables [In Access 2002]:
----------------      ----------------

I've installed SQL Server Express and upsized a couple of databases
(tables only).  Almost everything works well but I've hit a snag with
one of my queries.  If I have a calculated field like: "SchedDelay2:
[SchedDelay]*[Forms]![QDelays]![DateSpan]*60" in the query grid, I get

Is it possible to run a procedure/subroutine in an open form from
another open form?  I assume the procedure would have to be public but
maybe not.
If so, what would be the syntax?

Hi folks, thanks for taking the time to read this (and hopefully point
our where I'm going wrong).
The scenario:
I have a local Access2007 database which links in several read only

Is there a way (besides Case or IIf), to type a value into field1 and
have that value added to the value inside a memo or text field?
Example:
memo/text field has: hello

When I output a table's values to XLS, one value in a very small
table, and only one value, is changed.
Here are the values in the table, tblLevel.
LEVEL

I would like to generate a versionnumber (and save it in a internal table)
on the moment I make a mde.
Then there would also be such version tabel in the central, linked data mdb.
When the mde is opened it checks if the number in the datafile is higher,

I have a report that contains an image in it's header (an embedded bmp
file).  When I choose "Publish it with MS Word" the report opens fine in
Word but the image isn't there.  Is this a known issue or am I missing
something?