How can you set the macro security level to low when the application is
installed as a network app and installed for Remote desktop use?  We have an
install on a 2003 server that is running RDC and we want to globally set the
macro security level to low so that people don't get ...

Guys,
I have two reports in Access that I currently output in printpreview using a
Macro. Once I get the Print Preview, I have to manually go in and then click
on Export, then choose the location (path) of where to save my respective

I'm trying to create a search form my database.
How can I use a table's field names as a list?
I know how to walk through the fields of the recordset.
       For varMezo = 1 To rsCimek.Fields.Count

How can I modified the the Add Vendor Macro to have record begin at the
next record below of last recorded entry instead of '1' all the time?
eg: I added a new record(which is record '1')to my vendor form and saved
that record. Then I went back and tried to add another one, but the ...

I am trying to use the Package wizard to create an access program and after I
install it I can't seem to get around the macro stuff.  Can anybody help me
with this.

Currently I have a database(1) that is linked to another database(2).  When I
close database(1) from a form with Close Icon I need to make a copy of
database(2) to a different location.
Is this possible to write code into a macro or into VB to do this?

I have a multi user database and need to know if there is a way to disable
the keyboard or at least the esc key when a macro is invoked via the command
button?
Thanks

I am using A97.
I want to output a report to a particular folder (on our fileserver), with
the choice of folder being determined by specified combo-box (called
[prac_name]) and a specified text box (called [Practice_ID]) - both of which

My apologies if this is a common question or I have the wrong forum.
I have an db designed in Access 97 that I have converted to Access 2003.  I
have several Access Macros that use the SendKeys function to input
information for the printing of Reports.  My Macro does as follows:

I want to have a module open a file and output a report to an html file
based on a paramter value like a unique employee number. The report uses a
query as a data source, SQL and code  I have tried included below. I can't
figure out how to pass the value in the variable "txtnum" to ...

How do I use VB to declare a String variable called StrReport, set the
strReport variable equal to an Input Box with the prompt, "Do you want to
print the Seminars Report? and the title "Seminars Report? and a default of
"yes"