Query saved as data access page.Customising the parameters

Query saved as data access page.Customising the parameters

Post by SimpleTech » Sat, 24 Jul 2004 01:35:24


I have saved a query as a data access page. The parameters
to be filled are Name, Start Date and End Date. This is
tedious coz it has to be typed in manually.

My question: Can I have a list of names(menu kind) and 2
calendars for the users to select quickly??


Please suggest.
Thank you.
 
 
 

1. Customizing Parameters to data access page

2. Data Access Page from parameter Query

I need to link a parameter field on a html Data Access Page (created in
Access 2002) to a sql Query. Or maybe a filter, but prefer to execute the
filter/query before it looks up the data from the server. In a nutshell, i
want a user to enter a date at the top of the web page to limit the last date
of a query than show the retrieved records. Then either a GO button or hit
enter to send the thing into orbit. So if someone types 18 Jun 05, it will
show all records up to and including that date.

I can make a parameter query that will fire a pop-up parameter form, but i
think others in the company will be confused or balk at using this web Data
Access Page ( the MS form looks *** ). Can someone point me in the right
direction, or give me a good website for this info.

any help is much appreciated!!
--
humanoid/earthling

3. query parameter on data access page

4. Table field parameters not reflected in Data Access Page, Query, Report, etc.

5. Table field parameters not reflected in Data Access Page, Query, R

6. Query stops working on Data Access Page after adding a parameter.

7. Customizing Data View Query Based on Parameters

8. Save data retreived from query without saving query

9. saving database with forms as Data Access Page, or, Active Server Page with functioning code?

10. saved parameter query with MS Access....will it work in asp.net too?

11. Multi-Table Query/Data Access Page--can't edit data

12. Data Access Page - cannot see data until I save

13. MS Access d/b saved parameter query problem

14. change access form to a data access page-but no save-as option

15. Date Parameter For Saved Parameter Queries