By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,587 Members | 1,020 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,587 IT Pros & Developers. It's quick & easy.

Search button in access form

P: 1
I am a beginner with Microsoft Access databases. Is is possible someone could help me with how I would place VB code behind a search button?

Im developing database, i want to add Search button to search in multiple table field.


Thanx in advance.
Nov 11 '12 #1
Share this Question
Share on Google+
3 Replies


NeoPa
Expert Mod 15k+
P: 31,485
This is very vague, but you may find Example Filtering on a Form of some help.

If not, then please consider asking your question properly as explained in the rules and the various threads which deal with asking questions in a way we can respond to.
Nov 11 '12 #2

zmbd
Expert Mod 5K+
P: 5,397
hessah,

What you've asked for could fill a small website and there are several out there (including MSN) that have detailed step by step instructions to get you in the right direction.

The basic steps that I use when starting a new form based on a record search are:

Start with the query builder
Use this to develop the select query to return a set of records that you might typically search. I don't bother about how to search on everything the user might want, just a typical search.
Once the records returned are correct. You can do one of two things at this point.
You can use a form to provide parameters for the query
or you can switch to SQL view and use the SQL listing as a basis to build your own in VBA.

That is the generic version.
Nov 11 '12 #3

NeoPa
Expert Mod 15k+
P: 31,485
Zmbd:
NeoPa... I've got to start typing shorter replies ;-)
Maybe Z, but you give good value for your post-count. That's for sure.
Nov 11 '12 #4

Post your reply

Sign in to post your reply or Sign up for a free account.