Filter or Combo to find record in Data Access Pages

Filter or Combo to find record in Data Access Pages

Post by QmlsbE » Wed, 22 Jun 2005 20:54:02


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!!!
 
 
 

Filter or Combo to find record in Data Access Pages

Post by [MVP] S.Cl » Thu, 23 Jun 2005 04:03:34

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.

--
Steve Clark, Access MVP
FMS, Inc.
www.fmsinc.com/consulting

 
 
 

Filter or Combo to find record in Data Access Pages

Post by QmlsbE » Thu, 23 Jun 2005 08:08:13

Where is the data accesspage newsgroup?
Thanks- Billy D.
 
 
 

Filter or Combo to find record in Data Access Pages

Post by aaron.kemp » Thu, 23 Jun 2005 15:08:51

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)
 
 
 

Filter or Combo to find record in Data Access Pages

Post by QmlsbE » Fri, 24 Jun 2005 01:36:11

Is there a data access pages newsgroup? Does anyone know the web address.
 
 
 

Filter or Combo to find record in Data Access Pages

Post by aaron.kemp » Fri, 24 Jun 2005 07:13:57

I think that this should work
microsoft.public.access.dataaccess.pages
 
 
 

Filter or Combo to find record in Data Access Pages

Post by QmlsbE » Fri, 24 Jun 2005 22:26:03

Thanks, I will try out the site you suggested.
 
 
 

Filter or Combo to find record in Data Access Pages

Post by Sylvain La » Sat, 25 Jun 2005 08:56:59

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://www.yqcomputer.com/

http://www.yqcomputer.com/

http://www.yqcomputer.com/


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://www.yqcomputer.com/

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://www.yqcomputer.com/
 
 
 

Filter or Combo to find record in Data Access Pages

Post by QmlsbE » Sun, 26 Jun 2005 08:12:01

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?
 
 
 

Filter or Combo to find record in Data Access Pages

Post by Sylvain La » Sun, 26 Jun 2005 08:28:05

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

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

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://cerbermail.com/?QugbLEWINF


"BillD" < XXXX@XXXXX.COM > wrote in message
news: XXXX@XXXXX.COM ...