[AccessD] Calling an event procedure

John W. Colby jcolby at colbyconsulting.com
Mon Dec 22 11:56:58 CST 2003


Then simply use the syntax Forms!MyFormName.SomeEvent.  However... if an
event is passed in a value you can't do this.  Better to place the code in a
function, then call that function from the form's event as well as from
outside the form.

John W. Colby
www.ColbyConsulting.com

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Charlotte
Foust
Sent: Monday, December 22, 2003 12:49 PM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] Calling an event procedure


The procedure you call has to be declared as public or you can't call
it.

Charlotte Foust

-----Original Message-----
From: Lonnie Johnson [mailto:prodevmg at yahoo.com]
Sent: Monday, December 22, 2003 9:41 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] Calling an event procedure



I know I have done this before (at least I thought I had). I just want
to call the Event Procedure of one form from another one.

So if I am in Form1, I want to call the After_Update event of a text box
in Form2.

I thought it was Forms![Form2].TextBoxName_AfterUpdate()

I'm brain dead.

Thx for any help.



"Steven W. Erbach" <serbach at new.rr.com> wrote: Jim,

>> PCAnywhere, for all its weirdnesses does create a suede VPN <<

Suede?!? A little mis-typing there or is this a new, hip adjective?

The host system that my client has is on a cable modem, so that's no
problem. However the remotes will all be dial-up. Does this present any
problems? I used PCAnywhere v. 8 quite a lot with dialup a few years ago
to do remote control work on a client's system. But what you're
suggesting here is a "live" replication, not indirect.

My main concern with this is the number of graphi images added to the
database. I've trained the users to make sure that all the graphics are
converted to GIFs before being pasted into Access...but there will still
be a significant number of them.

This looks workable. I'm meeting with my client tomorrow morning and I
will suggest it to him after eating some humble pie regarding my
too-optimistic presentation of Replication as a good tool for his
situation.

Regards,

Steve Erbach
Scientific Marketing
Neenah, WI
920-969-0504

Message created with Bloomba

Disclaimer: No tree was killed in the transmission of this message.
However, several coulombs of electrons were temporarily inconvenienced.

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



Lonnie Johnson
ProDev, Professional Development of MS Access Databases
Visit me at ==> http://www.prodev.us









---------------------------------
Do you Yahoo!?
New Yahoo! Photos - easier uploading and sharing
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com





More information about the AccessD mailing list