- Joined
- Aug 31, 2012
- Messages
- 4
- Reaction score
- 0
Hello,
I found the following code from the Microsoft site regarding adding an Idle Timer on your form:
http://msdn.microsoft.com/en-us/library/office/bb243861(v=office.12).aspx
My question is, is there a way to have the minutes be adjustable without having to go through design > vb mode and changing it manually? I've tried creating a table called Idle_Timer with Primary ID and number column for the minutes was able to do an openrecordset to pull the number value and make it a string but it does not like using that string value into the "Const IDLEMINUTES = 13" line where 13 would be replaced by the string value.
The error specifically states that it cannot be a macro, user-defined function, or even procedure which is pretty self explanatory as to why i get the error, BUT is there a way around this so that it's adjustable?
Any help would be appreciated. Thank you!
I found the following code from the Microsoft site regarding adding an Idle Timer on your form:
http://msdn.microsoft.com/en-us/library/office/bb243861(v=office.12).aspx
My question is, is there a way to have the minutes be adjustable without having to go through design > vb mode and changing it manually? I've tried creating a table called Idle_Timer with Primary ID and number column for the minutes was able to do an openrecordset to pull the number value and make it a string but it does not like using that string value into the "Const IDLEMINUTES = 13" line where 13 would be replaced by the string value.
The error specifically states that it cannot be a macro, user-defined function, or even procedure which is pretty self explanatory as to why i get the error, BUT is there a way around this so that it's adjustable?
Any help would be appreciated. Thank you!