473,799 Members | 3,218 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Sequence of Form events

Anyone know if there is an Event that occurs when you open a form AFTER it
is visible on the screen? I've tried Open, Activate, Load, Current, Got
Focus. None of them do. ???
Nov 12 '05 #1
6 12350
Sometimes the obvious may elude us. If the form is already open, why are you
issuing a DoCmd.OpenForm? Why not put code like this in the same place :

Forms!MyForm.me thod

or

Forms!MyForm.Pr operty =

or

Forms!MyForm!My Control <something>
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
www.pcdatasheet.com
"Randy Harris" <ra***@SpamFree .com> wrote in message
news:pH******** **********@news svr28.news.prod igy.com...
Anyone know if there is an Event that occurs when you open a form AFTER it
is visible on the screen? I've tried Open, Activate, Load, Current, Got
Focus. None of them do. ???

Nov 12 '05 #2
I can see why my request makes little sense. I'm trying to do something
that Access really isn't designed for. I want to create an MDE that will
function as a utility. I'd like the StartupForm to appear, then code
immediately begin to run with no intervention from the user. No matter what
I try, the code runs before the form appears on the screen. I finally gave
up and put a Command button on it that the user must click to start the
procedure.

"PC Datasheet" <sp**@nospam.ne t> wrote in message
news:gA******** ***********@new sread2.news.atl .earthlink.net. ..
Sometimes the obvious may elude us. If the form is already open, why are you issuing a DoCmd.OpenForm? Why not put code like this in the same place :

Forms!MyForm.me thod

or

Forms!MyForm.Pr operty =

or

Forms!MyForm!My Control <something>
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
www.pcdatasheet.com
"Randy Harris" <ra***@SpamFree .com> wrote in message
news:pH******** **********@news svr28.news.prod igy.com...
Anyone know if there is an Event that occurs when you open a form AFTER it is visible on the screen? I've tried Open, Activate, Load, Current, Got
Focus. None of them do. ???


Nov 12 '05 #3
TC
Have the startup form say Me.Visible=True at the point where it is about
to run the code & you want it to become visible.

Your question really was, "how can I make a form visible before it runs some
code?", not "what events occur after a form has become visible" :-)
HTH,
TC
"Randy Harris" <ra***@SpamFree .com> wrote in message
news:0B******** **********@news svr28.news.prod igy.com...
I can see why my request makes little sense. I'm trying to do something
that Access really isn't designed for. I want to create an MDE that will
function as a utility. I'd like the StartupForm to appear, then code
immediately begin to run with no intervention from the user. No matter what I try, the code runs before the form appears on the screen. I finally gave up and put a Command button on it that the user must click to start the
procedure.

"PC Datasheet" <sp**@nospam.ne t> wrote in message
news:gA******** ***********@new sread2.news.atl .earthlink.net. ..
Sometimes the obvious may elude us. If the form is already open, why are you
issuing a DoCmd.OpenForm? Why not put code like this in the same place :

Forms!MyForm.me thod

or

Forms!MyForm.Pr operty =

or

Forms!MyForm!My Control <something>
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
www.pcdatasheet.com
"Randy Harris" <ra***@SpamFree .com> wrote in message
news:pH******** **********@news svr28.news.prod igy.com...
Anyone know if there is an Event that occurs when you open a form AFTER it
is visible on the screen? I've tried Open, Activate, Load, Current,

Got Focus. None of them do. ???


Nov 12 '05 #4
"TC" <a@b.c.d> wrote in message news:1066037893 .580461@teuthos ...
Have the startup form say Me.Visible=True at the point where it is about
to run the code & you want it to become visible.

Your question really was, "how can I make a form visible before it runs some code?", not "what events occur after a form has become visible" :-)

Well... You're right. I focused only on how to run the code after the form
became visible. It never dawned on me that it could be done the other way
around, make the form visible before the code is run. Thanks.

HTH,
TC
"Randy Harris" <ra***@SpamFree .com> wrote in message
news:0B******** **********@news svr28.news.prod igy.com...
I can see why my request makes little sense. I'm trying to do something
that Access really isn't designed for. I want to create an MDE that will
function as a utility. I'd like the StartupForm to appear, then code
immediately begin to run with no intervention from the user. No matter

what
I try, the code runs before the form appears on the screen. I finally

gave
up and put a Command button on it that the user must click to start the
procedure.

"PC Datasheet" <sp**@nospam.ne t> wrote in message
news:gA******** ***********@new sread2.news.atl .earthlink.net. ..
Sometimes the obvious may elude us. If the form is already open, why are
you
issuing a DoCmd.OpenForm? Why not put code like this in the same place

:
Forms!MyForm.me thod

or

Forms!MyForm.Pr operty =

or

Forms!MyForm!My Control <something>
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
www.pcdatasheet.com
"Randy Harris" <ra***@SpamFree .com> wrote in message
news:pH******** **********@news svr28.news.prod igy.com...
> Anyone know if there is an Event that occurs when you open a form

AFTER
it
> is visible on the screen? I've tried Open, Activate, Load, Current,

Got > Focus. None of them do. ???


