Homebrew Beer: Recipe Timer

[dutch245]

Good afternoon!

I have searched the forum and have not found anything similar to what I am asking. If there is, or if I have posted in the wrong spot please let me know.

I am currently building a database for my newly found homebrewing hobby. In one of my tables, I prompt the user to enter in the time duration for each step of the brewing process as shown here:

ht tp://imgur.com/b1JsZ (I apologize for not directly linking to the image, but because my post count is below 10 I am unable to, and I feel that having the image provides for clearer explanation.)

Now I know that Access has the timer event on forms where a chosen form will open for a duration of time and then close. I am wondering if this can be done for each step in the brew process.

For example, I would like to have a button on my main form called "brew Timer" or something similar to that. Then when the user clicks the button a form will show up displaying the first step and time duration. Then, after the duration has passed have access play an audible alarm alerting the user to begin the next step.

The user would initiate the next step and then click an "OK" button or something similar. This would then step the timer to the next step and repeat the process using each steps respective times.

If what I'm trying to say is clear, is doing something like this possible in Access 2010?

Thanks!

 

[John Big Booty]

Welcome to the forum.

As for posting images have a look at this thread.

This article should help you with your timer.

 

[dutch245]

I saw that article prior to posting, unfortunately it hasn't helped me that much. Biggest issue is that I am very new to access, having worked with it for less than 6 months. I thought I was on a roll, until I figured out you can't set the timer interval property equal to the contents of another field. Had i been able to do that I think I might've almost figured it out! lol

 

[Isskint]

You can set the timer interval using VBA in the forms OnCurrent event. If the field you record the duration in is formated as Date/Time then use;

Dim MilSec as Long ' where Timerrt is the name of your field
MilSec = Second(Me.Timerrt) + (Minute(Me.Timerrt) * 60) + (Hour(Me.Timerrt) * 3600)
Me.TimerInterval = 1000 * MilSec

As you change records this will change the TimeInterval.

If your field is just a number (of seconds or minutes or even hours) you just need to figure a formula to convert that figure into seconds and multiply it by 1000 to get the milliseconds that TimerInterval requires.

 

[dutch245]

Good morning!

Sorry for the delay, I've been a little busy with some other things. I've tried using the code you gave me, however I am unable to get it to work. I am going to try it again, just wanted to let you know I haven't forgotten about the thread!

 

[dutch245]

Okay Isskint, it seems as though I am getting an error when I use your code. Can this code reference a field that is on another form, or does the field need to be on the same form as the on current event code? Would it be easier for me to post my database for troubleshooting?

 

[John Big Booty]

This link should help you adjust Isskint's code.