Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms Programming / October 2005

Tip: Looking for answers? Try searching our database.

Too Many Forms

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
DS - 25 Oct 2005 12:38 GMT
Is there a way to use the same form over again.  I've benn making a new
pop-up form for every Main form I have....the problem is whenever the
Pop-Up comes up the Main form goes invisible and when the Pop-Up closes
the Main form reappears.  Can I use the Dim Statement for this so that I
can use the same Pop-Up form over and over again?  How would it work?
Thanks
DS
Larry Linson - 25 Oct 2005 23:57 GMT
Is the design of your pop-up forms identical? If it is, then you should be
able to use the same pop-up form with different main forms. Unless you need
to have multiple copies of the pop-up open at the same time, you should just
be able to use DoCmd.OpenForm to open it... from whichever main form you
happen to be on.

 Larry Linson
 Microsoft Access MVP

> Is there a way to use the same form over again.  I've benn making a new
> pop-up form for every Main form I have....the problem is whenever the
[quoted text clipped - 3 lines]
> Thanks
> DS
DS - 26 Oct 2005 12:44 GMT
> Is the design of your pop-up forms identical? If it is, then you should be
> able to use the same pop-up form with different main forms. Unless you need
[quoted text clipped - 12 lines]
>>Thanks
>>DS

I know I can use it over and over agaib to open it but the problem is
closing it.  When I hit OK I have to say that the main form becomes
visable again, everytime though the main form will be different, can I
use the dim statement for this?
Thanks
DS
John Spencer - 26 Oct 2005 16:57 GMT
Can you use the OpenArgs to pass the pop-up form the name of the "calling"
form?  Then you could use that form name to specify which form you want to
make visible, open, etc when you close the pop-up.

>> Is the design of your pop-up forms identical? If it is, then you should
>> be able to use the same pop-up form with different main forms. Unless you
[quoted text clipped - 19 lines]
> Thanks
> DS
DS - 26 Oct 2005 17:30 GMT
> Can you use the OpenArgs to pass the pop-up form the name of the "calling"
> form?  Then you could use that form name to specify which form you want to
[quoted text clipped - 25 lines]
>
> Sounds good, but how would I do This?
Thanks
DS
John Spencer - 28 Oct 2005 17:12 GMT
Are you calling the form through code?
Me.Name would get the name of the form if you were calling from a button on
a form.

DoCmd.OpenForm "PopUpForm", , , , , , Me.Name

Alternatively
DoCmd.OpenForm "PopUpForm", , , , , , "MyWondrousForm"

In the close event of the Popup Form

    DoCmd.OpenForm Me.OpenArgs
or
   Forms(Me.OpenArgs).Visible = True

>> Can you use the OpenArgs to pass the pop-up form the name of the
>> "calling" form?  Then you could use that form name to specify which form
[quoted text clipped - 27 lines]
> Thanks
> DS
DS - 29 Oct 2005 04:03 GMT
> Are you calling the form through code?
> Me.Name would get the name of the form if you were calling from a button on
[quoted text clipped - 43 lines]
>>Thanks
>>DS

Thanks, I'll give it a try.
DS
Rob Oldfield - 25 Oct 2005 23:58 GMT
To answer your first question: yes, there is.  But you'd need to post more
detail for anyone to figure out what you're after.  Pop-up form in what two
situations?

> Is there a way to use the same form over again.  I've benn making a new
> pop-up form for every Main form I have....the problem is whenever the
[quoted text clipped - 3 lines]
> Thanks
> DS
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.