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 Wanet Telecoms Ltd 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: DanMan1
  • Content: Threads
  • Order by date
  1. DanMan1

    Excel ODBC Direct Connection to SQL Recordset

    Hi, I'm trying to connect to an SQl recordset and update some columns I can connect to the server and return a recordset but I can't update it as its read only any ideas on how to get it read write? Heres my code: To connect: Set wrkODBC = CreateWorkspace("NewODBCWorkspace", "admin", ""...
  2. DanMan1

    CMS ODBC Query

    Hi, Could nayone help. I'm trying to query our sever for data based on a date/range but I cannot get it to work I get an ODBC call failed which usually means the SQL is wrong. I know the date should be the number of days since 31/12/1899 date-1 = 38593. Can anyone help?? Code attached. Dim...
  3. DanMan1

    Check Workbooks Open

    Hi, Would any know a way to check how many workbooks are open in an excel session?? Any help would be appreciated. Cheers Dan

Part and Inventory Search

Back
Top