Hi all
Just wondered if there's a list somewhere that explains when the events on
forms, reports, etc fire. I'm looking for the order of things. Like, the
first event to fire when a new form is opened is 'a'. Then, 'b' is
activated. So I'd have a=>b, etc. And when does the actual data pop into
the form from the underlying table. That kinda thing.
Also, need the same thing for when things happen for a control on a form,
etc.
Is there a handy dandy reference someone can point me to? A book that would
itemize this sort of thing? I've checked the Access2000 help file and if
it's there I can't find it. I've bought some elementary books on the
subject--no such listing. Sure, there's some explanations, but no roadmap
with that kind of detail. See, I know I can put a routine in On Load, or On
Current...but which happens first, then second, then if this happens, this
other thing fires? I've tried experimenting and I seem to be either too
early, or too late. (Story of my life...)
Thanks in advance for any help anyone can offer.
ron 2 10265
This book has it:
AccessXXX Developer's Handbook, Getz et al, Sybex
Where XXX is your version of Access
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications re******@pcdata sheet.com www.pcdatasheet.com
"Ron" <ro************ *******@earthli nk.com> wrote in message
news:X5******** *******@newsrea d1.news.pas.ear thlink.net... Hi all
Just wondered if there's a list somewhere that explains when the events on forms, reports, etc fire. I'm looking for the order of things. Like, the first event to fire when a new form is opened is 'a'. Then, 'b' is activated. So I'd have a=>b, etc. And when does the actual data pop into the form from the underlying table. That kinda thing.
Also, need the same thing for when things happen for a control on a form, etc.
Is there a handy dandy reference someone can point me to? A book that
would itemize this sort of thing? I've checked the Access2000 help file and if it's there I can't find it. I've bought some elementary books on the subject--no such listing. Sure, there's some explanations, but no roadmap with that kind of detail. See, I know I can put a routine in On Load, or
On Current...but which happens first, then second, then if this happens, this other thing fires? I've tried experimenting and I seem to be either too early, or too late. (Story of my life...)
Thanks in advance for any help anyone can offer.
ron
See:
Understanding Event Order in Microsoft Access 2000
at: http://support.microsoft.com/?id=208781
The article gives you a download (orders.mdb) that contains ShowEvents and
EventHistory.
The crucial form events are are:
1. Open occurs first. You can cancel the open, or assign a RecordSource
here.
2. Load occurs next. Assign values to controls here.
3. Current occurs next, and then every time you move record.
4. The form's BeforeUpdate fires before the record is saved. Use this for
record-level validation.
--
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.
"Ron" <ro************ *******@earthli nk.com> wrote in message
news:X5******** *******@newsrea d1.news.pas.ear thlink.net... Hi all
Just wondered if there's a list somewhere that explains when the events on forms, reports, etc fire. I'm looking for the order of things. Like, the first event to fire when a new form is opened is 'a'. Then, 'b' is activated. So I'd have a=>b, etc. And when does the actual data pop into the form from the underlying table. That kinda thing.
Also, need the same thing for when things happen for a control on a form, etc.
Is there a handy dandy reference someone can point me to? A book that would itemize this sort of thing? I've checked the Access2000 help file and if it's there I can't find it. I've bought some elementary books on the subject--no such listing. Sure, there's some explanations, but no roadmap with that kind of detail. See, I know I can put a routine in On Load, or On Current...but which happens first, then second, then if this happens, this other thing fires? I've tried experimenting and I seem to be either too early, or too late. (Story of my life...) This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: abs |
last post by:
Hi all.
My list:
<ul>
<li id="a" onclick="show(this)">Aaaaaaaa</li>
<li id="b" onclick="show(this)">Bbbbbbbb</li>
<li id="c" onclick="show(this)">Cccccccc
<ul>
<li id="d" onclick="show(this)">111111</li>
|
by: Jim Cobban |
last post by:
I cannot get Netscape 4.79 to properly display the ordered list in the
following fragment.
<P>Get a specific portion of the date.
Depending upon the value of index:
<ol start=0>
<li>complete value, usually as a <code>String</code>, or if
an integral value as an <code>Integer</code>.
<li>year as an <code>Integer</code>
<li>month number as an <code>Integer</code>
|
by: Jonny |
last post by:
Hello,
I have a List Box in my DB on a form, which when the form is opened,
the list box displays the date relating to the records. (Date, Person
etc)
How can I get it so that when I open the form, ONLY the records with a
date within the current month are shown.
Thanks in advance.
|
by: Dave Hopper |
last post by:
Hi
I posted a question recently regarding problems I am having getting a
value from a list box to use in a query. I got a lot of help, for
which I thank you and it's nearly working! But I need a little more
help on one more point.
This is what i've got. I have code that hunts for updated
appointments in a public folder based on the order that happens to be
open (code fires on an on open event) This works fine and updates my
|
by: Susan Bricker |
last post by:
The following error:
"The current field must match the join key '?' in the table that seves
as t the 'one' side of one-to-many relationship. Enter a record in the
'one' side table with the desired key value, and then make the entry
with the desired join key in the 'many-only' table."
... happens when I click on an entry of a combobox. HELP!!
Here's the background:
| |
by: Galina |
last post by:
Hello
I have 6 dependent list boxes on my ASP page:
Faculty;
Lecturer;
Course;
Course occurrence;
Group;
Week commencing date.
When faculty is selected, lists of lecturers and courses are
populated. When course is selected, lists of occurrences, groups and
|
by: Mark |
last post by:
I have two dropdown lists. Both have autopostback set to true. In both
dropdowns, when you select an item from the list, it redirects to the Value
property of the dropdown. Nothing fancy.
Let's say you select 1 of the items, and are properly redirected. You press
the back button. I have three servers providing two different
functionalities:
1. After pressing the back button, the item you selected in the dropdown is
still selected.
|
by: AA Arens |
last post by:
Hi,
I have a database with 2 main forms. Contacts and companies. I share
the base with two others via LAN. On the companies form I have buttons
to navigate throught the records
(>400). We are mostly handling let say 5 companies. Every time I have
to navigate or choose the find record button to get the right company.
I am looking fo a feature to have listed in a combo list the last 5
visited records ("recently visited records").
|
by: fastestindian |
last post by:
Hi,
I am working on the project where i show a list of Log Records.
my list is as follows.
Original list
Id Time Event Details
1 1 Error1 xyz
2 1 Error3 xyz
3 1 Error2 xyz
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
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...
| |
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...
|
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();...
|
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...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
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
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
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...
| |