Search in a database from an access page
Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=23210
Printed Date: 28 March 2026 at 9:02am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Search in a database from an access page
Posted By: Techniproshop
Subject: Search in a database from an access page
Date Posted: 29 April 2007 at 7:33am
|
Hello all. I went to http://support.microsoft.com/?kbid=247823 - http://support.microsoft.com/?kbid=247823 and found the info for my needs but it's not working. This is for Microsoft Access 2000 Standard Edition and I use Professional Edition. I don't know if that could be the problem. I made a data access page linked to my database. I added a drop-down-list and want to select specific record (project number)I have this code for my drop-down-list in my access page. The drop-down-list name is "SPROJECT" and the field that I need to search is "PROJECT NO" wich is a text field. When I choose a project number from the drop-down-list, the page doesn't go to the project I choosed. Any idea? <SCRIPT language=vbscript event=onafterupdate for=SPROJECT> <!-- Dim rs Set rs = MSODSC.DefaultRecordset rs.Find "[PROJECT NO] = '" & document.all.item("SPROJECT").value & "'", 0, 1, 1 '0 = Skip zero records before starting the search. '1 = Search in a forward direction. '1 = Always begin the search with the first record in the recordset. --> </SCRIPT> ------------- Ghislain |
Replies:
Posted By: rubia126
Date Posted: 16 May 2007 at 10:19am
|
well i guess u need a proper oracle consultant ...few days ago i was having same sort of issues with my database administartion i cotact http://www.oracelplace.com - www.oracelplace.com hope they will help you too
good luck
|
Posted By: Shaka_Virgo
Date Posted: 17 May 2007 at 9:56pm
|
TNx ------------- 
|
Posted By: Techniproshop
Date Posted: 18 May 2007 at 9:24am
|
I found the problem, I had a typo in the script because I used copy and paste from the website. The code is working now.
<SCRIPT language=vbscript event=onafterupdate for=SPROJECT> <!-- Dim rs Set rs = MSODSC.DefaultRecordset rs.Find "[PROJECT NO] = '" & document.all.item("SPROJECT").value & "'", 0, 1, 1 '0 = Skip zero records before starting the search. '1 = Search in a forward direction. '1 = Always begin the search with the first record in the recordset. --> </SCRIPT> ------------- Ghislain |