Macros Fail to Execute in Access 2003 Database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

A database I created in Access 2002 utilizes macros to open certain reports.
However, when a user opens is up in Access 2003, the reports do NOT open and
I believe it's because of the macro security. I tried setting the macro
security level to "low" but it will still not open the report.

Any ideas or suggestions?

Thank you!
MN
 
DoCmd.OpenReport "Sales Report", acViewNormal

DoCmd.OpenReport "Name", acViewPreview, , , acWindowNormal

I have not had anything fail using Visual Basic and the DoCmd.openreport
"ReportName",

I recommend that you open it in "acViewPreview" because normal for a report
is to print it.

You can use a Where clause, but writing them is a little more complicated.

The macro button wizzard works very well here.
 
Dates in office and windows are numbers in a database like "1008.12323". The
1008 is the number of days since sometime in 1890. The ".12323" is a time
stamp as a decimal.

Elapsed time is (date) - (otherdate)

30 days from now = (date)+30

Billing applicaitons can be harder. I recommend that you only use 28 days
for a billing cycle. Use 29 through 31 as month end work when possible.

You can always use the month(date) , day(date) and Year(date) functions to
give yourself finer contrl.

There are all sorts of built in functions to help with days of the week, and
month ending.
 
Back
Top