Good one! I was confused with this the first time through. I couldn't understand why microsoft would come up with something like this and it definitely seemed too easy to implement this feature! Lol. Definitely can be a good lesson.
Hello again Richard, i foud what was the code missing part. you wrote H = - 1 making the field going to -1 and put the M back to 59. you forgot to write H = H - 1
Hi Richard, For some reason, when the timer goes below 0 hours, the countdown goes to -1 hour. from 59 min 59 sec .then counts down when it gets to 0 sec, it displays -1H, 59M, 59 S what am i doing wrong?
nice, i erase all the data in the tables and delete all querys and forms just i leave one that clock, i used for wen i give credit and they dont pay, i do 2 sets one clean the database the other just block the info
Similar in fashion by display, through another developer on UA-cam, I was able to setup a "live clock" to post on my main menu form for my business database. It's nice to see the time, and I was able to set it to 24 HR time format, without the seconds, as I prefer that view. 4 lines of code, if you include the with statement. "LiveClock" is an unbound textbox. Private Sub Form_Tmer With Me LiveClock.Value = Format(Date, "mm-dd-yy") & " " & Format(Time, "HH:nn") LiveClock.FontSize = 20 End With End Sub
Hahahah..... Sir Richard never leaves us empty..
God bless your efforts...
Live long and prosper... ❤
Thanks a ton
You forgot to say BOOM, you got me I was almost going to have a look at the options menu. Cheers
BOOM!!!! :)
So this is the true power of an Access guru UA-camr... 🙂
Thanks
Good one! I was confused with this the first time through. I couldn't understand why microsoft would come up with something like this and it definitely seemed too easy to implement this feature! Lol. Definitely can be a good lesson.
Glad you liked it!
Hi hi you got me I was very interested in this. Steve b
Access Registration Seminar: 599cd.com/Registration
April Fool's but not gonna lie... having a self destructing database would be nice when clients don't want to pony up.
Access Registration Seminar: 599cd.com/Registration
hahaa it was funny. I give you that one. Thanks for the time you take to explain and I enjoy the way you explain in a funny positive attitude. Cheers!
Glad you enjoyed it!
I enyoyed see this video, it was incredible, I think that database could be eraser
Wow you got me again
And again... and again...
Hello again Richard, i foud what was the code missing part. you wrote H = - 1 making the field going to -1 and put the M back to 59. you forgot to write H = H - 1
Hmmm... seemed to work fine for me, but if I goofed... oops. :)
Hi Richard, For some reason, when the timer goes below 0 hours, the countdown goes to -1 hour. from 59 min 59 sec .then counts down when it gets to 0 sec, it displays -1H, 59M, 59 S what am i doing wrong?
Uhm... check your code against mine
nice, i erase all the data in the tables and delete all querys and forms just i leave one that clock, i used for wen i give credit and they dont pay, i do 2 sets one clean the database the other just block the info
Nice
Dang ya got me😂
:)
Similar in fashion by display, through another developer on UA-cam, I was able to setup a "live clock" to post on my main menu form for my business database. It's nice to see the time, and I was able to set it to 24 HR time format, without the seconds, as I prefer that view. 4 lines of code, if you include the with statement.
"LiveClock" is an unbound textbox.
Private Sub Form_Tmer
With Me
LiveClock.Value = Format(Date, "mm-dd-yy") & " " & Format(Time, "HH:nn")
LiveClock.FontSize = 20
End With
End Sub
On which event this code to used ? On open or on current ?
Interesting. How does the clock update? It it on form open or is there some time interval?
Sweet
@@kamleshjain6872 updated my response, as it goes under "Form_Timer", setting the timer to 1000 ms.
@@andos2923 updated my response, as it goes under "Form_Timer", setting the timer for 1000 ms.
Damn I fall, you're freaking mean... 🤣
Yep. :)
I knew what u were upto
:)
😂😂😂😂😂 nice one
Thanks
😹😹. I might of known.. Happy April fool's everyone... Still self destruct product for non payment be a good idea.. 👍😹
Access Registration Seminar: 599cd.com/Registration
😂😅😂😂😂😂
:)