P
Pele
I am reposting this because my last attempt in a prior
message was not very clear.
I have created a command button (Reset Main) that is
linked to a macro; the macro will allow me to reset the
values entered in a certain table in my application. That
table is very important and it is used by a lot of queries
etc.
I just noticed that the macro will not run if any other
query that is linked to the table is open. The queries I
am referring to are being run by other command buttons on
various forms in the application.
I need to ensure that the command button called Reset Main
is not enabled as long as any form other than the
switchboard is open i.e. the Switchboard is the only form
that should be open before the command button can be used.
Any ideas. I basically need a way to check and ensure that
the only form open is the Switchboard. OR, I could just
check to see if the table (in question) is being used by a
query or report i.e. can the table be locked down by the
database engine.
Pele
message was not very clear.
I have created a command button (Reset Main) that is
linked to a macro; the macro will allow me to reset the
values entered in a certain table in my application. That
table is very important and it is used by a lot of queries
etc.
I just noticed that the macro will not run if any other
query that is linked to the table is open. The queries I
am referring to are being run by other command buttons on
various forms in the application.
I need to ensure that the command button called Reset Main
is not enabled as long as any form other than the
switchboard is open i.e. the Switchboard is the only form
that should be open before the command button can be used.
Any ideas. I basically need a way to check and ensure that
the only form open is the Switchboard. OR, I could just
check to see if the table (in question) is being used by a
query or report i.e. can the table be locked down by the
database engine.
Pele