Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

test if another form is open in access

Posted on 2013-01-13
2
Medium Priority
?
234 Views
Last Modified: 2016-02-10
I would like to be able to check and see if a particular form is already open in access from another form.

how can i do that in vba?
0
Comment
Question by:PeterBaileyUk
2 Comments
 
LVL 40

Accepted Solution

by:
als315 earned 2000 total points
ID: 38771469
CurrentProject.AllForms("YourFormName").IsLoaded
0
 

Expert Comment

by:cincimike
ID: 40749155
Thank you for this solution - this worked very well for me.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

916 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question