1.7 Adding a Real Time Clock to Forms in Microsoft Access

[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

[Amz1217]

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

[Ascaron50]

thx dude u rock :}

[sousoupretty]

on event i don"t have the time interval option

[Firchild]

@sousoupretty You haven't clicked the form selector

[ThePinoyboi23]

Thanks heaps man!!

[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!

[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

[aaroncampf]

Thanks a Bunch!!!

[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

[ignmasayuki]

THANKS!

[ignmasayuki]

@Firchild

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

[budin1998]

Thanks so much

[dearmagician]

thanks, you're amazingggg :D

[kingshinigami1989]

MAN niceee

thanks a lot for these vids :D

[jhvh2008]

Thanks for sharing with us you ideas on Access! this would really be a great help :) keep it up! :)

[ThomasF1991]

thanks very much, clearly explained. Keep them coming

[sumair4u]

Very Nice And Helpful

[MurphDogg11223344]

YOUR A LIFE SAVER!!!

[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.

[anita4774]

This is soooo easy! And i thought it would be tough - Thanks!

[matthewcl375]

very good tutorials!