chris davies
Registered User.
- Local time
- Today, 17:44
- Joined
- Mar 20, 2005
- Messages
- 86
hello,
could someone tell how to set up a name search on a form plase?
Chris
could someone tell how to set up a name search on a form plase?
Chris
name search
- Thread starter chris davies
- Start date
Search
Check this link:
http://www.access-programmers.co.uk/forums/showthread.php?t=65331&highlight=quicksearch
Check this link:
http://www.access-programmers.co.uk/forums/showthread.php?t=65331&highlight=quicksearch
chris davies
Registered User.
- Local time
- Today, 17:44
- Joined
- Mar 20, 2005
- Messages
- 86
Hi, thanks for the reply, but this isn't what i had in mind. What I'd like is an empty textbox where the user enters a parameter for the search and a command button that triggers the search which then populates the other textboxes on the form. Hope someone can help. Thanks
Chris
Chris
ColinEssex
Old registered user
- Local time
- Today, 17:44
- Joined
- Feb 22, 2002
- Messages
- 9,314
you could use an InputBox or a ComboBox.
A search will find several examples
Col
A search will find several examples
Col
chris davies
Registered User.
- Local time
- Today, 17:44
- Joined
- Mar 20, 2005
- Messages
- 86
The problem I have is not knowing how to set up the search. Any help greatly appreciated.
Chris
Chris
chris davies
Registered User.
- Local time
- Today, 17:44
- Joined
- Mar 20, 2005
- Messages
- 86
Hi,
All I need to know is how to link the textbox and commandbutton on a form, to make a search work on a person's name, which then populates some texboxes on a form. I need to know the VBA behind the action. I can't seem to find the right information on this. all any of my books seem to show is how to make update, amend, delete and normal queries. I know its something to do with using an expression in the search criteria, but I cant seem to find the relevant info.
Chris
All I need to know is how to link the textbox and commandbutton on a form, to make a search work on a person's name, which then populates some texboxes on a form. I need to know the VBA behind the action. I can't seem to find the right information on this. all any of my books seem to show is how to make update, amend, delete and normal queries. I know its something to do with using an expression in the search criteria, but I cant seem to find the relevant info.
Chris
chris davies
Registered User.
- Local time
- Today, 17:44
- Joined
- Mar 20, 2005
- Messages
- 86
Hi,
All I need to know is how to link the textbox and commandbutton on a form, to make a search work on a person's name, which then populates some texboxes on a form. I need to know the VBA behind the action. I can't seem to find the right information on this. all any of my books seem to show is how to make update, amend, delete and normal queries. I know its something to do with using an expression in the search criteria, but I cant seem to find the relevant info.
Chris
All I need to know is how to link the textbox and commandbutton on a form, to make a search work on a person's name, which then populates some texboxes on a form. I need to know the VBA behind the action. I can't seem to find the right information on this. all any of my books seem to show is how to make update, amend, delete and normal queries. I know its something to do with using an expression in the search criteria, but I cant seem to find the relevant info.
Chris
chris davies
Registered User.
- Local time
- Today, 17:44
- Joined
- Mar 20, 2005
- Messages
- 86
HI,
thanks, but not quite what I'm looking for. What I want is to search for a name using a textbox and command button, which results in all records containing the same criteria to be listed. For example, if I search for a surname Jones, I want all the Jones' to be listed. Maybe its a lot harder than I previously thought. thanks for all your help though, it is appreciated.
chris
thanks, but not quite what I'm looking for. What I want is to search for a name using a textbox and command button, which results in all records containing the same criteria to be listed. For example, if I search for a surname Jones, I want all the Jones' to be listed. Maybe its a lot harder than I previously thought. thanks for all your help though, it is appreciated.
chris
Last edited:
