where statement, text string & wild card

[Guest]

I wish to pass a where statement to open a report.
I currently have

Dim strInput As String

strInput = "[Company Query]!PostalCode = '" & Me.txtadd & "'"
DoCmd.OpenReport "Company Report", acViewPreview, , strInput

this works fine.

however i wish to adjust this code to use the where statement to search for
anything begning with Me.txtadd

i gather that i need to use LIKE instead of equals and put * in at the end.
however all the commas are causing me problems

any advice??

 

[Lynn Trapp]

Try something like this:

Dim strInput As String

strInput = "[Company Query]!PostalCode LIKE '" & Me.txtadd & "*" & "'"

WARNING: Untested "Air" Code


--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html

 

[Guest]

Brilliant
--
thanks
liz

Try something like this:

Dim strInput As String

strInput = "[Company Query]!PostalCode LIKE '" & Me.txtadd & "*" & "'"

WARNING: Untested "Air" Code


--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html

I wish to pass a where statement to open a report.
I currently have

Dim strInput As String

strInput = "[Company Query]!PostalCode = '" & Me.txtadd & "'"
DoCmd.OpenReport "Company Report", acViewPreview, , strInput

this works fine.

however i wish to adjust this code to use the where statement to search
for
anything begning with Me.txtadd

i gather that i need to use LIKE instead of equals and put * in at the
end.
however all the commas are causing me problems

any advice??

 

[Lynn Trapp]

I'm glad it helped.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html

Brilliant
--
thanks
liz

Try something like this:

Dim strInput As String

strInput = "[Company Query]!PostalCode LIKE '" & Me.txtadd & "*" & "'"

WARNING: Untested "Air" Code


--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html

I wish to pass a where statement to open a report.
I currently have

Dim strInput As String

strInput = "[Company Query]!PostalCode = '" & Me.txtadd & "'"
DoCmd.OpenReport "Company Report", acViewPreview, , strInput

this works fine.

however i wish to adjust this code to use the where statement to search
for
anything begning with Me.txtadd

i gather that i need to use LIKE instead of equals and put * in at the
end.
however all the commas are causing me problems

any advice??

 

[Guest]

Another question along similar lines....

strInput = "[Company Query]!Casino = True'"

The data type stored in the casino field is a yes/no tick box.
I want it to match the ones that have been tickes (so the Yes/True/On) but
am not sure how to code this!?

--
thanks
liz

I'm glad it helped.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html

Brilliant
--
thanks
liz

Try something like this:

Dim strInput As String

strInput = "[Company Query]!PostalCode LIKE '" & Me.txtadd & "*" & "'"

WARNING: Untested "Air" Code


--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html



I wish to pass a where statement to open a report.
I currently have

Dim strInput As String

strInput = "[Company Query]!PostalCode = '" & Me.txtadd & "'"
DoCmd.OpenReport "Company Report", acViewPreview, , strInput

this works fine.

however i wish to adjust this code to use the where statement to search
for
anything begning with Me.txtadd

i gather that i need to use LIKE instead of equals and put * in at the
end.
however all the commas are causing me problems

any advice??

 

[Douglas J Steele]

You have an unnecessary single quote in there, after the word True.


--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Another question along similar lines....

strInput = "[Company Query]!Casino = True'"

The data type stored in the casino field is a yes/no tick box.
I want it to match the ones that have been tickes (so the Yes/True/On) but
am not sure how to code this!?

--
thanks
liz

I'm glad it helped.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html

Brilliant
--
thanks
liz


:

Try something like this:

Dim strInput As String

strInput = "[Company Query]!PostalCode LIKE '" & Me.txtadd & "*" & "'"

WARNING: Untested "Air" Code


--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html



I wish to pass a where statement to open a report.
I currently have

Dim strInput As String

strInput = "[Company Query]!PostalCode = '" & Me.txtadd & "'"
DoCmd.OpenReport "Company Report", acViewPreview, , strInput

this works fine.

however i wish to adjust this code to use the where statement to search
for
anything begning with Me.txtadd

i gather that i need to use LIKE instead of equals and put * in at the
end.
however all the commas are causing me problems

any advice??

 

[Guest]

Atleast it was an easy problem!!!
--
thanks very much
liz

You have an unnecessary single quote in there, after the word True.


--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Another question along similar lines....

strInput = "[Company Query]!Casino = True'"

The data type stored in the casino field is a yes/no tick box.
I want it to match the ones that have been tickes (so the Yes/True/On) but
am not sure how to code this!?

--
thanks
liz

I'm glad it helped.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html



Brilliant
--
thanks
liz


:

Try something like this:

Dim strInput As String

strInput = "[Company Query]!PostalCode LIKE '" & Me.txtadd & "*" & "'"

WARNING: Untested "Air" Code


--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html



I wish to pass a where statement to open a report.
I currently have

Dim strInput As String

strInput = "[Company Query]!PostalCode = '" & Me.txtadd & "'"
DoCmd.OpenReport "Company Report", acViewPreview, , strInput

this works fine.

however i wish to adjust this code to use the where statement to search
for
anything begning with Me.txtadd

i gather that i need to use LIKE instead of equals and put * in at the
end.
however all the commas are causing me problems

any advice??