Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » VBA declaring Public variables for use with forms -question for

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

VBA declaring Public variables for use with forms -question for

Resolved · Low Priority · Version 2007

Reply Fri 23 Sep 2011, 18:42Delegate Kathy said...

Kathy has attended:
Access Introduction course
Access Intermediate course
Access VBA course

VBA declaring Public variables for use with forms -question for

Hi,
Please can you tell me how I can use Public variables in Access VBA, if I'm working with forms, and giving the variables their values in the form modules.

I've tried declaring the variable in the form modules and in the standard modules. But if the variable gets its value from the form controls and I try to use it in the other modules, it results in a message that the variable is not defined.

I have also experienced this working with forms and with ActiveX controls in Excel.

I have a work-around in Excel, but it would be good to know how to make the Public dimensioning work properly in Access.

For upcoming training course dates see: Pricing & availability

Reply Wed 28 Sep 2011, 13:41Trainer Anthony said...

RE: VBA declaring Public variables for use with forms -question

Hi Kathy, thanks for your query. The trick is to declare the public variable in a standard module rather than one of the form modules:

http://bytes.com/topic/access/answers/726791-using-global-variables-access-vb-form-modules

Try setting the variable up, then loading it with a value from form 1 and passing it to a control of form 2. Let me know if you encounter any problems with this.

Hope this helps,

Anthony

Access articles

· A Place Of Trust: How Microsoft Have Made Access 2010 Even More Secure
· Learn The Secrets Of Customising An Autonumber Primary Key In Access
· Mining For Data With Access
· How To Make Access 2010 Databases Compatible With Access 2007
· How To Use The New Total Feature In Microsoft Access 2007/10

Please browse our web site to find out more about
microsoft training access course and other Microsoft training courses.

Access tip:

Change The Default Font in Access 2003

You can change the default font in Access 2003 so that whenever you create a new database your preferred font is automatically set.

To change the default font:

1.From the menu bar select Tools.
2.Click Options.
3.Go to the Datasheet tab:
4.In the Default font section select your preferred font from the list of fonts e.g. Arial.
5.Select your preferred size from the size menu e.g. 12.
6.Click Apply.

Click on the Tables/queries tab:
1.In the Query Design font section select your preferred font from the list of fonts e.g. Arial.
2.Select your preferred size from the size menu e.g. 12.
3.Click Apply.
4.Click OK.

The default font for Access has now been changed.

View all Access hints and tips