1.7 Adding a Real Time Clock to Forms in Microsoft Access

Using a tiny bit of vba to add a clock to your form

Category:

Howto & Style

Tags:

• Microsoft
• Access
• Forms
• VBA
• Clock
• Real
• Time
• Timer
• Visual
• Basic
• for
• Applications
• Code
• Applet
• Snippet

[sousoupretty]

on event i don"t have the time interval option

[Firchild]

@sousoupretty You haven't clicked the form selector

[mikesta21]

hey thank you for this video! I am wondering if you know how to set a clock in a form that can keep a time seperate than the system clock. Do you know how this would work? Its for a hypothetical time clock for a business (for a class project). Thank you!

[Firchild]

@mikesta21 Off the top of my head, no, but I bet it's be easy enough to code with a default clock value in VB. The only problem is, that would be the start point every time. You need to base it on a clock somewhere. Be that the system clock, or a clock on a web server. You could get a web server/another pc on a LAN/WAN and attach your clock to that default time. No plans to do a video on it though, sorry!

[ignmasayuki]

can you tell me what happen if I wrote 100, or 10, or 10000 in the time interval box?

thanks

[Firchild]

@ignmasayuki Not a lot, just the clock would tick at a different rate

[Copley417]

Simple VBA! Never before have I seen something this smooth for Access.I could stay up all night and watch/listen to this gifted brother.

[UKSecretCourts]

Superb!

You have a natural talent.

[TheCatHatRat]

great video, thanks

[zeca1456]

Thank you very, very much.

You're the best I've seen here on the Internet

[sheppey301]

Anyone able point me in right direction of linking up real time clock to elapsed time on a form i.e timmer shows how long a record is running for

[Jugantarji]

@mikesta21 Just add it to your code e.g.

[Timer] = 0.5 + Now()

For 12 hours further ahead. If you mean it runs on a faster scale say by a factor of 10 then it's:

[Timer] = 10 * Now()

By the way Thanks for the Vids Firchild

[Amz1217]

Wow, this problem has plagued me for ages...finally a clear solution, THANKS.

[Ascaron50]

thx dude u rock :}

[ignmasayuki]

@Firchild

thanks, now I know that time interval in access is based on millisecond, so 1000 millisecond is equal to a second.