hello guys
can we add windows gadgets like clock and calender to access form?
hello guys
can we add windows gadgets like clock and calender to access form?
Use a third-party add-in or program your own objects. Search the web. I bet it's been done.
Bing: access form calendar clock
Search this forum on keys: clock calendar
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
brs,
I have an unbound text box that I have used for a real time clock for years. It can be set for long, medium, or short time and takes about 30 seconds to set up. It can also be used with a date picker if need be. Extensive code makes it work, but even a novice with little VBA knowledge can code it:
Private Sub Form_Timer()
[Time] = Now()
End Sub
There is a extremely long video on how to set it up; approximately 3 minutes and very user friendly.
Search the net for Adding a Real Time Clock to Forms, if memory serves me correctly. No 3rd party anything.
I think this is what you were really after as an answer.
ROCCO57,
i have already tried setting ontimer property of the form. it works correctly with only one problem.. i have put time text box on a navigation form which contains a subform. now the form flickers every second while updating the time. and as you know this can get very irritating. is there a way past this problem?
brs,
In the video, the individual was using an older version and was able to set the timer value to a certain number. I don't think that is all that easy to get to or adjust as it was in the video. I digress to someone with more VBA knowledge than myself.
I was fortunate; mine has worked without a hitch and I just knew that it was out there without having to purchase any software to do it.
You might go to that video and contact the author and see if there is a solution he might have.
Rocco
brs, why don't you test with a normal form, not a Navigation Form.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
My limited exposure to Navigation Controls showed me that they will flicker when you ask them to do small chores.