Where to put code for whole project?

[andrefrancis]

I need to dimension variables and define string constants which will be relevant to all forms in a particular project.

Can someone tell me where I put these?

Thank you (in anticipation)

 

[pono1]

Putting them in a standard module would make them available across the project.

Public MyNumber as Long
Public Const MyString as String = "Hello World"

Regards,
Tim

 

[andrefrancis]

Putting them in a standard module would make them available across the project.

Public MyNumber as Long
Public Const MyString as String = "Hello World"

Regards,
Tim

I tried the above and it gave me a few problems. I suppose it all boils down to the fact that I don't really understand some of the Access terminology. What is a 'standard' module. I think I know what a project is (= a session using Access after double-clicking a .mdb thing) ... I also know what a procedure is, although Access confusingly calls them 'sub" in VBA. However, I don't know what to call the things in between (are they Form Objects?) which go with forms and contain the set of procedures (subs) for the form.

I have got this code in my main form 'on load':

Option Compare Database

Public mainpathstring As String

Private Sub Form_Load()
mainpathstring = "C:\Documents and Settings\andyf\My Documents\AFDoc_Laptop\"

However, at a later point in another form, when I need to access mainpathstring ... it is empty!

How do I keep the value of mainpathstring throughout the duration of the project session ... no matter which form I am using?

 

[Mile-O]

A module attached to a form or a report is a Class module and is enclosed. A standard module is one not attached to a form or a report and is not a Class Module. You add these from the Modules tab in the Database Window.

 

[andrefrancis]

A module attached to a form or a report is a Class module and is enclosed. A standard module is one not attached to a form or a report and is not a Class Module. You add these from the Modules tab in the Database Window.

Thanks for replying so swiftly.

I will try setting my string constant as you suggest.

 

[Mile-O]

Also, above is not a constant.

This is a constant:

Public Const mainpathstring As String = "C:\Documents and Settings\andyf\My Documents\AFDoc_Laptop\"

 

[andrefrancis]

I have now set up a module with a procedure as follows:

Sub pathset()
public mainpathstring as String
mainpathstring = "C:\ ....... etc"
End Sub

Do I need to run this on opening my project? ... and if so, how do I do that?

 

[Mile-O]

I have now set up a module with a procedure as follows:

Sub pathset()
public mainpathstring as String
mainpathstring = "C:\ ....... etc"
End Sub

Do I need to run this on opening my project? ... and if so, how do I do that?

You don't need a procedure. Simply put the line I gave you above into a blank module and you can refer to mainpathstring from other places in your database.

 

[andrefrancis]

Worked like a dream ... thank you!