I know this should be easy but I can not get this sql statement to work.  It
gives a compile error at the end of the statement.  I am not sure how many
qoutes to place with the semi-colon when have more than 1 lookup variable(?)
Here is the statement:

I am trying to build a report that takes a basic query and links a cross tab
query to it for each row in the original query.  
More specifically I have an original query that returns 52 records related
to certain mergers and acquisitions that have happened over the last 30 or so

How can I start Access minimized?

I have a table with about 8,000 records. The key field is Region. There are
approximately 10 regions. I would like to generate a spreadsheet for each
region i.e. Mysheet01, Mysheet02, etc. Is there a way I can automate this
function? Should the number of regions increase/decrease ...

I have an existing word template with bookmarks that I am sending data to
from my access application.   The users have now asked me to include data
from a child table that can have 0 - many records in it for each parent
record.   Is there a way to loop thru the records in the ...

Dear list,
I have been given the task to migrate a VBA heavy A2k application on W2k to
Vista and Access 2007. I would like to keep the mdb format and the mdw file,
as the application uses 3 main databases and generates various user database

I found the following function that sends emails through CDO object.
Does anyone knows how to change it in order to use exchange server for
sending/receiving emails?
Thank you in advance!

I'm testing the following thing because I'm interested in why it works.
The situation I'm starting with:
I have a table with 3 fields and some data in it. The fields are: Id
(double), Name (text) and Calc (double). I put data into the table like this

I have a form with a  combobox of Department ID's. roughly 150 departments
In the query that this form is based on I have 6 contacts for each of the
department ID's along with thier email, phone etc.
I want to be able to see only the contacts that are attached to that

How does one programmatically unblock a downloaded file with access?
Background:
My FE database needs to search through Microsoft Outlook for the latest
email containing the BE. Save it. Unblock it. Rename it. ReLink to it.

I am having a problem assigning properties to a date(ICUdt) and decimal field
(random). I would like to assign a format of "short date" to the date field
and a precision of 18, scale of 18 and decimal places of "auto" to the
decimal field. I tried to assign the "short date" to ...

I'm finding that arrays in collections seem to be read-only - their element
values can't be changed. I need to get a sanity check on this please. I wrote
the following little routine to test this out, and to understand better
whether the array itself was put in the collection or ...

I don't want to allow a user to enter a duplicate entry of a database field
in the form. Therefore I'm attempt to use a before update event to query the
database for the user's entry and return a message if it is a duplicate. I'm
new to access, but comfortable with ADO, so I'm ...

I have added a lookup field to both table & corrsponding query. When I try to
link this lookup to my form via control source, I get error message. I am
trying to insert this look up list on two selections of same form.

The "Choose" function in a query grid will allow you to select a field name
e.g.
Col1 = Choose (ColOpt, [Field1], [Field2].....)
Can this be done in a VBA function?