UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Looking For An Oldie But A Goodie ... Events!, Any Version    
 
   
nuclear_nick
post Mar 8 2018, 12:24 PM
Post#1



Posts: 1,590
Joined: 5-February 06
From: Ohio, USA


Years... and years ago... when I was having trouble with form event programming, I came across a database with a few forms in it... or maybe just one... anyway... when you did sometime on the form, a listbox/textbox (I don't remember which) would scroll along with all the events you just fired off when you did something on the form (clicked a button, entered something in a textbox...)

I found it very helpful in understanding form events and the order in which they occur.

And now I've been working with Access for so long, I haven't needed it.

And now I'm trying to help a few young'uns along, and thought this database would be a good example.

Only with a bookshelf full and the wide, wide web... I've been looking for far too long and still haven't found it.

Anyone know what I'm talking about and can point me in the right direction?
Go to the top of the page
 
orange999
post Mar 8 2018, 01:04 PM
Post#2



Posts: 1,856
Joined: 10-February 08
From: Ottawa, Ont, Canada; West Palm Beach, FL


Hi Nick,

This is where I usually go, but I remember someone had a Debug.Print in each Event and you could follow the order of the events. I don't have a copy nor a link, but I do remember seeing such.
Go to the top of the page
 
tina t
post Mar 8 2018, 01:14 PM
Post#3



Posts: 5,518
Joined: 11-November 10
From: SoCal, USA


nice, orange! for older versions of Access, the same thing is available if you look up Order of events in Access Help.

hth
tina
Go to the top of the page
 
nuclear_nick
post Mar 8 2018, 01:15 PM
Post#4



Posts: 1,590
Joined: 5-February 06
From: Ohio, USA


That's what I showed 'em yesterday, and today got hit with questions because one of my 'pupils' found this...

QUOTE
The BeforeUpdate event is triggered when a control or record is updated.


... and then...

QUOTE
The AfterUpdate even is triggered when a control or record is updated.


So I had to explain more in-depth, when I thought the database I had long ago found would help.

Maybe I just create it myself. Just thought if it turned on someone's lightbulb, it would save me some time.
Go to the top of the page
 
orange999
post Mar 8 2018, 01:25 PM
Post#5



Posts: 1,856
Joined: 10-February 08
From: Ottawa, Ont, Canada; West Palm Beach, FL


Nick,
Might be the quickest way to get a demo database. I know I've seen it, but ??where??. Could be ADH for 2000 or so, I had that one.

There ar lots of events covered in the link I posted.
Forms, records, controls, mouse, reports...
This post has been edited by orange999: Mar 8 2018, 01:28 PM
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    25th September 2018 - 04:00 PM