Play alarm for each time

with vb6 + access03
.............................
i have a field time(date/time)

how to accomplish this please
i want to play a music file for each record set in a table.
if _
for each recordset.value = now() then
playmusic() '
next
end if
please guide me..
...
for each

Load all of the times from the database and store them somehow - I would recommend an array or collection.

Then add a timer to your form with an apt Interval value, and put code in it similar to what you posted.

If you don't know how to play a sound file, see the "Multimedia" section of our Classic VB FAQs