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
|
|||
|
|||
SEARCH ROUTINE
I have a form that allows add/edit /view ENTRIES. The record source of my
form is the master_table (not a query) that contains all the ENTRIES. I used the record navigation functions of ACCESS (prev record, next rec, add rec, find a record and so on..) I am new to ACCESS and no experience in VB coding. Now that my master_table is getting bigger, I understand it will be faster if I have a SEARCH routine that queries only a record or a set of records instead of fetching all records of the master_table by using the FIND function of access. Is there a template/sample code/approach for a SEARCH routine that I can start on , that will allow my users to search for the LAST NAME of a member and displays the member info on the form. This way it will only fetch that record instead of retrieving all the records of the master_table which my form is currently doing. Thanks in advance for your help. |
#2
|
|||
|
|||
SEARCH ROUTINE
as long as Last Name is a field in a table you can do a query. Or a filter
by selection this is on the table's toolbar. Click it and then in last name to search for all that begin with s type in S* Note that you can't save a filter as easily as a query. if it is one to be used over and over then a query would better suit you. "Tarlac" wrote: I have a form that allows add/edit /view ENTRIES. The record source of my form is the master_table (not a query) that contains all the ENTRIES. I used the record navigation functions of ACCESS (prev record, next rec, add rec, find a record and so on..) I am new to ACCESS and no experience in VB coding. Now that my master_table is getting bigger, I understand it will be faster if I have a SEARCH routine that queries only a record or a set of records instead of fetching all records of the master_table by using the FIND function of access. Is there a template/sample code/approach for a SEARCH routine that I can start on , that will allow my users to search for the LAST NAME of a member and displays the member info on the form. This way it will only fetch that record instead of retrieving all the records of the master_table which my form is currently doing. Thanks in advance for your help. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Feature request - better search abilities | Boe | General Discussion | 19 | November 29th, 2005 02:33 PM |
Help performing a search | Someone | General Discussion | 14 | November 21st, 2005 10:22 AM |
Visible Property | Ben | General Discussion | 4 | September 14th, 2005 08:22 PM |
search more than 1 fields | spacerocket | Using Forms | 3 | August 28th, 2005 08:00 AM |
Search fields in form | spacerocket | Using Forms | 0 | August 25th, 2005 10:25 AM |