If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Need to create a Search Dialog box
I'm trying to design a search button for a form that I have a lot of records
entered into and need to be able to select one record from the middle of the record set without having to click on the next button at the bottom of the form. I want to be able to continue to enter data without having to add a save records button so I think I need a type of search dialog box - am I heading in the right direction. If yes, I'll be able to do this for a couple of forms. Any ideas? Thanks! |
#2
|
|||
|
|||
The easiest way to do this is to just give the users access (pardon the pun)
to the standard access "Find" command on the toolbar (the little binoculars) and on the menubar (Edit|Find). The user clicks in the field of the form that they want to search and then clicks on the "Find" command. This brings up the standard Access record search set to search within that field. The user then enters the vallue they want to search for, clicks "find next" and it positions the form to the first record with that value in that field. The standard Find gives the user the option of looking for the value as the "Whole Field", the "Start of Field", or "Any Part of Field". It also gives them the option of looking through all fields of all records (instead of just the selected field), and they can also match case if that's needed. If you want to do something else, you have to write some sql behind your search button. It's certainly very doable, but it's a lot easier to use the standard "Find Command" If you want info on how to set up a custom toolbar or menubar for a form just say so and someone can help you with that. "DebbiB" wrote in message ... I'm trying to design a search button for a form that I have a lot of records entered into and need to be able to select one record from the middle of the record set without having to click on the next button at the bottom of the form. I want to be able to continue to enter data without having to add a save records button so I think I need a type of search dialog box - am I heading in the right direction. If yes, I'll be able to do this for a couple of forms. Any ideas? Thanks! |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How do I create a SEARCH in Access? | Crazy Canadian | Using Forms | 1 | September 5th, 2004 03:49 AM |
Search Function | Matthew DeAngelis | General Discussion | 0 | July 21st, 2004 06:05 PM |
SQL Search Query | Jamie Bray | Running & Setting Up Queries | 1 | June 10th, 2004 12:36 PM |
Can I create a search engine? | Scott | Using Forms | 1 | June 3rd, 2004 04:56 PM |