thanks for your nice comment on my Clock video, Bill! Such an honor to
be compared to AD too ~
when I finish the VBA video, I will sign in and reply :)
have an awesome day,
crystal
On 6/25/18 1:27 PM, crystal 8 strive4peace2008@yahoo.com
[MS_Access_Professionals] wrote:
> thanks, Liz
>
> > "cycled through a series of jpgs "
>
> This doesn't do that -- Access moves the hands using Line controls..
> Everything dynamic is native! ... and source code is all there --
> although today I am adding more comments as I am making a code
> walk-through video :)
>
> have an awesome day,
> crystal
>
> On 6/25/18 9:28 AM, Liz Ravenwood liz_ravenwood@beaerospace.com
> [MS_Access_Professionals] wrote:
>> I'll have to check this out.
>>
>>
>>
>> My clock was written in C# that just cycled through a series of jpgs.
>>
>>
>>
>> Respectfully,
>>
>>
>> Liz Ravenwood
>>
>>
>>
>> From: MS_Access_Professionals@yahoogroups.com
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> Haven't had a chance yet. PC time is very limited. Other more-pressing task at hand.
>>
>>
>>
>> Regards,
>>
>> Bill Mosca
>>
>>
>>
>> From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
>>
>> Sent: Sunday, June 24, 2018 11:33 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,
>>
>>
>>
>> thanks! What do you think? Had a chance to look yet?
>>
>>
>>
>> I will share the big one in the future -- probably a few months off though. I made changes to the Clock-only version that need to be incorporated.
>>
>>
>>
>> have an awesome day,
>>
>> crystal
>>
>>
>>
>> On 6/24/18 1:00 PM, 'Bill Mosca' wrmosca@comcast.net<mailto:wrmosca@comcast..net> [MS_Access_Professionals] wrote:
>>
>> 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
>>
>> Sent: Sunday, June 24, 2018 9:07 AM
>>
>> To: MS_Access_Professionals@yahoogroups.com<mailto: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<mailto: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<mailto: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> [mailto:MS_Access_Professionals@yahoogroups.com]
>>
>> Sent: Friday, June 22, 2018 6:17 PM
>>
>> To: MS_Access_Professionals@yahoogroups.com<mailto: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
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>
>
> ------------------------------------
> Posted by: crystal 8 <strive4peace2008@yahoo.com>
> ------------------------------------
>
>
> ------------------------------------
>
> Yahoo Groups Links
>
>
>
