A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

opening and closing a popup form



 
 
Thread Tools Display Modes
  #1  
Old December 22nd, 2005, 09:43 AM posted to microsoft.public.access.forms
external usenet poster
 
Posts: n/a
Default opening and closing a popup form

hi all,

i have had a look for the answer to this, and I have tried several
things but i think i am still doing something wrong.

I would like to achieve the same affect as when you go to
tools/options, where a form opens, gives you options, and you can
either press ok or cancel.

i can get the form to open when you click on a button on a separate
form, but i cant get the options form to close.

could someone help me out with this?

thanks

Patrick

  #2  
Old December 22nd, 2005, 10:14 AM posted to microsoft.public.access.forms
external usenet poster
 
Posts: n/a
Default opening and closing a popup form

Your popup form has a Cancel button that you want to close the form?

Try this as the event procedure for your command button:
Private Sub cmdClose_Click()
DoCmd.Close acForm, Me.Name
End Sub

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Patrick" wrote in message
ups.com...
hi all,

i have had a look for the answer to this, and I have tried several
things but i think i am still doing something wrong.

I would like to achieve the same affect as when you go to
tools/options, where a form opens, gives you options, and you can
either press ok or cancel.

i can get the form to open when you click on a button on a separate
form, but i cant get the options form to close.

could someone help me out with this?

thanks

Patrick



  #3  
Old December 22nd, 2005, 10:23 AM posted to microsoft.public.access.forms
external usenet poster
 
Posts: n/a
Default opening and closing a popup form

"Patrick" wrote in message
ups.com...
hi all,

i have had a look for the answer to this, and I have tried several
things but i think i am still doing something wrong.

I would like to achieve the same affect as when you go to
tools/options, where a form opens, gives you options, and you can
either press ok or cancel.

i can get the form to open when you click on a button on a separate
form, but i cant get the options form to close.

I don't understand - is there a close button ("x" in the top right corner)?
If not then open the form in design mode and set the "close button" property
to "yes".

Keith.
www.keithwilby.com


  #4  
Old December 22nd, 2005, 04:25 PM posted to microsoft.public.access.forms
external usenet poster
 
Posts: n/a
Default opening and closing a popup form

Thanks Allen, that has worked great. Weird thing is that I tried that
code before, and it didn't work. i tried it all again and now it
does...

oh well, i guess that's programming!

thanks for your help

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
closing a form when opening another form Dan General Discussion 2 December 14th, 2005 09:50 PM
Object locked on closing form mabond Using Forms 3 November 10th, 2005 11:54 AM
Closing Forms After Opening A Report Roger Lord Using Forms 2 February 26th, 2005 03:01 PM
how do i get the closing balance of previous record as opening bal ideaplease General Discussion 1 October 24th, 2004 08:25 AM
Opening another form when closing a form HighA General Discussion 1 September 2nd, 2004 06:28 AM


All times are GMT +1. The time now is 10:09 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.