Is there anywhere I can buy an older version (simply for the
hoped-for lower price) of Access?
Will it run as a stand-alone?  Or do I need the corresponding
older version of Office and/or OS?

I have two fields on a form.
When I fill in Field1, I set focus to the other(Field2) and then expect
the user to update it. On lostfocus of Field2, if Field1 is not null, I
do a msgbox, saying that field2 must be filled in, and do a

If the user accidentally clicks the X close button I'm using the
following code in the form unload event to stop them from accidentally
quitting Access.
Private Sub Form_Unload(Cancel As Integer)

I need to export a query to Excel with a memo field.  The memo field
keeps getting cut off at 255 characters.  If I just cut and paste, I
get the whole memo field.
I need it in Excel without having to go through all that.  Any ideas?

I am trying to create a database for a shop with a barcode reader the
problem I have is more than likely a simple one but cant get my head
around it.
the question is how do I create a form that says how many items I have

I have a normal table with customer information
I have a DoB field and I want to have an automatic calculation that will show
the age of the customer in another field next to it called Age
Could you please help me with this

If I am in a combobox, is there are way of determining which control
was clicked outside the combobox, before I actually leave the combobox?
I would like to make a decision at the combobox control about what
control

Am having trouble with the filter property setting below.
Would like to filter the listing to car makes beginning
with "D". I'm blowing it on the filter spec somehow???
Sub OpenRecordsetX()

I'm having a system using Access 2000 as both front-end (queries,
forms, reports & temp tables for reports) & back-end (data) with
back-end running on the server. The application runs on the network
with around 15 users.

If I have a query with one field I can write the results to an existing
Excel spreadsheet using
objSht.Range("BK22").CopyFromRecordset rs
What happens if my query has two fields but I only want to write one of them

I have several macro's, but some of then only have to run when a
specific condition is true.
Example:
Macro1 : Load table1

Does anyone know if there is a way to globally turn off ALL control
tips in Access 2003 using VBA code?
Thanks.
--- CL

In 12 months of working on my app, I have never had a corruption problem with
the backends, often with the front end but never the backends.
So, of course, now that I'm planning to roll a new version of the app out
next week, I suddenly had a problem.

Largish system, was 13mb (after de/compile and compact/repair)
It's mostly forms, queries and code.  About 40 local tables (with tiny
numbers of records, like 1 to 10)
Recently added a few more TEMP* local tables (no records) and a couple of

Option Explicit
' requires VBScript to be installed
' (maybe don't give this to your sugnificant other as
' it gets deleted addresses as well as current)