Parameter value field in access that can be passed?

[Hugh Middity2]

Hello, is there a parameter value field in access that can be passed between queries, forms and reports?
For example, we have two companies both selling the same products. To extract data we have to enter the date twice, once for each company. To print a report we have to enter the date again. Is it possible to enter the date once which can be used by all the processes?
Thanks for your help.

[MMcCarthy]

In a module create a Global variable to hold the date.

Global myDate As Date

When you enter the date set the value to this variable.

Now put a function in a module to return the date

Function getmyDate()
 
   getmyDate = myDate
 
End Function
 

Now set this function as the criteria for the queries.

getmyDate()

Mary

[Hugh Middity2]

In a module create a Global variable to hold the date.

Global myDate As Date

When you enter the date set the value to this variable.

Now put a function in a module to return the date

Function getmyDate()
 
   getmyDate = myDate
 
End Function
 

Now set this function as the criteria for the queries.
Many thanks - I shall give it a go.

getmyDate()

Mary

Many thanks I shall give it a go

[Hugh Middity2]

Many thanks I shall give it a go

Hello,
I have tried reading up on global variables without much success! I am afraid that it will take me a bit longer before I can work them out.
Thanks

[MMcCarthy]

Hello,
I have tried reading up on global variables without much success! I am afraid that it will take me a bit longer before I can work them out.
Thanks

Global Variables:

Have to be declared in a module (not a form module) as follows:

Global strSQL As String
Global intVar As Integer

If you have a few of these you can create a module just to hold them.

Once you have declared the variable you can use it anywhere in your code

Example:

strSQL = "SELECT * FROM TableName"

You don't have to declare the variable locally with Dim.
strSQL will hold this value until you change it regardless of whether you close the form.

Mary

[NeoPa]

Global Variables:

Have to be declared in a module (not a form module) as follows:

Global strSQL As String
Global intVar As Integer

This is perfectly correct but the recommended way of declaring the global variables is now to use the Public keyword rather than the earlier Global keyword.
They will both work at the moment (in current versions that is) but Global is earmarked for extinction.

Public strSQL As String
Public intVar As Integer

[MMcCarthy]

This is perfectly correct but the recommended way of declaring the global variables is now to use the Public keyword rather than the earlier Global keyword.
They will both work at the moment (in current versions that is) but Global is earmarked for extinction.

Public strSQL As String
Public intVar As Integer

Good to know :)

[Hugh Middity2]

Good to know :)

If I understood what you are saying I would respond:)
Regards,
Hugh

[NeoPa]

Don't worry about our prattle Hugh.
Do you understand enough of Mary's post to implement it?

[Hugh Middity2]

Don't worry about our prattle Hugh.
Do you understand enough of Mary's post to implement it?

Unfortunately not. I do not understand VB although I am trying to find a course. I have read a book on Access but this is fairly basic so I have a lot to learn.
Hugh

[NeoPa]

Try going back to post #5 Hugh.
If you find that you can't follow it, let us know where you get stuck and we can lead you from there.