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

---

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

• New Members 1

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___