:: Your Computer Technical Resource Headquarters! :: Your Computer Technical Resource Headquarters!
Computer Support Forums arrow Software Support arrow Database Problems arrow Topic: MSAccess Wildcard Query
June 14, 2021, 09:19:00 PM

Home Forum Rules Help Search Mobile Version Login Register

Welcome, Guest. Please login or register.
Did you miss your activation email?
June 14, 2021, 09:19:00 PM

Login with username, password and session length
 Featured Sites:
12th Anniversary Celebrating 12 Years! (1997 - 2009) 12th Anniversary
Thanks to ALL that make this site what it is!
  0 Members and 1 Guest are viewing this topic.
Pages: [1] Go Down Print
Author Topic: MSAccess Wildcard Query  (Read 4703 times)
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?

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!

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 October 10, 2019, 04:58:14 AM