How to declare a global integer in VBA?

[izharmel]

Hi,
I wrote a function in VBA which is called from an SQL proccess.
Some of the iterations of the function don't work properly so I'm trying to fix these conditions.
The bottom line is, I'm trying to compare an integer from one iteration of the function to the following one, but whenever the function gets called again it erases the integer.

DoCmd.RunSQL "UPDATE TableName_
 SET TableName.Time = RoundSeconds(TableName.Time)"
 
 
Public Function RoundSeconds(varTime As Variant)
.
.
.
End Function
 

How can I save data from within the function to compare in the next iteration?

Thanks in advance,
Izhar

[ADezii]

@izharmel

1. Declare the Variable as Static within the Function whereby it will retain its Value between successive Calls, as in:
   

   Static sintYaDaYaDa As Integer

2. Declare the Variable as Public within a Standard Code Module, in which case it will retain its Value until the Application Terminates, as in:
   

   Public gintYaDaYaDa As Integer

[izharmel]

Thank you,
You helped me a lot

[ahmedtharwat19]

ADezii,

Good Answer

Thank You...

(Medo)

[ADezii]

@izharmel
You are quite welcome.