I am using the OutputTo action in one of my macros. I have the Output File
argument hard coded to a folder on my C drive. Is there a way to have that
output file defualt to the current folder without hardcoding the entire path?
Sort of like using the App.path in a visual basic ...

Hi- Hope you can help!
I am running a macro (Run SQL) as follows:
UPDATE tvc Set field2 = ((ScannedUnits)/BaseUnits)*100 WHERE 1=1
The problem with this statement or field is that it rounds up/down the

I am working on a macro that imports and merges data from several sources.  I
need to change the field format in a table from text to number.  How do I do
this within a macro?
Thanks,

A test and evaluation system we use is built around Access database.
It does not utilize the Access relational database structure but
instead just two tables: CDD which is the test configurations and MEA
which is the measured data.  The common key is DeviceID which is a

Help!  I've been spoiled by the detailed Find and Replace dialog box in MS
Word.  Now I'm working in PowerPoint XP, and I need to change two spaces and
an open paren to an enter character.  Since a handy list of non-printing
characters is not provided in PPXP, I've tried ...

This is probably really basic, but in my macro is it necessary to have
OpenQuery before I tell it to RunCommand/Run ?  I'm trying to set a macro to
run my make-table query, but if I can avoid having to open the query itself
first I can save about 15 minutes.  Am I even using the ...

I am attempting to create a macro in a subform that will automatically set
the value for a field and I keep getting the error message "The object
doesn't contain the automation object 'Patient Insurance Table'". I have read
several postings on this subject but I still cannot figure ...

alright, hopefully this will be easy to explain.
I have a combo box which is base don a query. The query basically
compares 2 table and whatever ones which are in one but not the other
are put in the combo box. Now, the user picks something from the combo

I'm new to VBA and I need sample macro code to import numerical data in
multiple cells of an Excel spread sheet to an Access database using DDE. Is
that possible?

I would like to create a Macro linked to a button on a form in access 2003
that would take a field entry and open a PDF file in Acrobat Reader with the
same file name as the field entry.  Is this possible?  Can a novice (me)
understand your solution?

after editing/adding a record in a subform,
I'm executing a macro to update field from the subform to the mainform with a
series of 'setvalue' actions. After executing the 4th setvalue, the record
selection jumps to the first record in the subform and continues executing

I would like to have a macro run multiple times using the "Repeat Expression"
until a table has zero records. What would be the syntax of the expression?
Thanks
Dave

I have an interesting question. . . I'm trying to create a prompt in the
TransferSpeadsheet Action for the "File Name" in a Macro.  Meaning when I run
the macro I want a prompt to ask me what the name of the file is that I wish
to import from excel.  Is that possible?

I could delete manually all records and keep the table structure. Is there a
macro that does this for multiple tables? Reason for doing this is my IT guy
is helping me to push weekly data but he needs the table to exist. Can't do
append as previous week data might change.

When I enter data into a access form, I would to have first letter of
each word in caps and all other letters in low-caps
I can do that?
Thank you.