Nov 12 '05 #5
"Randy Harris" <ra***@SpamFree .com> wrote in message
news:0B******** **********@news svr28.news.prod igy.com...
I can see why my request makes little sense. I'm trying to do something
that Access really isn't designed for. I want to create an MDE that will
function as a utility. I'd like the StartupForm to appear, then code
immediately begin to run with no intervention from the user.

Just place doevents command at the start of the your code.

If there is a few other places were you "update" the screen in the code,
again just put DoEvents at that point in the code.

The event driven nature of ms-access means that some screen updates and
drawing does NOT occur during processing (99%of the time, this is the best
way, as you don't waste tons of processing to figure out when to update the
screen...you simply wait until the mouse appears, and then draw everything.
DoEvents will flush all those pending draws, and update stuff out of the
buffer).
--
Albert D. Kallal (MVP)
Edmonton, Alberta Canada
ka****@msn.com
http://www.attcanada.net/~kallal.msn

Nov 12 '05 #6
"Albert D. Kallal" <ka****@msn.com > wrote in message
news:FlGib.8473 2$9l5.64970@pd7 tw2no...
"Randy Harris" <ra***@SpamFree .com> wrote in message
news:0B******** **********@news svr28.news.prod igy.com...
I can see why my request makes little sense. I'm trying to do something
that Access really isn't designed for. I want to create an MDE that will function as a utility. I'd like the StartupForm to appear, then code
immediately begin to run with no intervention from the user.

Just place doevents command at the start of the your code.

If there is a few other places were you "update" the screen in the code,
again just put DoEvents at that point in the code.

The event driven nature of ms-access means that some screen updates and
drawing does NOT occur during processing (99%of the time, this is the best
way, as you don't waste tons of processing to figure out when to update

the screen...you simply wait until the mouse appears, and then draw everything. DoEvents will flush all those pending draws, and update stuff out of the
buffer).
I had tried DoEvents, it, surprisingly, didn't do what I needed. Me.Visible
= True in the Activate Event, however did.
-- Albert D. Kallal (MVP)
Edmonton, Alberta Canada
ka****@msn.com
http://www.attcanada.net/~kallal.msn

Nov 12 '05 #7

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
3349
by: Stephan Parrot | last post by:
Hello people! I have a really weird problem here... Let's say i have 4 lines of codes in a function like this one: SomeSVGDialog.Show(); //this is an SVG dialog box that shows to give some feedback FunctionCall1(); //these functions calls webforms via XMLHTTP and erform stuff
1
2573
by: Robains | last post by:
I'm using a TextBox_Leave event to trigger the saving of a value to my object, however, my object is created via the AfterSelect from a TreView control -- which is fine. BUT, the problem seems to be if my focus is on the TextBox and I click on a TreView control node the sequence of events seems to be: TreView_AfterSelect TextBox_Leave
0
964
by: Frank Reichenbacher | last post by:
Maybe I'll rephrase the question: What is the sequence of events as a form opens and displays its data? Frank
1
8073
by: SammyBar | last post by:
Hi all, I'm having troubles with a Symbol 9000 device (Compact Framework v 1.1) when activating the barcode scanner from a window. The problem is related to the Activated event of the form which carries the task of the initializing the scanner. It looks like this event is not called after the creation of one of the forms. Let me describe shortly the sequence of form creation. The app first call a browsing form by using ShowDialog()....
7
9396
by: David Thielen | last post by:
You would think this list exists but I can’t find it anywhere. Is this the correct order for these events to be called? Global.asax Application_Start (only once) Global.asax Application_Init (initialize for app here – can be called multiple times) BeginRequest AuthenticateRequest PostAuthenticateRequest
0
5531
by: ajloren123 | last post by:
I´ve been working over the EPCM.subscribeEvent I´ve included all the raised events collected from the javascripts. The completed code looks like this: //Subscribe the events from portal //Events raised by browser script+="//EPCM.subscribeEvent('urn:com.sapportals.portal:browser', '*',onGetEvent);\n"; //events raised by load or reload the page
1
1985
by: lathamoulali | last post by:
How theSequence of Events are fired in windows form in C# 2005. I have a treeview control in VB6.0 in a form..and i have written Form_Resize event for that form and where Sync TreeView with form is done.. so when this even gets executed in C#.In C# when the form loads , this event is not getting called. where the treeview control is geting in Sync with the form.. Thanks, LAtha.
1
2092
by: Jordan S. | last post by:
I'm just wondering if this would work. Please note that I'm not asking *how* to raise events. I'm clear on that. What I'm not clear on is the sequence in which events are raised by custom controls relative to the hosting Page, and therefore if the following specific arrangement would even work. What I'm looking to do is dynamically insert multiple custom composite Web server controls onto a blank Page. This is no problem, I know how to do...
2
1452
by: =?Utf-8?B?U2F2dm91bGlkaXMgSW9yZGFuaXM=?= | last post by:
Which is the event sequence when a gridview button (for update) is clicked and the page is post back? I am also a bit confused when to use ..IsPostBack(). If my page data is changing maybe in every 10 or 20 seconds, should I use .IsPostback? If not, then the gridviews databinding in the page should be written in Page_Load or in the other events like SelectedIndexChanged, RowCommand where the click is handled? TIA Iordanis
0
10260
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
10243
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
10030
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
7570
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6809
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5467
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5590
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4146
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
3
2941
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.