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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Rungo
  • Order by date
  1. Rungo

    Remove MsgBox "...opened read-only..." at startup?

    I have the Access 2000 versions of the Developers' Handbooks (Getz*Litwin*Gilbert), and don't understand how I survived all these years without them.
  2. Rungo

    Convert SQL binary Timestamp to Access Date/Time

    Thank you, this is very informative. Given that this TimeStamp field is not bound to the system date and time, do you know of any other field used by SQL that would actually store the date and time that a record is added or changed?
  3. Rungo

    Convert SQL binary Timestamp to Access Date/Time

    Does anyone know how to convert a binary timestamp from SQL Server into something Access can understand and report on? A binary field in an Access table looks empty, like it's coming from a different universe. How can I convert this to the usual mm/dd/yyyy stuff we all know? - Ken
  4. Rungo

    Continue line of code on next line

    What I would have done is create a String variable called strSQL. Next, I would've said something like: strSQL = strSQL & "(First 60 characters of the SQL code)" strSQL = strSQL & "(next 60 characters") etc. I'd follow this up at the end with strSQL.execute Ken
  5. Rungo

    Change screen resolution from Access?

    Thanks for the ToggleScreenSize() function. it undeniably 'works', but at the cost of resetting the screen refresh rate to 60Hz. Obviously, this results in a heavy black border around everything. It's not a workable solution, since asking the user to change her/his refresh rate is even a...
  6. Rungo

    msoutl9.olb : Is there a newer version for XP?

    I am trying to run an Access2000 database in XP, but continually am told that there's a missing or broken reference to msoutl9.olb. This .DLL is used in Access2000 to connect Access to Outlook. Do you know of any update to this program? I am wanting to run the AccessXP code under CITRIX.

Part and Inventory Search

Back
Top