Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by richdb

  1. richdb

    Can't Close SQL Connection

    That's ok, I figured it out myself. I placed a session.timeout = 1 at the beginning of the ASP file.
  2. richdb

    Repeated login

    Make sure that your subreports used the same ODBC DSN name as your other subreports. If you have the same record filters for every sub-report, make sure that you name your parameters the same way also. Hope this helps.
  3. richdb

    Grouping eliminating selection records

    Why not create a Group based on formula where your formula clearly specifies the group you want to see OR create a Record selection formula limiting your Memo field with a specific criteria.
  4. richdb

    Repeated login

    go to http://www.tek-tips.com/gfaqs.cfm/lev2/4/lev3/100/spid/149/sfid/539
  5. richdb

    Using CSTR

    If you want to replace it with something else, write an IF..THEN..ELSE condition. If RIGHT(formula,"00:00") then mid(formula,1,len(formula)-5) & "12 AM" NOTE:where 5 is equal to the number of characters in "00:00"
  6. richdb

    Can't Close SQL Connection

    After making a successful connection using SetLogonInfo in an ASP page and previewing my report through the viewer in my IE6 Browser, closing the browser will not close the connection in SQL Server. I've set all my objects to nothing and abandoned all session variables but will not release the...

Part and Inventory Search

Back
Top