DCount Syntax

[DS]

I have a problem with the following DCount statement.
I keep getting a Syntax error, any help appreciated.
Thanks
DS


Me.TextMenus = DCount("[MenuID]", "MenuDetails", " & _
"TerminalID = " & Forms!Form4!TxtStation & " " & _
"AND MenuID = " & Forms!Form4!TxtMenu & " " & _
"AND StartDay = 4 " & _
"AND StartTime = " & <Time() & " " & _
"AND EndTime = " & >Time() & " " & _
"AND Active = -1 " & _
"AND AfterMidnite = " & 0 & "")

 

[Tom Lake]

I have a problem with the following DCount statement.
I keep getting a Syntax error, any help appreciated.
Thanks
DS

I'm not sure what you're using < and > for but try the below

Tom Lake


Me.TextMenus = DCount("[MenuID]", "MenuDetails", " & _
"TerminalID = " & Forms!Form4!TxtStation & _
" AND MenuID = " & Forms!Form4!TxtMenu & _
" AND StartDay = 4 " & _
"AND StartTime <= " & Time() & _
" AND EndTime >= " & Time() & _
" AND Active = -1 " & _
"AND AfterMidnite = " & 0 & "")

 

[DS]

I have a problem with the following DCount statement.
I keep getting a Syntax error, any help appreciated.
Thanks
DS

I'm not sure what you're using < and > for but try the below

Tom Lake


Me.TextMenus = DCount("[MenuID]", "MenuDetails", " & _
"TerminalID = " & Forms!Form4!TxtStation & _
" AND MenuID = " & Forms!Form4!TxtMenu & _
" AND StartDay = 4 " & _
"AND StartTime <= " & Time() & _
" AND EndTime >= " & Time() & _
" AND Active = -1 " & _
"AND AfterMidnite = " & 0 & "")

Sorry, doesn't work, Its all in red. I'm using the <> to say that the
StartTime should be less than the current time and the EndTime should be
greater than the current time.
Thanks
DS

 

[Tom Lake]

I missed the first problem at the end of the first line:

Me.TextMenus = DCount("[MenuID]", "MenuDetails", _
"TerminalID = " & Forms!Form4!TxtStation & _
" AND MenuID = " & Forms!Form4!TxtMenu & _
" AND StartDay = 4 " & _
"AND StartTime < " & Time() & _
" AND EndTime > " & Time() & _
" AND Active = -1 " & _
"AND AfterMidnite = " & 0 & "")

 

[DS]

I missed the first problem at the end of the first line:

Me.TextMenus = DCount("[MenuID]", "MenuDetails", _
"TerminalID = " & Forms!Form4!TxtStation & _
" AND MenuID = " & Forms!Form4!TxtMenu & _
" AND StartDay = 4 " & _
"AND StartTime < " & Time() & _
" AND EndTime > " & Time() & _
" AND Active = -1 " & _
"AND AfterMidnite = " & 0 & "")

Sorry, doesn't work, Its all in red. I'm using the <> to say that the
StartTime should be less than the current time and the EndTime should be
greater than the current time.
Thanks
DS

Tom,
I'm getting Missing Operator 3075...

Me.TextMenus = DCount("[MenuID]", "MenuDetails", _
"MenuDetails.TerminalID = " & Forms!Form4!TxtStation & _
" AND MenuDetails.MenuID = " & Forms!Form4!TxtMenu & _
" AND MenuDetails.StartDay = 4 " & _
" AND MenuDetails.StartTime < " & Time() & _
" AND MenuDetails.EndTime > " & Time() & _
" AND MenuDetails.Active = -1 " & _
" AND MenuDetails.AfterMidnite = " & 0 & "")

Thanks
DS

 

[DS]

I missed the first problem at the end of the first line:

Me.TextMenus = DCount("[MenuID]", "MenuDetails", _
"TerminalID = " & Forms!Form4!TxtStation & _
" AND MenuID = " & Forms!Form4!TxtMenu & _
" AND StartDay = 4 " & _
"AND StartTime < " & Time() & _
" AND EndTime > " & Time() & _
" AND Active = -1 " & _
"AND AfterMidnite = " & 0 & "")

Sorry, doesn't work, Its all in red. I'm using the <> to say that
the StartTime should be less than the current time and the EndTime
should be greater than the current time.
Thanks
DS

Tom,
I'm getting Missing Operator 3075...

Me.TextMenus = DCount("[MenuID]", "MenuDetails", _
"MenuDetails.TerminalID = " & Forms!Form4!TxtStation & _
" AND MenuDetails.MenuID = " & Forms!Form4!TxtMenu & _
" AND MenuDetails.StartDay = 4 " & _
" AND MenuDetails.StartTime < " & Time() & _
" AND MenuDetails.EndTime > " & Time() & _
" AND MenuDetails.Active = -1 " & _
" AND MenuDetails.AfterMidnite = " & 0 & "")

Thanks
DS

The Problem seems to be with the StartTime and EndTime fields. When I
remove them it works....
Thanks
DS

 

[DS]

I missed the first problem at the end of the first line:

Me.TextMenus = DCount("[MenuID]", "MenuDetails", _
"TerminalID = " & Forms!Form4!TxtStation & _
" AND MenuID = " & Forms!Form4!TxtMenu & _
" AND StartDay = 4 " & _
"AND StartTime < " & Time() & _
" AND EndTime > " & Time() & _
" AND Active = -1 " & _
"AND AfterMidnite = " & 0 & "")



Sorry, doesn't work, Its all in red. I'm using the <> to say that
the StartTime should be less than the current time and the EndTime
should be greater than the current time.
Thanks
DS

Tom,
I'm getting Missing Operator 3075...

Me.TextMenus = DCount("[MenuID]", "MenuDetails", _
"MenuDetails.TerminalID = " & Forms!Form4!TxtStation & _
" AND MenuDetails.MenuID = " & Forms!Form4!TxtMenu & _
" AND MenuDetails.StartDay = 4 " & _
" AND MenuDetails.StartTime < " & Time() & _
" AND MenuDetails.EndTime > " & Time() & _
" AND MenuDetails.Active = -1 " & _
" AND MenuDetails.AfterMidnite = " & 0 & "")

Thanks
DS

The Problem seems to be with the StartTime and EndTime fields. When I
remove them it works....
Thanks
DS

This Works

Me.TextMenus = DCount("[MenuID]", "MenuDetails", _
"MenuDetails.TerminalID = " & Forms!Form4!TxtStation & _
" AND MenuDetails.MenuID = " & Forms!Form4!TxtMenu & _
" AND MenuDetails.StartDay = 4 " & _
" AND MenuDetails.StartTime <= #" & Time() & "#" & _
" AND MenuDetails.EndTime >= #" & Time() & "#" & _
" AND MenuDetails.Active = -1 " & _
" AND MenuDetails.AfterMidnite = " & 0 & "")

Thank You for your help!
DS