Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Rowset does not support scrolling backward.

Posted on 2008-09-29
2
209 Views
Last Modified: 2013-11-28
I have Access front end and a SQL backend.
I have DAO code that I'm trying to change to ADO code.  
I have the attached code snippet and I'm betting the error...
     Rowset does not support scrolling backward.
Is that because my syntax is still wrong?
Thanks

Set rs1 = New ADODB.Recordset
    cn.Open "Provider=SQLNCLI;Server=10.0.0.10\SQLExpress;Database=FDThomasQC;Trusted_Connection=yes;"
    rs1.Open "SELECT WorkReleaseID FROM tblWorkRelease WHERE WorkReleaseID = " & cboReleaseNo, cn
    rs1.MoveFirst
    rs1.Find "[WorkReleaseId] = " & cboReleaseNo.Value  'GET ERROR HERE

Open in new window

0
Comment
Question by:BobRosas
2 Comments
 
LVL 32

Accepted Solution

by:
Daniel Wilson earned 125 total points
ID: 22605035
http://www.w3schools.com/ADO/met_rs_open.asp
rs1.Open "SELECT WorkReleaseID FROM tblWorkRelease WHERE WorkReleaseID = " & cboReleaseNo, cn, adOpenKeyset
   
0
 

Author Closing Comment

by:BobRosas
ID: 31501577
That worked.  Thanks!
Also thanks for the link.  Lots of useful info.
0

Featured Post

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes how to use the timestamp of existing data in a database to allow Tableau to calculate the prior work day instead of relying on case statements or if statements to calculate the days of the week.
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question