I've been trying to work this little problem out for a while, but to no
avail. I'll start with an example as I've asked before, but not sure if
it was very clear what I'm trying to do.
I have a query which produces the following

I am going blind tonight but I cannot figure out the error.  I get a
syntax error from this sql statement, being run via vba in access 2003
insert into tbl_Volunteer_Donor in "C:\AgencySystemVer1.32.mdb" (
[Company],[ID],[Updated],[PositionTitle],[CompanyMatchInfo],[Last

I have a popup form that has Start and Stop buttons to initiate a search for
email messages.  If the user's Inbox has thousands of messages, the Stop
button will gracefully end the search without making the user wait for the
search to complete.  The form has an option to "start ...

I have a short cut which opens a database and links to a security file
in Access 2002.  Should the same security file and short cut work with
Access 2003 as well, or are there other issues when moving to Access
2003

I've got a database for creating cost estimates for construction jobs.
Within the database there are 2 tables
1.  ProjectIdentifier Table
2.  CostEstimate Table

I'm looking for some general guidance on the following.  We run a
school for emergency medical training.  We have many instructors, each
of which may have one or more teaching certificates, each of which in
turn may qualify the instructor to teach one or more classes.  Working

I have a popup form with a textbox that is bound to a memo field.  I've been
warned about memo fields so I'm wondering if I should use this code.  Is
there any risk with changing the form's RecordSource like this?  Am I asking
for trouble doing this with a memo field?

Hey All-
 I don't think this is possible, but we'd love it if it were.
 We would like to have a pane of our own design docked along the left
side of our Access application's main window. This pane might have any

I am printing a very basic report with a detail section from a query.
When the detail prints out everything is duplicated.  For example, if
there should be two lines, there are four due to the duplicates.  I
have checked the source data and there are no duplicates in it.

I'm working on a school application.  I have a form where the user
selects the marking period
(1, 2, 3 or 4).  That ties in to the "marking_period" field in a table.
If the user indicates, for example, that it's marking period 1, then a

Scenario:
I have a database with user account information, including their
status.  Due to different circumstances, we disable these user
accounts.  First, we send them a warning e-mail and then a suspension

I have a desperate short term need for a way to install Access 2003
runtime on client computers.  I have the proper license to do so but I
cannot seem to find the files to do it like we did with the old Access
2000 Runtime.   Also, I cannot use the MS Package & Deployment wizard

Is it posible to get Access to open with the switchboard opening in
maximised view ?

This is a simple question, which has been debated before, but can I ask it
again with reference to a specific example?  The question is basically
should I close and set to nothing an ADO connection object?  Normally, I
would do this and not worry about whether I could have chosen ...

is it possible to stop a form opening if the result of the query is
null?
eg
select  a company name from a combobox if the name is not in the table