I have an Excel file that I use to make charts.  I use access queries
to generate data and then paste it into the excel file.  When I
initiate a macro in Excel, it creates a new file an does all of its
magic to generate the desired product.

Is it possible to run ms-dos commands from an access macro?  Something like
cmd /c does??

How can I use SendObject in a macro to send the current record?  It works
fine for me now but is sends all records.  Any ideas?
Thanks.

I have just updated to XP and although my macros will work I am unable to
either alter them or delete them.
Any ideas.

Can anyone tell me what the Access VBA code is for deleting, inserting, and
rename column heading in a table?

I am trying to check for the presence of nulls or otherwise in combo boxes on
a form using a macro and the use of Is Null or Is Not Null does not work.
Testing of other fields on the same form works fine. Can anyone help?

I am trying to write a macro to Import an Excel Spreadsheet.  The spreadsheet
will always have the same naming convention:  c:\SOP\Input_File.xls  and the
file will have the same layout.
Can this be done via Macro, or do I need to use VBA?

Is there a way of using the FindRecord Action within a macro to search a
specific field in a table for a record (in Access 2000)?  
I have a relatively basic staffing database that details staff's personal
details (e.g. first name, surname, address, etc.).  I need a macro to ...

If when I run a macro that involves opening a query that has a parameter
value to be entered and I press the cacel button on the parameter input box,
how do i prevent the message the tells me the macro is being halted.
Once i press cancel i just want to go back to the form,

Access 2003, Windows XP
The BE is in a shared folder on a server. The FE is MDE with shiftkey
disabled.
The same FE is copied to three users. Two users linked to the BE with no

Is there a way to set up a time sheet where a letter automatically equals a
value (eg: E = 7.5)? I would love to be able to simply type in simple letters
to indicate shift types and have have total times appear at the bottom of the
time sheet.  Right now I am doing it manually.

How do you get the Access to perform the regular operation on a trapped
autokey.  For example, imagine I wanted to trap ctl-c and all I wanted to do
was pop a msg box up, and then have Access do whatever it regularly does
with ctl-c ie let my autokeys trap and do something, and then ...

I clicked on properties for a macro, and it says "hide" i checked the box,
and the macro disappeared.  how do i make that macro reappear?

need help. have 97 microsoft office but need 2003 for school. can i update?

Hey Peeps
I have the below code, that for some reason says i have an invaliud
qualifier at the line 'Shore = Start.Remove(**Start**.IndexOf(Boat),
Start.IndexOf(Boat) + 2)' and highlights the part where i've put stars around