Wrox Programmer Forums
Javascript How-To Ask your "How do I do this with Javascript?" questions here.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Javascript How-To section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old March 20th, 2006, 09:46 PM
Registered User
Join Date: Mar 2006
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Data access page

Hallo! My English is not so good, but I hope you will understand me! I am working with a data access page in Access. In this page I have two dropdown list boxes and a search button. The idea with this page is to select two years in the two list boxes and when one press the search button the records which matches against the two years will be shown in the page. The table is called "Events" and the two fields "Year_1" and "Year_2". My goal is to create this with just Jscript or VBScript, but I dont know how to do, so I hope someone wants to help me.
Old March 21st, 2006, 07:15 AM
Friend of Wrox
Join Date: Oct 2004
Posts: 553
Thanks: 0
Thanked 1 Time in 1 Post
Send a message via MSN to vinod_yadav1919 Send a message via Yahoo to vinod_yadav1919

You can query the "Events" table with given condition

sql="select * from Events where Year_1='"&tempyear1&"' and Year_2='"&tempyear2&"'"
set rs=conn.execute(sql)

when search button is clicked get the values from dropdownlist.
hope this will help you

Cheers :)


Similar Threads
Thread Thread Starter Forum Replies Last Post
MS Access: Data Access Page sevp95 Access VBA 0 July 14th, 2008 11:07 AM
access data from another page rocksbhavesh ASP.NET 1.0 and 1.1 Professional 5 March 26th, 2007 08:18 AM
Data Access Page Problem please help! jdbash1 Access 0 June 5th, 2006 02:16 PM
Data Access Page Teqlump Access 9 November 1st, 2004 11:36 PM
Data access page access problem :) kev_79 Access 0 September 4th, 2003 04:02 PM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.