MyTechSupport.ca :: Your Computer Technical Resource Headquarters! MyTechSupport.ca :: Your Computer Technical Resource Headquarters!
HOME FORUMS RESOURCES & TOOLS ARTICLES ONLINE STORE ABOUT US
Computer Support Forums arrow Software Support arrow Database Problems arrow Topic: MSAccess Wildcard Query
June 26, 2019, 07:26:30 PM
 

Home Forum Rules Help Search Mobile Version Login Register

Welcome, Guest. Please login or register.
Did you miss your activation email?
June 26, 2019, 07:26:30 PM

Login with username, password and session length
 
News
New  Looking for cheap hardware and/or software?
Visit our new Online Store where you will be able to purchase from a reputable vendor by country.
  0 Members and 1 Guest are viewing this topic.
Pages: [1] Go Down Print
Author Topic: MSAccess Wildcard Query  (Read 4603 times)
JoeMastra
Jr. Member
**

Karma: +0/-0
Offline Offline

Gender: Male
Posts: 11


Bookmark and Share

View Profile
« on: December 10, 2005, 01:44:26 AM »

I've got a bit of a problem with Microsoft Access.

Right now, what I'm doing is making a form. There is a textbox in the form that is linked to a query, so when you enter in a value into the textbox and hit search, it will return the matching values in your database.

The problem is that I want it to be able to do wildcard matches as well (i.e., I search for "Batman*" and it will return the movies "Batman" and "Batman Begins" etc)

I realize how you need to code the criteria in the query for a wildcard match is "Batman*" if you want to return all things that start with the word Batman, and I also know that to set the value of the criteria to the textbox, it needs to be (in the case of my database) "[Forms]![MovieForm]![MovieTitleTextbox]", but I don't know how to make it so that the value I set in the textbox can search for wildcard matches.

Anyone help?
Logged

 
Pages: [1] Go Up Print 
 
Jump to:  

Powered by MySQL Powered by PHP

Powered by SMF 1.1.21 | SMF © 2015, Simple Machines

Valid XHTML 1.0! Valid CSS!

Disclaimer
This site is NOT responsible for any damage that the information on this site may cause to your system. Everything you try, whether inspired by the response given from this site or not, is entirely at your own risk. All product names and company names used herein are for identification purpose only and may be trademarks or registered trademarks of their respective owners. We are in no way affiliated or representing any of the companies on this site unless specified.
Back to Top
Stop Spam Harvesters, Join Project Honey Pot Fight Back Against Spammers! Get Firefox! Get Thunderbird! View Sylvain Amyots profile on LinkedIn
Back to Top
Google visited last this page November 20, 2018, 09:33:43 AM