Solved

Is there VBA coding to identify in a Form_Open Event that a DoCmd.Open "frmName" is being opened as hidden?

Posted on 2007-11-13
6
525 Views
Last Modified: 2013-11-27
I'm working with an Access database that may be opened in another form and want to know if the Form_Open Event can tell if its being opened as hidden or visible?

In other words, is there VBA coding to identify in a Form_Open Event that a DoCmd.Open "frmName" is being opened as hidden?
0
Comment
Question by:stephenlecomptejr
  • 3
  • 2
6 Comments
 
LVL 14

Accepted Solution

by:
ragoran earned 500 total points
ID: 20275613
have you try to test the property me.visible ?
0
 
LVL 65

Expert Comment

by:Jim Horn
ID: 20275677
Curiosity overwhelms me.. what is the purpose of opening a form as .Visible = False?  There are very few requirements I've seen where this is needed.
0
 
LVL 14

Expert Comment

by:ragoran
ID: 20275698
Personally, When I have a very large form that are used often, instead of closing the form, I hide them.  So when the user click on my menu to reopeon, I simply made them visible again... much faster

(I managed my own collection of "forms" to implement this behavior)

But I can't assume that it is the same for the asker.

0
Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

 
LVL 65

Expert Comment

by:Jim Horn
ID: 20281578
That, and if you want to have an event that fires every x time interval, that is best done with a hidden form, even though it hogs resources.

I've seen a lot of badly-designed apps that pass variables back and forth using hidden forms.
0
 
LVL 14

Expert Comment

by:ragoran
ID: 20283473
>> I've seen a lot of badly-designed apps that pass variables back and forth using hidden forms <<

Yuck!
0
 
LVL 1

Author Comment

by:stephenlecomptejr
ID: 20290700
>> I've seen a lot of badly-designed apps that pass variables back and forth using hidden forms <<

I've got a startup form that opens another form - that opens up several bound forms to speed up the access to data.  One of the bound forms happen to have combo box's recordsources adjusted upon opening and refuses to be visible until I used the above code.

If you think this is another badly-designed app - you guessed correctly.
0

Featured Post

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

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

When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

831 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