Filter or Combo to find record in Data Access Pages

B

BillD

I created a Data Access Page to show records from a table. The page shows the
first record with all the fields I wanted. I can click on the 'next arrow' to
get the next record, but I have 12,000 records. How can I search for a name
and then have that name fill the page. I am totally new to Access pages. I
could not get the filter to do anything. The combo box will only allow 2
fields - say ID and Last Name. Then I don't see any way to easily create an
event to fill the page with the persons info. Hope I have explained the
problem properly.
HELP!!!
 
M

[MVP] S.Clark

You may want to repost this in the DataAccessPages newsgroup. The folks who
would know about DAP's may not visit this general, catch-all group.
 
A

aaron.kempf

DATA ACCESS PAGES ROCK!!!!!!!

they are a LOT more fun then I remember them; and Microsoft has
actually DONE SOMETHING with Access-- thank goodness

there are plenty of options for filtering/finding in a combo box-- i
would start with the serverfilter property-- it is basically a 2nd
where clause (without the word where)
 
S

Sylvain Lafontaine

Yes, you can create a filter by using a combobox. There are two methods:
the first one is to collect data from multiple combobox into a cookie (the
easiest way; you can also add them at the end of window.location.href but
it's more complicated) and use parameterized queries for your stuff. More
information at:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k2/html/ODC_acc10_DSCOM.asp

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k/html/programdap.asp

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k2/html/ODC_acc10_DSCOM.asp


If you don't want to dive into this cookie stuff, then here the second
method to filter your form:

First, create a combobox (or dropdownlist) and set its ListRowSource to a
query (recordset) returning the list of the names with their IDs; then set
the ListBoundField to the IDs (primary key) for this list and the
ListDisplayField to the field for the names.

Then, in the GroupLevelProperty, set the GroupFilterControl to this
dropdownlist and the GroupFilterField to the same field as the ID above..

The primary key field for the recordset of the page should also be the same
field. Now, the combobox will server as a filter for the named.

I don't know if you can use this second method with two or more comboboxes.

There is also a newsgroup about DAP: m.p.access.dataaccess.pages . Old
messages can be searched or accessed via Google:
http://groups.google.ca/group/microsoft.public.access.dataaccess.pages
 
B

BillD

Thanks- I can create a combo box based on a query with ID,Last Name,First
Name and Middle Name. I would need to show this info in 1 field as dataaccess
pages will only permit 2 fields in a dropdown list combo. The 1st field would
be ID and the second would be FullName. How do I create this in the
underlying query?
 
S

Sylvain Lafontaine

Easy: use the + operator to properly concatenate the fields:

Select Id, LastName + ', ' + First Name + IsNull (' ' + Middle Name, '') as
FullName, .....
 
Top