I have a macro that is called from a switchboard. Runs fine, does everything
I need. My problem is security. I only want people with admin rights to be
able to run these macros. Is ther a way that security rights can be testd in
a macro? I would like for the first step to be the ...

I want to clean up my db. How do I tell what macros are no longer used?

I have a two macros that run through a series of queries and scrub my data.  
I would like a way to display the following:
1.  State which query or instruction code of the Macro is currently running.
2.  Estimated time to completion would be cool too, bu tnot neccessary for

i am trying to get the macro to parse the following condition
[FollowUp] Between # &  Forms![Tracking Print By Site]![StartDate] &  # And
#  & Forms![Tracking Print By Site]![StopDate] & #
but it will not.

I am trying to get a button in access to open a powerpoint presentation, I
see I can open a word doc and excel file easily, however the only way I can
see to open a powerpoint presentation is to navigate to powerpoint.exe and
get that to launch, then once in there get the macro ...

I want to set up some letter, faxes etc templates.  I want to set up a
shortcut key that will take me to the next # symbol in the document.  I was
thinking like control + #.

I have many db and converted these over to Access2003.
On of my db a huge one (0.5 / 1.5 GB) is causing some troubles. Each time
when it's finished with the macro it goes into error when I want to quit it.
At the moment the "Repair & Restart" panel is shown. You know the one in

I need to create a Macro in Access to send different Reports/Tables to
different fax numbers. e.g. 1 report to 1 location - Is there any way / easy
way to do this?
Thanks!

I have upgraded to Access 2003 and I don't have any Record macro options. Has
this utility been removed in this version, or do i need to install and
additionaly component ??

I am learning how to output a report to a file in Excel format.  Is there a
way to output a report to the application (Excel)? i.e. open Excel and the
output would be the rows and columns of the opened workbook.  Any help would
be appreciated.

I am trying to amend a macro in an invoicing database written by someone
else. The macro marks an invoice as paid. Following through the code I come to
Function InvoicePriceIncVAT(INum As Long) As Currency
   InvoicePriceIncVAT = InvoiceTotal("Price inc VAT", INum)

I have an update macro running on the Startup Form.
I need to have others use the DB but they have no access to certain files
that are imported with the Macro.
Does anyone know if the Conditions will help?  or is there any other way.

I currently have a parameter query that runs from an unbound form where I can
select from 95 different criteria and then run the query.  This is great, but
I would really like to be able to loop through the 95 criteria without having
to select each one individually.  Is this ...

Is there any way to include data from a subform on a email message as body
text? i know i can create a attachment and send the subform data that way ,
or can i create a report first then send the data only from that report as
the body text? Any help would be great

Can I create a macro in one database that would open a second database (with
it's own switchboard menu)?  I want to have a button on a menu that would run
the macro.  
I can't figure out where to start.  Help!