Re: Macro prompt

Steve Schapel wrote:
Pcman,

Can you be more explicit in the meaning of "Access is asking me for a
macro" please? Exactly when does this occur? And exactly what do you
see? Thanks.

I wrote code in VBA utilizing ADO. No macros were written. However, when
running or even trying to step through the program Access is asking me for a
macro. Our office just upgraded to Access 2003. I never had this come up in
Access 2000. The program was written in Access 2003 in Access 2000 format.
Right now I have it at the lowest security level in the macro part of it. Is
this a bug or something or must something be turned off?

Okay, Steve:

When I run the program in the VBA editor a pop-up box comes up. The cursor
flashes in the "Macro Name" line. The box below that would normally display
all the macro names, but this area is all blank (because no macros were
written or assigned to this application). In the dropdown box "Macros In"
has the name of the project. There is only one command button enable which
is cancel. All the others: Run, Step Into, Edit, Create, and Delete are
grayed out. Also another piece of info, this version of Access is still
using SP1. Thanks.

--
Message posted via http://www.accessmonster.com

.

Loading