Right now my macro tha can save my query as a .csv file. I would like it to
save as .xls. I am new to programing so please help me. Here is what my macro
or "RunCode" is:
-----------------------------------------------------------------------

I want to create a macro that could open a specific folder (with windows
explorer). I went to create a new macro, and chose RunApp under 'Action'. In
the command line I type the address (eg. C:\Windows). But this did not work.
The error message says Microsoft Access could not ...

I am trying to use the APA StyleEasy program and it says that Macro in this
project are disabled.  How do I enable this macro?

I have a database, which you can make ONE label and then you can print the
label in 19 languages BUT if the field "Productname" is empty, it should
stop... but I can't seen to get it working right..
F.x.:  Productname in UK are "Product 1" and Productname in Austria is empty

I would like to apply a filter upon opening a form.  I have created a macro
to open the form and see that I can apply a filter.  I have already created a
query that acts as the filter.  Under filter name can I just enter the name
of the query I have created?

I'm looking for a book or website that explains all the items in the pick
lists for building macros and so forth.  It is not in the help option or the
books I currently have (Access 2000 Bible and How to do Everything with Acess
2002).  I don't do programming yet so it needs to ...

I am building a Employee Training Tracker .  I want to use setvalve to
automatically populate the Hours for each class based on which Course is
selected in the Combo Box.  The sngHours Field in the
tblAOGAnnualTrainingCourse table has the hours predetermined. I have the

How can I schedule a daily email to users  - only using the Macro
functionality?  Without opening the database every day?
I understand how to use the SendObject functions, however, I do not know how
to schedule the macro?

I have Access 2000, and have used an old Access 97 module as my source for
the syntax of statements for a new module I'm writing.  Basically, I want to
have a macro execute the code, which will read a table from the open database
one record at a time, perform some logic, and ...

I am trying to copy a customer ID number from one form (customer ID is key
from this table) and use this ID in another form/table (can have many ID
entries).  I have been able to find an expression to pull current entries,
but can not seem to create a new entry in another table.

I have a data bases that we import student names into.  They now want me to
update it every month.  Will Access over write duplicate data when importing?

I need to run a report every night and it is easiest to have as a html file,
and I need this emailing to a number of people every night, Is this possible.
I am presently using xp -home edition with Office 2003.
I have set up a macro to produce the report.

I have tried to transfer my old database onto my new pc using access 2003 as
well and i have the following error message
Security warning..
trying to open file......blah blah....

Now to make process converting xls files to existing mdb automatically?

I can never see my entire query name in the little tiny box that the Macro
gives you for selecting your query when you add an openquery statement to the
macro. The box which shows up at the bottom of the  screen needs to be
resizable. I thought it might get fixed in Office XP and ...