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  

How to pause code in procedure when opening new form



 
 
Thread Tools Display Modes
  #1  
Old August 7th, 2005, 09:30 PM
A.J.M. van Rijthoven
external usenet poster
 
Posts: n/a
Default How to pause code in procedure when opening new form

I made a login form.
You can enter username, password and a new password on this form.
When data is entered in the 'new password' textbox, a new form opens.
On this new form (re-enter password), the new password has to be
entered again to dubbelcheck the input. When this new form is opened,
I want to stop the procedure on the login form. When the password is
entered correctly in the re-enter password form, the new password has
to be stored, the form (re-enter password) has to be closed and the
rest of the procedure on the login form may execute.
How do I manage to pause the procedure on the login form while the
second form is open and restart the procedure where it stoppend when
the new form opened or is there another solution for this problem?

Thanks in advance,
Toine
  #2  
Old August 7th, 2005, 10:00 PM
Ofer
external usenet poster
 
Posts: n/a
Default

Open the second form as dialog, the code will continue only after you'll
close form 2

DoCmd.OpenForm "FormName", , , , , acDialog

"A.J.M. van Rijthoven" wrote:

I made a login form.
You can enter username, password and a new password on this form.
When data is entered in the 'new password' textbox, a new form opens.
On this new form (re-enter password), the new password has to be
entered again to dubbelcheck the input. When this new form is opened,
I want to stop the procedure on the login form. When the password is
entered correctly in the re-enter password form, the new password has
to be stored, the form (re-enter password) has to be closed and the
rest of the procedure on the login form may execute.
How do I manage to pause the procedure on the login form while the
second form is open and restart the procedure where it stoppend when
the new form opened or is there another solution for this problem?

Thanks in advance,
Toine

  #3  
Old August 8th, 2005, 12:19 AM
Albert D.Kallal
external usenet poster
 
Posts: n/a
Default

I explain how to halt code, but MORE important how to get the form to send
values BACK to the calling code.

And, no..you don't want to use global to do this!!

You can find the solution he

http://www.members.shaw.ca/AlbertKal...log/Index.html

--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada

http://www.members.shaw.ca/AlbertKallal


 




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
Problem opening a parameter query from code Simon Cleal Running & Setting Up Queries 7 June 27th, 2005 05:09 PM
Do I need to put any type of pause in the code below? Walter Steadman Running & Setting Up Queries 1 June 11th, 2005 06:58 AM
Procedure run (Access open / Close) Niklas Östergren General Discussion 9 December 29th, 2004 03:02 PM
Opening multiple workbooks through code and copying values Pam R General Discussion 1 September 29th, 2004 12:16 PM
Access 2003 closes when opening Code editor AndyM General Discussion 5 September 28th, 2004 02:38 AM


All times are GMT +1. The time now is 11:57 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.