I have a Macro set up that will Output a Query to an xls file.
It all works fine except that I need to specify a certain folder, but Prompt
the user for a file name.
The current OutputTO option only seems to have all-or-nothing (leave it

I am looking for a macro package, perhaps like Macro Express
http://www.macros.com/ which can read values sequentially from an excel
spreadsheet or .csv or .psv file and copy and paste them one-by-one into
a bespoke application, and automatically tell that bespoke application

I have created a macro to goTo the next new record on a form but when I open
the form it still shows the first record.
Does the macro have to be assigned to the form similar to Excel ??
I am using Access 2000

There MUST be an easier way to do this... but I'm struggling... any help
would be appreciated.
I've got a database with two tables.
Table 1 has a list of records - things that I bought last time I went

control + apostrophe will bring up the previous record's value...
I require it to be the previous value PLUS ONE....
if the previous value was 1357 ( numeric), I need field in new
record to be : 1358   ( yet still allow it to be changed..... )

I am getting an error on a simple expression that should stop the Macro from
repeating.

Hi, I have created an unbound form and a parameter query.  The info on the
form is supposed to generate the query.  How do I create a macro such that
when it runs, it will copy the information on the form to generate the query
without the parameter pop-ups showing up?  Thanks!

I convereted a macro to VBA, but now I just have the original macro and a new
module name "convereted macro-blahblah".  I have a control whose event
procedure "on click" is still looking at the the macro.  How do I tell the
control to look at the new converted macro-module so I ...

I need help sending a text string to a texbox in a Word userform. I can call
the Word macro to open the userform but I can't paste or send the result of
a string into the textbox even though the cursor is flashing in the box. How
do you access the objects in the userform assuming ...

I am running Access 2003.  Per Steve Schapel's suggestion, I am trying to
create a macro so users can repetitively import data into a database.  
I can't figure out how to get Access to created an indexed field when it
runs the macro.  When I do a manual File > Get external data, ...

I have recently had to add a new field to a FIRM table in our contact
database, Firm.PhoneNumber (please don't ask why it wasn't there before!).  
The primary key in this table is Firm.FirmID.
I have a list available to me in .csv format that contains all the phone

Is it possible to create amacro that will, once pressed open a pre-mad
mail-merge document? I have the mail merge created already i jsut nee
to be able to link it to a macro so that i can create a command butto
to put on my homepage.

I have created a macro which is being used on the "On Exit" event of a
object on a tabular form. The macro has a number of conditions with an action
on each condition that changes the visibility of a different object of the
form.

    i want to create a macroand i dont know how to begin.Pleease help me.
Emmanuel

I have a macro in an Access database that appends records to another table in
the database and then deletes the original table. Unfortunately due to a
clerical error in the office files were deleted - including the original
table "Newest Contacts" in the database. Now when I go ...