I am trying to run an executable file using runapp comand
in MS Access. I wrote the path as I am supposed to do an I
am 100% sure that the path is correct. The executable file
is expected to run a VC++ program. I am not using MFC(and

I am almost there.  Sorry for posting a new topic but I
figured the original was to buried to be found.
Can I use a variable to define the output file name.
I was going to just use the SendTo cmd to email the

I would like to allow the user to filter a list of contacts based on what
city the contacts are in.  The user would input the city name into a text
box click a button and the new table would open with all the contacts from
that city.  Can anyone help me out with this?

Is there a way I can create a macro (or other mechanism)
that could be on a switchboard or other form which would
open a specific word merge document?
TIA

Is there a way to show in a HEADER or FOOTER a range of dates.  Have created a query for a report, which sums various data, but I would like to show on the report the dates which the data is pulled.  And thank you all in advance and Merry Christmas...Happy Holidays!

I'd like to make a macro action conditional on whether a
Microsoft Word document is open or not.  Can anyone kindly
tell me what expression to use in the condition column?
(The document is a MailMerge document.)

I am trying to use the runapp command to open a file on a
general server but i cannot get it to work. I can open the
application easily enough as that is on my C:\ drive. The
report i want to run from this application is mapped to my

How can I create a macro in access to open another application such as MS Word

I'm trying to not have to exit Access and RunApp MSAccess.  So, I found this RunCommand Opendatabase.  I can't seem to get it to work at all.  If I close the database I'm working on, the macro is halted, kaput.  But if I don't close it and run the RunCommand action, I get ...

I have a macro running on an Access database, and it cannot import all the
lines into the database.  This isn't a problem, and the import errors are
cleared away after.  Is there any way i can suppress the confirmation
messages that it is okay to continue?

AFTER I HAVE USED THIS MACRO TO GET WHAT I NEED FROM THE
TABLE TO EXCEL (GOOD INF THERE!), HOW DO I TURN AROUND AND
DELETE THE LINES OF DATA FROM THE DATABASE THAT ARE NO
LONGER NEEDED HERE?

I am trying to create a button in a form and when i click on the button
it will open a new e-mail in the outlook and put on the e-mail from a
field, a subject that is programmed from before and it will be always
the same on all of the e-mails sent with this button and together with

I have linked an oracle database in access and created a
form to update/add data to the database.  However,
the 'ID' column in the database is in 'number' format.
1: How can I change this 'number' format to 'autonumber'?

what commands do i put in a macro to import files using an
ODBC machine data source?
please reply via post or to:
d k i n g s t o n (at) j a g l y n n (dot) c o m

In a macro I am importing large tables, running some queries and then deleting the imported tables.  The problem is that they are so large I need to compact the databse afterwards.  Is there a way to do this in the macro?