Hi Crystal
I'd love to see the full-blown version. Are you comfortable with uploading it to our members-only files?
Regards,
Bill Mosca
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Sunday, June 24, 2018 9:07 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] OT: clock -- from: Retain only the letters and numbers in a string
Hi Bill,
in the code video I am making now, I am also covering the trigonometry to calculate position, and diving deeper into the logic to translate coordinates. Hopefully it will be well-explained enough to be helpful. That part will be harder to understand than the VBA code that is used. The module is really not all that long ~ about 150 statements.
I was so happy to get the clock to move! ... to then play a sound each time was icing on the cake. Adding sound is actually quite easy ... oh the ideas ...
To make the ACCDB for public download, I removed a lot of the Clock functionality to make it simpler, so it can be a better teaching tool.
have an awesome day,
crystal
http://MsAccessGurus.com/tool/Clock.htm
On 6/24/18 6:46 AM, crystal 8 strive4peace2008@yahoo.com [MS_Access_Professionals] wrote:
thank you, Bill!
If there are any places you think it needs more comments, please let me know! I am making a follow-up video about how the code works. You won't need that though :)
have an awesome day,
crystal
On 6/23/18 5:08 PM, 'Bill Mosca' wrmosca@comcast.net [MS_Access_Professionals] wrote:
Thanks, Crystal. I can't wait to delve into the code.
Regards,
Bill Mosca
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Friday, June 22, 2018 6:17 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] OT: clock -- from: Retain only the letters and numbers in a string
Hi all (specially Liz and Graham and Giorgio -- finally answered your Q
too),
What ?!? A clock with moving hands in Microsoft Access? with Sounds too
?!? ACCDB so you can see the code? Yes!!!
Finally got it done :) .... had other things to do, so this had to wait
..... now it's Friday! I am so excited to share this with you. I got to
combine 3 of my loves into one really cool form ... Access, Art, and
Music (it's a beat anyway)
video:
Clock with Moving Hands + Sounds in Microsoft Access
https://www.youtube.com/watch?v=8xIyT9ZAezc
download Clock (ACCDB file + folder of WAV files for sound):
http://MsAccessGurus.com/tool/Clock.htm
I'd love to hear your comments ~ good, bad, or whatever
thanks
have an awesome day,
crystal
On 5/30/18 1:45 PM, Liz Ravenwood liz_ravenwood@beaerospace.com
[MS_Access_Professionals] wrote:
> AHA - it was so long ago. Mine wasn't really a clock. It was a stop watch. NOW I remember.
>
>
>
> Respectfully,
>
>
>
> Liz Ravenwood
>
>
>
>
> -----Original Message-----
>
> From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
>
> Sent: Wednesday, May 30, 2018 9:35 AM
>
> To: MS_Access_Professionals@yahoogroups.com
>
> Subject: Re: [MS_AccessPros] OT: clock -- from: Retain only the letters and numbers in a string
>
>
>
> sounds like fun, Liz. I had to use straight lines for the hands, and not even a nice end-type ... but they move! There are 2 modes. One is for setting the time and one is to behave like a clock -- and then the second hand appears too.
>
>
>
> > "Will the clock-making procedure be posted on youtube like https://www.youtube.com/watch?v=P60_G9L5B1w (which has a couple of comments awaiting a response btw :-P)?"
>
>
>
> yes, Giorgio, I will make a video too! ... and when I logon to YouTube and post it, I will answer all the questions ~ but to answer yours right now (thanks for asking!) ... the difference between using "0" and "#" is to force a digit to show or display nothing. "0" will force the display. Here is a link with format codes for numbers:
>
>
>
> https://msdn.microsoft.com/en-us/VBA/Access-VBA/articles/format-propertynumber-and-currency-data-types
>
>
>
>
>
> have an awesome day,
>
> crystal
>
>
>
>
>
>
>
> On 5/30/18 10:37 AM, Liz Ravenwood liz_ravenwood@beaerospace.com [MS_Access_Professionals] wrote:
>
>> Fun. I did one in C# and I had the hands using chimney sweeps because I had a Mary Poppins theme.
>> Respectfully,
>> Liz Ravenwood
>> -----Original Message-----
>> From: MS_Access_Professionals@yahoogroups.com
>> [mailto:MS_Access_Professionals@yahoogroups.com]
>> Sent: Wednesday, May 30, 2018 8:22 AM
>> To: MS_Access_Professionals@yahoogroups.com
>> Subject: Re: [MS_AccessPros] Retain only the letters and numbers in a
>> string
>> agree. very nice, Graham.
>> I'll be interested in those results too!
>> btw, I just finished making a clock with hands that move in Access. So
>> happy! Angles work, translating coordinates works. Now to wrap it up
>> with a pretty bow :)
>> have an awesome day,
>> crystal
>> On 5/29/18 4:10 PM, Liz Ravenwood liz_ravenwood@beaerospace.com [MS_Access_Professionals] wrote:
>>> Thanks Graham for the beautiful explanation..
>>> Respectfully,
>>> Liz Ravenwood
> <clip>
>
>
Posted by: "Bill Mosca" <wrmosca@comcast.net>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (21) |
Tidak ada komentar:
Posting Komentar