corsasport.co.uk
  Not logged in [Login - Register]  
You Are Not Registered Or Not Logged In  

Corsa Sport » Message Board » Off Day » Geek Day » Bit of help please.... (MS Access)


New Topic
New Poll 		  Subscribe | Add to Favourites

You are not logged in and may not post or reply to messages. Please log in or create a new account or mail us about fixing an existing one - register@corsasport.co.uk

There are also many more features available when you are logged in such as private messages, buddy list, location services, post search and more.


Author Bit of help please.... (MS Access)
Haimsey
Premium Member

Avatar

Registered: 8th May 05
Location: Nottingham Drives: Corsa B
User status: Offline
26th Apr 07 at 20:00   View Garage View User's Profile U2U Member Reply With Quote
Im just wondering if its possible and if so how -

Creating a search in a database which will use a text box on a form instead of a query that pops up a box

bit vague i know, but if someone gets me, much appreciated.

Access 2003

Marc

Marcy Marc

White Sport Progress Thread
Haimsey
Premium Member

Avatar

Registered: 8th May 05
Location: Nottingham Drives: Corsa B
User status: Offline
26th Apr 07 at 20:25   View Garage View User's Profile U2U Member Reply With Quote
anyone...?

Marcy Marc

White Sport Progress Thread
James_DT
Member
Registered: 9th Apr 04
Location: Cambridgeshire
User status: Offline
26th Apr 07 at 20:58   View User's Profile U2U Member Reply With Quote
Create a query as normal, and set the where criteria for the field you want to:

code:
Form![Form_Name]![Text_Box_Name]


It might be Forms! and not Form!, I can't remember off the top of my head.
You could use
code:
"*"+Form![Form_Name]![Text_Box_Name]+"*"

to search for any items that contain the text in the textbox rather than match it exactly.

edit: Then just have a button execute that query

[Edited on 26-04-2007 by James_DT]

 
New Topic
New Poll

  Related Threads Author Forum Replies Views Last Post
Windows XP file sharing Dean_H Off Day 4 643
28th Nov 04 at 18:16
by James_DT		  
anyone know for a.. (i.t people) Bart Geek Day 26 2398
5th Apr 05 at 14:41
by Ian		  
my other thread....... Icy Off Day 5 159
17th Jan 06 at 11:36
by Icy		  
Question regarding two wireless access points Steve Geek Day 2 1293
25th Feb 07 at 19:00
by Aj.		  

Corsa Sport » Message Board » Off Day » Geek Day » Bit of help please.... (MS Access) 30 database queries in 0.0195451 seconds