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: crystal 8 <strive4peace2008@yahoo.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (17)

---

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

.

__,_._,___