I have a problem.
In two cases the access database is closing completely (but leaves the .ldb
file behind.).
I just added a new form and now when I switch from the design view to the

I am trying to find someone who can advise me on how to access the
functionality of an open source library from MS Access: Specifically the
Picture Metadata Toolkit
(http://picturemetadata.sourceforge.net/index.html).

I've just downloaded the latest win version of postgresql and I'm trying to
use it as an access back end.
Have you aver used it? Did u find any differences between pgresql and mysql?
thanks in advance.

I have a contacts database, in which everyone is classified under a
particular group e.g. staff,contractor etc. I would like to be able to
send group e-mails.
All I would like to happen is that a new message window opens in

I am running an Access report from VB via ADO.
The report has a field that shows the date it was run.
How can I return the data from this field to VB or have Access post it
to a table when the report runs?

I've been working on a database with several tables that I've
established relationships for.
I needed to add some fields to one of the tables and before I did
anything to my current table I worked with a copy of it and made

I have a continuous form with a variable number of records showing on it.
Each record has about 8 fields.  I want to be able to copy all of these
records, then paste them to the underlying table with a different ID number
to the ones they already have. I can pick up the required ...

Is the Between ... And operator strictly reserved for use in SQL?

my access database may be placed on OS with different date settings - i.e.
the date may be m/d/y or d/m/y
how can i use this databse in a consisten way?
I want to be able to sort on the date for example 'select * from ...

This is very wierd...but from what I can tell here's what happens:
I click print on an access form...to print current record. It goes to
the printer. Says "Printing" then it quickly says "Delete-Printing" and
nothing gets printed?

I want to create a crosstab query that looks like this
Date    |    Elevation 1    |    Elevation 2    | ...
______________________________________________________________________
Date 1    |    xx.y        |    xx.y

Using A2K.  I have a table with the columns ClientID, Program, and
EnterDate.  Each client can have multiple records in this table.  Each
record in the table has an ID and a program but not necessarily an
enter date.  How do I pull out only those clients who do not have an

I'm producing a Report of electrical devices tested during a long job. I
have a Sub report of Devices inspected visually. If there are no devices
with problems the Sub report is Blank with just the Lable showing. This is
just how I want it. BUT I need some indication that there ...

Access 2002 & 2003.  Windows XP Professional O/S.
According to the Access Help article "ApplyFilter Event" the
"...ApplyFilter event occurs when the user does one of the following:"
"Filter menu in the Filter window, or clicks Apply Filter on the

If I try to use the present value (pv) I get a user defined error. Must I
set a library reference to use the function ?
Dim set as per MS help
PVal = PV(APR, TotPmts, -YrIncome, FVal, PayType)