M
Maarkr
Working on a notification routine. I have a clock on the form that updates
every 60 secs. I can use the following Form_Timer code to open the popup
form ONLY if the continuous form record is selected:
Me!LblClock.Caption = Format(Now, "hh:nn")
Dim datPop As Date
datPop = Format(Me.Text26, "hh:nn")
If Me.LblClock.Caption = datPop Then
DoCmd.OpenForm "popup"
End If
My problem is how to read ALL Text26 fields on the displayed continuous
forms to compare to the lblClock time. It contains time calculations, and I
couldn't modify the query to display on the form properly, but the unbound
form field calculates well. (why I can get an apparently good calculated
time value to show in the query, like 39913.0006944444 but when I drop the
field from the field list on the form I get #NAME?, like it can't find the
field... ???) Anyway, I thought searching a recordset may work, but it's not
a field value, so I'm back to scratching my head on another continuous form
problem... thanks
every 60 secs. I can use the following Form_Timer code to open the popup
form ONLY if the continuous form record is selected:
Me!LblClock.Caption = Format(Now, "hh:nn")
Dim datPop As Date
datPop = Format(Me.Text26, "hh:nn")
If Me.LblClock.Caption = datPop Then
DoCmd.OpenForm "popup"
End If
My problem is how to read ALL Text26 fields on the displayed continuous
forms to compare to the lblClock time. It contains time calculations, and I
couldn't modify the query to display on the form properly, but the unbound
form field calculates well. (why I can get an apparently good calculated
time value to show in the query, like 39913.0006944444 but when I drop the
field from the field list on the form I get #NAME?, like it can't find the
field... ???) Anyway, I thought searching a recordset may work, but it's not
a field value, so I'm back to scratching my head on another continuous form
problem... thanks