Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms / March 2008

Tip: Looking for answers? Try searching our database.

Running Query from form with wildcards

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
bymarce - 17 Mar 2008 18:02 GMT
Based on a previous post, I used [Forms]![Search Form]![MLO #] in my query to
refer to my form and put a command button to run the query.  The MLO # is a
catalog number in the form of ####-####.  I am able to run the query for
exact matches to the entire field but it doesn't work for ranges or matches
to part of the field.  Is there a way to use wild cards on the form?  I've
tried typing an expression on the form as I would on the query, such as
>####-####.  I also have a column for desciption refered to as
[Forms]![Search Form]![Description] in my search.  For this column we usually
search with * because the search criteria is only part of the field.  In the
form I tried using *criteria* and it didn't return anything.  Also in the
query I tried putting *[Forms]![Search Form]![Description]* and access
changes it to Like "*[Forms]![Search Form]![Description]*".  Thanks for the
help.
      ByMarcie
Douglas J. Steele - 17 Mar 2008 18:44 GMT
Try changing that to

Like "*" & [Forms]![Search Form]![Description] & "*"

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> Based on a previous post, I used [Forms]![Search Form]![MLO #] in my query
> to
[quoted text clipped - 16 lines]
> help.
>       ByMarcie
bymarce - 17 Mar 2008 21:05 GMT
Thankyou very much.  It worked.
      ByMarce

> Try changing that to
>
[quoted text clipped - 20 lines]
> > help.
> >       ByMarcie
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.