SV: [AccessD] Syntax problem in Access 2000

Hej på Dig Liz!

Excuse me for delay. I was out of office in two weeks.
I have changed our code according to your suggestion and moved the code to a
public module. It worked very well.

The problem was that this application is an very old and advanced
application created of an developer who doesn't work for us any more and I
didn't feel like to change much in his code but now it works.

Thank you very much for your help.

Hälsningar
Goran

>-----Ursprungligt meddelande-----
>Från: Liz Doering [mailto:liz at symphonyinfo.com]
>Skickat: den 30 september 2003 16:28
>Till: goran.pajnic at skanska.se
>Ämne: RE: [AccessD] Syntax problem in Access 2000
>
>
>Did you get it figured out?
>
>Liz
>
>-----Original Message-----
>From: Liz Doering [mailto:liz at symphonyinfo.com]
>Sent: Wednesday, September 24, 2003 10:30 AM
>To: Access Developers discussion and problem solving
>Subject: RE: [AccessD] Syntax problem in Access 2000
>
>
>Hej på dig, Goran!
>
>One form can't see the code associated with another form.
>
>If you move the code you want to run to a public module, you 
>will be able to
>call it from anywhere in your application.
>
>So instead of
>
>Private Sub cmdUpdate_Click()
>'do some stuff here
>End Sub
>
>You'll have in a module
>
>Public Sub UpdateRoutine()
>'do your same stuff here
>End Sub
>
>and, on form X
>
>Private Sub cmdUpdate_Click()
>Call UpdateRoutine
>End Sub
>
>and, on form Y
>
>Private Sub Form_Close()
>Call UpdateRoutine
>End Sub
>
>Hope this helps,
>
>Liz Doering
>Symphony Information Services
>liz at symphonyinfo.com
>www.symphonyinfo.com
>
>
>
>
>-----Original Message-----
>From: accessd-bounces at databaseadvisors.com
>[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Pajnic, Goran
>Sent: Wednesday, September 24, 2003 8:02 AM
>To: 'accessd at databaseadvisors.com'
>Subject: [AccessD] Syntax problem in Access 2000
>
>
>
>Hi group!
>
>Greetings from Sweden!
>
>Syntax problem in Access 2000:
>
>I have a forms called x and y.
>The form X is open and the form Y is open too. On the form X I 
>have a button
>called "cmdUpdate" and some code in On click property for this button -
>cmdUpdate_Click(), in other words. When I close Y (On Close) I will run
>cmdUpdate_Click().
>
> I can't get this work...some suggestions?
>
>Thanks
>
>Goran Pajnic
>Skanska IT Solutions AB
>205 33 MALMÖ
>Sweden
>e-mail: goran.pajnic at skanska.se
> <http://www.itsolutions.skanska.com/> 
http://www.itsolutions.skanska.com


"This message has been written in 100% recycled electrons"


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