Unable to Step Into Access VBA Code

[Dean P.]

I inherited an Access 2000 database that numerous tables, queries, forms,
reports, and modules with VBA code. I opened the Access database with and
without the shift key. I am unable to Step Into (PF8) the VBA code from the
Access
forms or reports in the Design mode.

I am Administrator on this Access database but unable to Step Into the VBA
code.

Please help me resolve the security issue with unable to Step Into the VBA
code in the Access database.

Thanks,

 

[fredg]

I inherited an Access 2000 database that numerous tables, queries, forms,
reports, and modules with VBA code. I opened the Access database with and
without the shift key. I am unable to Step Into (PF8) the VBA code from the
Access
forms or reports in the Design mode.

I am Administrator on this Access database but unable to Step Into the VBA
code.

Please help me resolve the security issue with unable to Step Into the VBA
code in the Access database.

Thanks,

You can't directly step into code attached to a form or a report (you
can if the procedure is in a Module).

To step through a form's or a report's code, first place a breakpoint
in the code.
Then open the form or run the report and do whatever thing is needed
to run the procedure.
The code will stop at the breakpoint. Now you can manually step
through the rest of the code, using the "step through" tool button or
F8.