I have two tables I am trying to insert data into. Both tables have an
Autonumber field (which I omitted from the INSERT INTO statement). I have
been successful in coding one of the forms to allow the INSERT INTO, but for
some reason I keep getting an "Invalid SQL Statement" on ...

I have a table with two columns.  First column is Date.  Second column is
Employee.  I want a query to return only the employees that have 6 or more
dates (or entries) and their corresponding dates.   How do I do this?

This is what I would like to do:
(The part that works:)
I have a small form with a button, listbox, and 2 textboxes inside it.  When
I click on the button, the listbox populates with the "computer names" of all

Is is possible to open a Word file and save it to a PDF file from within the
code?
I use the following code to open the word file and save it:
Dim objWord As Word.Application

I have a database with items with expirations dates. Is there a way to make
Access notify you automatically? I want Access to notify me of all the items
that will expire in the next 30 days or less, can this be done?
If it can't be done then how would I write the formula in a ...

Good day,
I have a combo box on a form (FrmMain) that selects information from a table
called TblPack. If I add info into the TblPack through another form aclled
FrmPack It does not diplay in the combo box unless I close the main form and

I have an Access project with several modules, forms etc.
When I put a breakpoint on an event procedure (behind a form) and run the
form I want the code to break so I can debug it.
Also, in my code modules (not behind forms) I have the same problem - I can

Is there any way to run SSIS Package from Access, it is not working with
"Run Application".
Any one please??

I am very new to Access, but I have a decent amount of VBA knowledge from
programming in Excel... I have a situation I could use a little help with. I
have created a database and several replicas that feed information to a very
complex userform in Excel. The userform can detect ...

i have an MS Access application that allows a user to copy network files to
the local drvie.  I use filecopy and this works well.  I would also like to
use vb to create a shortcut for the file copied and place it on the user's
desktop.  Any thoughts will be appreciated.

Hi, using Access 2002, I have an app loaded on a machine with a runtime
version of Access. One of the processes opens another database to run a
process in that app. This works fine when run on a full version of Access.
The runtime halts at the line...

I am working on a database that is used in Germany. The code was written with
Regional settings in English (United States) and it worked fine.  The
Regional settings were then changed to German(Germany) and retested and it
all went south.  I had to "format" the dates because of ...

A client uses Access as a training registration system. Currently, they send
training confirmations to the employee's e-mail but now they would like to
include the boss/supervisor in the cc or bcc field of the confirmation.
Messages are always generated from a specific e-mail.

I have a calculcated field on a form that converts a quantity from metric to
eng if another field on the from is a specified number for various records.  
On the form it works great.  However, when I use the same code for the
report, it converts all of the records to the same ...

The day, I was alwasy dreading in my professional career has finally
happened.  After keeping a low profile for many years I have been asked to
write an access database for my MD.
I have to try to work out the average day's qty required for materials (Item