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!

Register Log in
  • Congratulations bkrike 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: braidj
  • Content: Threads
  • Order by date
  1. braidj

    ADO 2.7 truncation on fields greater than 255 in Sybase

    Hi, using VB6, connecting to a 12.5.0.1 Sybase database and Microsoft ActiveX Data Objects 2.7 Library. When I query a sybase Text field through an ADODB.recordset it returns empty values for that field, despite there being data. I am unable to insert text into that field greater than 255...
  2. braidj

    enumerating through all reprots in a db

    Can't find this in previous posts; how do enumerate through all reports in the current database (both open and closed), all I want are the names ? TIA Jason
  3. braidj

    'Output to' isn't available now...

    Hi, got a macro triggered from a menu, that exports a query to excel. Works fine if a form, any form, is open, but produces the above error message if nothing open. Anyone got any ideas how to get round this ? TIA Jason
  4. braidj

    Browser like navigation for forms, backwards and forwards

    Guys, any tips for best approach for having browser like backwards and forwards functionality for a series of forms. I have a working version but its a bit messy, any one have a really nice succinct approach ? Needs to be driven from custom menubar. TIA Jason
  5. braidj

    Simple SQL generating an error (3075)

    Got a simple piece of SQL to run from VBA DoCmd.RunSQL ("UPDATE tblAccountDetails " _ & "SET Flip_SFA = 'Y' " _ & "FROM tblAccountDetails,tblFlipOnBalance " _ & "WHERE tblAccountDetails.Original_SFA = tblFlipOnBalance.SFA_Category") The sql runs in via...

Part and Inventory Search

Back
Top