Macro Condition IsLoaded()

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

Guest

I have a database 4 people use. There is a macro to run some delete and
append queries. I want to use the IsLoaded() condition to stop the macro if
the form is open by one of the users. This does not seem to work. The last
thing the macro does is open the form which I use the (...) in the condition.
Any ideas?
 
Hi

You may be better to use a little bit of code like

If CurrentProject.AllForms("FormName").IsLoaded = True Then etc etc

something like


If CurrentProject.AllForms("FormName").IsLoaded = True Then
Some message box
Else
Something else
End If
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IsLoaded condition in a macro 5
Macro for form for collecting report parameters 21
IsLoaded not working 2
Issue copying MS database from active application 3
Put 2 Where Conditions together? 7
Macro Conditions 5
Excel Macro to automatically go to the right of the last colored cell 0
objects in macros 4

Back
Top