RE: [MS_AccessPros] OT: clock -- from: Retain only the letters and numbers in a string

 

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

 

__._,_.___

---

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 (23)

---

Have you tried the highest rated email app?

With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

---

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___