Recent content by desastrux

  1. D

    Displaying an ADO Recordset in Immediate Window

    I actually think i figured it out. But im not at home so i cant test it lol
  2. D

    Displaying an ADO Recordset in Immediate Window

    Nope, gets the same error as all the others Error 3001: Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another. Basically I can't use the Year or DatePart functions in the filter. But then I don't know how I could do it, since I have to filter for...
  3. D

    Displaying an ADO Recordset in Immediate Window

    I have tried that too, I have tried just about any and every combination of things I could think of. Just have no idea what to try now.
  4. D

    Displaying an ADO Recordset in Immediate Window

    I have gotten the display in immediate window to work now. The only thing I still haven't been able to do is get the filter to work properly. i tried to do this but it doesnt work rst.Filter = "pubdate like '*yearPublished'" I somehow need to get just the year portion of pubdate. I have tried...
  5. D

    Displaying an ADO Recordset in Immediate Window

    well i know that i would use debug.print. but how do i use debug.print to print the recordset? and how would i concatenate the filter string? I am putting a year in the main driver as a parameter, and the filter will return all books that have the same year in the published date. Actually i...
  6. D

    Displaying an ADO Recordset in Immediate Window

    Hey everyone, I am stuck on this whole ADO thing. We never used it in class and now I have to use it in my final project. I have the entire project done, except for the last little part, which I can't figure out. Public Function ADO_ListBooksPublishedYear(yearPublished As Integer) Dim rst...
Back
Top Bottom