MS Access ------ Macro If - Else statement Not Working

[Santhosh23]

Hi ..

I have a subform which stores 3 VALUES Start Time , End Time and Work Time..I am creating a macro to check for the worktime greaterthan 8 hrs and send email to particular person . This is the macro function I used..

If [Forms]![RecordSubform]![Label17]>=8 then
email database object

Else
Msgbox .."No user Logged in morethan 8 hrs"..

when i executed this query it always goes to else statement and I receive this message box ..while my subform has the below values..

StartTime End Time WorkTime
07/27/15 04:55:27 PM 07/27/15 04:56:39 PM 00:01:12
07/27/15 04:57:03 PM 07/27/15 04:58:10 PM 00:01:07
07/27/15 04:58:26 PM 07/27/15 04:59:55 PM 00:01:29
07/28/15 05:22:03 PM 07/29/15 07:01:13 AM 13:39:10
07/29/15 08:04:46 AM 07/29/15 08:04:50 AM 00:00:04
07/29/15 08:05:27 AM 07/29/15 08:05:33 AM 00:00:06
07/30/15 07:40:03 AM 07/30/15 07:40:09 AM 00:00:06
07/30/15 03:11:14 PM 07/30/15 03:11:18 PM 00:00:04
07/31/15 07:49:14 AM 07/31/15 04:19:55 PM 08:30:41
26:07:15 10:24:35 PM 26:07:15 10:24:39 PM 00:00:04

Can anyone please help on this..

Thanks in advance

 

[ranman256]

You dont need an IF,
open query that has the criteria : [Forms]![Mainform]![RecordSubform]!forms![Label17]>=8
then email to everyone in the list.

(but you must give the full path to the sub form) yours didnt. use the builder to get the correct path.

 

[Santhosh23]

You dont need an IF,
open query that has the criteria : [Forms]![Mainform]![RecordSubform]!forms![Label17]>=8
then email to everyone in the list.

(but you must give the full path to the sub form) yours didnt. use the builder to get the correct path.

Hi ..ranman256 ..thanks for the help..did you mean to enter the query in the queryname.. and what properties should be specified for view and data mode..

I executed this query [Forms]![Navigation Form]![RecordSubform]!forms![Label17]>=8 and got an 7873 error..

 

[Micron]

Sounds like your subform reference is wrong (maybe [RecordSubform] is not the name of your subform).
The syntax for referencing CONTROLS on subform:
[Forms]![Main form name]![subform control name].[Form]![control name on subform]

I have found that the syntax is different for referencing properties of a sub form:
forms("MainFormName").Controls("subformControlName").Form.Recordset.Recordcount

NOTE: subformcontrol name is NOT the name of your subform. It is the name of the subform control on the main form that contains the subform.

Is Label17 a label? If so, I think you will have issues with the way you are using it.

 

[ranman256]

use the BUILDER to get the path to the text box correct.
you cant loose using the builder.

 

[Santhosh23]

use the BUILDER to get the path to the text box correct.
you cant loose using the builder.

@ranman256...Thank you..i was able to execute the query and fetch the results .

 

[Santhosh23]

@Micron ...I used Query and If - Else Statement to sought it out..It is working now ..thank you.