AHA - it was so long ago. Mine wasn't really a clock. It was a stop watch. NOW I remember.
Respectfully,
Liz Ravenwood
Data Technologies
Interior Systems
Rockwell Collins
1851 So. Pantano Rd, Tucson, AZ 85710 USA
(520) 239-4808
Liz_ravenwood@beaerospace.com
rockwellcollins.com
-----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>
------------------------------------
------------------------------------
Yahoo Groups Links
This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
Posted by: Liz Ravenwood <Liz_Ravenwood@beaerospace.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (16) |
Tidak ada komentar:
Posting Komentar