Recordcount Confusion

Results 1 to 2 of 2

Thread: Recordcount Confusion

  1. #1
    Join Date
    Dec 1969

    Default Recordcount Confusion

    I&#039m doing a search of a database and I&#039m displaying the results ten at a time, search engine style. Next 10 and previous 10 buttons are showing up as and where they should, based on a simple counter. The part I&#039m struggling with is that I&#039m wanting to do a recordcount so that I can display the total number of records at the top. One of my books tells me that if the value shows up as -1 then the object is not supported and I should set a cursor type. When I set Recordset.Cursortype = adOpenStatic I get the error: "The operation requested by the application is not allowed if the object is open" Similarly one of the books mentions in passing "note the lack of a connection (in the example)" What gives?

  2. #2
    Join Date
    Dec 1969
    Los Angeles, CA

    Default RE: Recordcount Confusion

    I dont think so if you get that error you are trying to open the object AGAIN without closing it

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts