Translate this page
Provided By Microsoft® Translator
Ms Access Guru

Clock in Access

Display a clock in Access with hands that move!
and, if you want, a sound that plays as each second ticks!

Clock form

Clock in Access

Download

Download Access database application with form that displays an analog clock with hands that move. Folder with sound (WAV) files is included in case you want a sound to play each time the second ticks.

Download Clock_strive4peace_accdb.zip
(240K, unzips to 570 kb ACCDB Access database + 100 kb folder containing 8 Wav files)  

Be sure to save the accdb file from the zip as its own file, as well as the Wav files. Access doesn't work right from inside a zip file.

This Tool may only be used freely -- you may modify it, but not sell it, or use its ideas to make or change a commercial product. Please share your modifications back to the community. Thanks!

Move Lines

Change Top, Left, Width, Height, and Line Slant properties to position lines

Calculate coordinates for the line depending on the angle, which depends on the hand being moved, and the current time. Then translate the calculated coordinates to form properties. See how it work, if you want to, ... or just download and use it.

To display an analog clock, all you need to do is open the form! The code behind the form does the rest ~

References for playing sound

There are lots of different ways to play sounds. Sound can be specified by a system alert, filename, or resource identifier. You can play once, in a loop, or other. You can also play in sequence with other sounds, or independently. PlaySound instead of sndPlaySound might be better for portability.

Docs / Windows / Desktop / Windows Multimedia / Multimedia Audio / Waveform Audio / About Waveform Audio / Simple Audio Playback / The PlaySound Function

Help: PlaySound function

Docs / Windows / Desktop / Windows Multimedia / Multimedia Audio / Waveform Audio / About Waveform Audio / Simple Audio Playback

Help: Simple Audio Playback

Docs / Windows / Desktop / Windows Multimedia / Multimedia Audio / Waveform Audio / Waveform Audio Reference

Help: Waveform Audio Reference

Docs / Windows / Desktop / Windows Multimedia / Multimedia Audio / Waveform Audio / Waveform Audio Reference / Waveform Functions

Help: Waveform Functions

Docs / Previous Versions

Help: PlaySound function

Docs / Previous Versions

Help: sndPlaySound function

from Allen Browne

PlaySound function

Wikipedia

Windows legacy audio components


Resources

Free Book on Access: Access Basics

Free Video Tutorials: Video Tutorials

Every donation is appreciated, thank you!