Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - Search in a database from an access page
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Search in a database from an access page

 Post Reply Post Reply
Author
Techniproshop View Drop Down
Newbie
Newbie
Avatar

Joined: 24 April 2007
Location: Canada
Status: Offline
Points: 3
Post Options Post Options   Thanks (0) Thanks(0)   Quote Techniproshop Quote  Post ReplyReply Direct Link To This Post Topic: Search in a database from an access page
    Posted: 29 April 2007 at 7:33am
Hello all.  I went to 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] = '" &amp; document.all.item("SPROJECT").value &amp; "'", 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>
Back to Top
rubia126 View Drop Down
Newbie
Newbie


Joined: 16 May 2007
Location: United States
Status: Offline
Points: 1
Post Options Post Options   Thanks (0) Thanks(0)   Quote rubia126 Quote  Post ReplyReply Direct Link To This Post 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 www.oracelplace.com hope they will help you too
 
good luck
Back to Top
Shaka_Virgo View Drop Down
Newbie
Newbie


Joined: 17 May 2007
Location: Venezuela
Status: Offline
Points: 8
Post Options Post Options   Thanks (0) Thanks(0)   Quote Shaka_Virgo Quote  Post ReplyReply Direct Link To This Post Posted: 17 May 2007 at 9:56pm
TNx
Back to Top
Techniproshop View Drop Down
Newbie
Newbie
Avatar

Joined: 24 April 2007
Location: Canada
Status: Offline
Points: 3
Post Options Post Options   Thanks (0) Thanks(0)   Quote Techniproshop Quote  Post ReplyReply Direct Link To This Post 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>
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.