Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!
boolean on dlookup not working
Access vba 2010.
I'm trying to run this dlookup and if the field value in "Status" = "In Progress" then i need a msgbox to pop up ?
If Nz(DLookup("Status", "qry_StatusOpen", Status = "In Progress"), False) = True Then
MsgBox ("You Can Not Have More than One Open Status")
End If
This is not working ?
thanks
fordraiders
I'm trying to run this dlookup and if the field value in "Status" = "In Progress" then i need a msgbox to pop up ?
If Nz(DLookup("Status", "qry_StatusOpen", Status = "In Progress"), False) = True Then
MsgBox ("You Can Not Have More than One Open Status")
End If
This is not working ?
thanks
fordraiders
Asked:
Who is Participating?
Experts Exchange Solution brought to you by
Enjoy your complimentary solution view.
Get every solution instantly with Premium.
Start your 7-day free trial.
I wear a lot of hats...
"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.
try this
If DLookup("Status", "qry_StatusOpen", "Status = 'In Progress'") Then
MsgBox "You Can Not Have More than One Open Status"
End If
are you sure there no more other criteria to be consider as part of the Dlookup() statement?
If DLookup("Status", "qry_StatusOpen", "Status = 'In Progress'") Then
MsgBox "You Can Not Have More than One Open Status"
End If
are you sure there no more other criteria to be consider as part of the Dlookup() statement?
You are assuming that
Nz(DLookup("Status", "qry_StatusOpen", Status = "In Progress"), False) = True
Can only return true or false.
And I take it that you believe that it should return false some of the time, and it's not.
It's an odd construction -- and DLookup is evil.
This
DLookup("Status", "qry_StatusOpen", Status = "In Progress")
Is going to return "In Progress" or NULL
and not TRUE
Do it right
Dim db as database
Dim rs as recordset
Set db = Currentdb
Set rs = db.openrecordset(Select Status from qry_StatusOpen where Status = " & chr(34) & "In Progress" & chr(34),dbOpendynaset,dbse
if rs.recordcount > 1 then
MsgBox ("You Can Not Have More than One Open Status")
end if
rs,close
set rs = nothing
Nz(DLookup("Status", "qry_StatusOpen", Status = "In Progress"), False) = True
Can only return true or false.
And I take it that you believe that it should return false some of the time, and it's not.
It's an odd construction -- and DLookup is evil.
This
DLookup("Status", "qry_StatusOpen", Status = "In Progress")
Is going to return "In Progress" or NULL
and not TRUE
Do it right
Dim db as database
Dim rs as recordset
Set db = Currentdb
Set rs = db.openrecordset(Select Status from qry_StatusOpen where Status = " & chr(34) & "In Progress" & chr(34),dbOpendynaset,dbse
if rs.recordcount > 1 then
MsgBox ("You Can Not Have More than One Open Status")
end if
rs,close
set rs = nothing
Experts Exchange Solution brought to you by
Your issues matter to us.
Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.
Start your 7-day free trial
DLookup("Status", "qry_StatusOpen", Status = "In Progress")
I am surprised that compiles
Dlookup needed three string arguments, and this is not good syntax
Status = "In Progress"
Deep-six DLookup.
It's a performance dog
and from your MsgBox I take it you are looking for how many "In Progess"s there are--and there can only be one.
That'd be DCount() -- which is also a dog
I am surprised that compiles
Dlookup needed three string arguments, and this is not good syntax
Status = "In Progress"
Deep-six DLookup.
It's a performance dog
and from your MsgBox I take it you are looking for how many "In Progess"s there are--and there can only be one.
That'd be DCount() -- which is also a dog
so, the "status" field must be Boolean ?
like I said above
are you sure there no more other criteria to be consider as part of the Dlookup() statement?
give more info about your data...
.
like I said above
are you sure there no more other criteria to be consider as part of the Dlookup() statement?
give more info about your data...
.
You probably mean:
If Not IsNull(DLookup("Status", "qry_StatusOpen", "Status = 'In Progress'")) Then
MsgBox "You Can Not Have More than One Open Status"
End If
/gustav
If Not IsNull(DLookup("Status", "qry_StatusOpen", "Status = 'In Progress'")) Then
MsgBox "You Can Not Have More than One Open Status"
End If
/gustav
@fordraiders
can you try this
if dcount("*", "qry_StatusOpen", "Status = 'In Progress'") > 0 then
msgbox dcount("*", "qry_StatusOpen", "Status = 'In Progress'")
else
msgbox "0"
end if
post back the result
can you try this
if dcount("*", "qry_StatusOpen", "Status = 'In Progress'") > 0 then
msgbox dcount("*", "qry_StatusOpen", "Status = 'In Progress'")
else
msgbox "0"
end if
post back the result
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access
From novice to tech pro — start learning today.
Experts Exchange Solution brought to you by
Enjoy your complimentary solution view.
Get every solution instantly with Premium.
Start your 7-day free trial.
Open in new window