I'm playing with a generic routine to export data, the concept is to have a
list of data driven templates defining what fields to output.
Evaluating a simple variable field name in the function is easily achieved
by something like

ACCESS says there is a syntax error in this statement.  I am trying to
find out which records are not in the second table.
SELECT Charges.ID, Charges.Total
FROM Charges

I want to copy protect my application. I want to limit its use for a
given period of time, say 30 days, after which a license key will be
needed.
There are various issues to consider here like:

Hy!
I have 4 queries which have 3 fields which have the same names. How can
I make a query which contains all the data from the other 4 queries?
Thanks,

This is something I've done plenty of times in '97, but I can't seem to
get it to work correctly in Access 2003.  Say, for example, I have a
form with an unbound combobox, the data source is a table of customers,
first column is the key field, which is hidden with a 0" width, and ...

First of all I would like to say thank you for all of the help I have
received here.  I have been teaching myself Access for about 4 years
now and I've always been able to find a solution here - until now.
This one is driving me crazy.

I don't know how to form my question but this is my problem:
I would like to fill out a form containing let's say 3 fields and then
when i go to the next record. Now the next record would be blank except
the last field wich would have the value of that same field from the

I created an Access database in Access 2002-2003 that I am trying to
convert to Access 2000.  During conversion, I get error "The report
name ' dirDataCopy' you entered in either the property sheet or macro
is misspelled or refers to a report that doesn't exit."  I click 'ok',

I have a database setup with street names and valid address ranges
(tbl_segme).  In another table, I have customer addresses (tbl_unpub).
I
want to compare the addresses of the customers to ensure my street

Help!
I am calculating a future date using the DateAdd function in a query (the
calculation also involves an IIf statement), and have managed to get this
formula to produce the required result.

Dear Access Guru's,
Hopefully you can help me (as Microsoft don't seem to be able to)
We have an Access database on a Windows 2003 server with 5 CALS in our
office.

If I want to use index keywords for a (simple) database of quotations, do I
need to set each word up in a separate field, or can I list multiple words
in a single field? Or is this the wrong question?
TIA

Can anyone help with the following frustration?
I am trying to export a report into a Word Document with a specific
template. The code snippets are:
  Dim Wrd As Word.Application

I am exporting a table using the TransferTextMethod:
DoCmd.TransferText acExportDelim, "File Specification Name",
"Table/Query Name", "Path"
This works fine for exporting the extire table, but it overwrites the

I have installed Access 97 at least 100 times or more without problem on
W98 and W2000 without any problems.
I have my regular options that I tick, including all the Data and
conversion options.