VBA, Global Variable and Form

Global Variable and Form

Author	Message
elm.. #1 / 4	Global Variable and Form All global variables are erased when i open a form !!!! Is someone could say me why? I have : Access 97 Variable : All global are in one module Public variable as String 'for examples I launch a code a the launch of my database (Macro Autoexec - Runcode) which load from a table all global variables Form: all my forms are created by docmd.runcommand accmdnewautoform i save them with docmd.save acform, "frmTest" When i launch a form All global variable are erased before each event sub ("OnOpen","OnClick"..) Have i commit a mistake ? (or is it Bill?) Sent via Deja.com http://www.--*.com/ Before you buy.
Mon, 06 Jan 2003 03:00:00 GMT

Sean Marsel #2 / 4	Global Variable and Form Make the variables static. Static variablename as type Or use Constants instead of variables for the values loaded from the table. Sean Marsell
Mon, 06 Jan 2003 03:00:00 GMT

Dirk Goldga #3 / 4	Global Variable and Form These global variables are defined in a standard module, not a form module? If so, then they should retain their values unless something you're doing is causing the project to be reset. If they're in a form or report module, then they will lose their values every time the form or report is closed. -- Dirk Goldgar (remove NOSPAM from reply address) Quote: > All global variables are erased when i open a form !!!! > Is someone could say me why? > I have : > Access 97 > Variable : > All global are in one module > Public variable as String 'for examples > I launch a code a the launch of my database (Macro Autoexec - Runcode) > which load from a table all global variables > Form: > all my forms are created by docmd.runcommand accmdnewautoform > i save them with docmd.save acform, "frmTest" > When i launch a form > All global variable are erased before each event sub > ("OnOpen","OnClick"..) > Have i commit a mistake ? (or is it Bill?) > Thanks > Sent via Deja.com http://www.deja.com/ > Before you buy.
Mon, 06 Jan 2003 03:00:00 GMT

Duane Hooko #4 / 4	Global Variable and Form Can you tell us why you think they are gone? What happens if you press Ctrl+G to open the debug window and then type ? myVariable [press enter] Try this at several stages of your application to see where you are losing the values. Duane Quote: > All global variables are erased when i open a form !!!! > Is someone could say me why? > I have : > Access 97 > Variable : > All global are in one module > Public variable as String 'for examples > I launch a code a the launch of my database (Macro Autoexec - Runcode) > which load from a table all global variables > Form: > all my forms are created by docmd.runcommand accmdnewautoform > i save them with docmd.save acform, "frmTest" > When i launch a form > All global variable are erased before each event sub > ("OnOpen","OnClick"..) > Have i commit a mistake ? (or is it Bill?) > Thanks > Sent via Deja.com http://www.deja.com/ > Before you buy.
Mon, 06 Jan 2003 03:00:00 GMT

Page 1 of 1

[ 4 post ]