Search button on a Data Page

mzeigler

New Member
Joined
Nov 22, 2005
Messages
1
I have the database and the Data page, but how do I add a search button to the data page to search the database by a certain field? Any help would be appreciated. I would be happy to send you the files if you give me a contact.
 

SydneyGeek

MrExcel MVP
Joined
Aug 5, 2003
Messages
12,251
There's a quick way to get started. You can make it more sophisticated later if you wish.

You will need:
A form based on a table or query
A button to do the search. We'll use a wizard for this.

OK, if your data is already in a form, you can use that. Otherwise, you can create a form by doing the following:
1. Select the table or query that you want to use as the data source for the form.
2. At the right end of the toolbar is a datasheet icon with a lightning bolt on it. When you move your mouse over it, it will say Autoform - Columnar. Click this button. You now have a form with all the fields from the table. Not pretty but it works.
3. Save this form. When prompted for a name, it will suggest the name of the table or query that you used. Put frm at the front of this name: it helps you later to tell whether you're working with the table directly, or the form based on the table.
4. Now go into Design view in the form. On the View menu, choose Form Header / Footer. You will now have a blank section at the top of the form.
5. Click on the Toolbox button to display the toolbox, and click the wand icon to make sure the Wizards are activated. Now, drag a Command Button onto the header section of the form and let go. The Wizard will launch. The dialog asks you what category to choose from. Click Record Navigation, select Find Record from the second pane, and click Next. Now you will be asked to choose a caption or image for the button. PIck what you want, click Next and Next or Finish again.
6. Save the form and go into Data view. When you click the button, you'll get the Find dialog. It will look in whatever field you currently have selected.

Lots of words but I couldn't easily insert screenshots. Hope this helps.

Denis
 

slipstream

Board Regular
Joined
Aug 24, 2005
Messages
61
If you add a control button to a data access page you do not get the option to "Find Record" in the wizard, this only works on a form, either that or i'm doing something wrong :confused:

I'd be interested if it could be done simply on a data access page if anybody knows, thanks :)
 

Forum statistics

Threads
1,078,249
Messages
5,339,077
Members
399,276
Latest member
Donjayok

Some videos you may like

This Week's Hot Topics

Top