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 Mike Lewis 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: *

  1. LAbluesman

    trouble updating ADODB in VB 6.0..

    haven't heard from me in a while, huh.. well, the problem is still a problem, but it has been narrowed down. It seems to have nothing to do with the UPDATE statement itself. I've found that comes from AMOUNT data types in the database (This is comparable to the DOUBLE datatype in VB6)...
  2. LAbluesman

    trouble updating ADODB in VB 6.0..

    vbkris, could you be a lil' more specific in your suggestion. you say to use [code]"debug.print sql"[\code]. I am not familiar with this command, so, I'm not sure where (or around what code) this should be called. my guess would be to call it right after I call...
  3. LAbluesman

    trouble updating ADODB in VB 6.0..

    Here's the SQL: &quot;Select actlast, actfirst, actmid, actsoc,..<there are about 40 fields>..prtotph from actmem where actsoc = '<someSS#>' and actfirst = '<someFIRST>' and actlast = '<someLAST>'&quot; For the actsoc, actfirst, actlast that come after the WHERE, the SQL must have at least one...
  4. LAbluesman

    trouble updating ADODB in VB 6.0..

    ok, this in &quot;interesting&quot;. I'm trying to do a simple update (ADODB Recordset) in VB6.0. whenever I call the update property, I get an error (see below). now, it's interesting because there are updates in other forms in the project that work just fine, and I'm following those working...
  5. LAbluesman

    ActiveX problem in Visual Basic 6.0

    ok, I've come up with a round-about solution to this lil' turd of a problem. here was the code causing the trouble: Private Sub MDIForm_Load() Set appWord = CreateObject(&quot;Word.Application&quot;) <-------ERROR OCCURS HERE!!!!! appWord.WindowState = wdWindowStateMinimize...
  6. LAbluesman

    ActiveX problem in Visual Basic 6.0

    Well, MS Office is on the machine, with the SR1 and SP2 patches applied. so, lets assume you're right. how would I go about checking to see if Word ~is~ correctly registered?, and then, if it is not, how to register it. an additional note : We've uninstalled and reinstalled Visual Studio 6.0...
  7. LAbluesman

    ActiveX problem in Visual Basic 6.0

    here's the deal : we're developing a Visual Basic 6.0 application that uses MS Word 2000 and Excel 2000 in the background. This is not the problem. the application was working just fine about a week ago (microsoft app working just fine???, oh my god!!!). a week ago we saved everything from...
  8. LAbluesman

    connect to Linux DB using windows VB?

    I'm sure you were looking to move your MS VBasic stuff to the Unix KBasic. The only other option that comes to mind is using Glade for Linux (Red Had 7.2). This is a GUI development Env. This may not be much help, but, just thought I'd let u know of another option.
  9. LAbluesman

    THE BEST VISUAL BASIC BOOK

    Hey, If you are looking for the 'general and beginner's stuff' of VB, I'd recommend this... &quot;Visual Basic 6: How to Program,.. by Deitel&Deitel&quot;. It's a big yellow book. These guys(or gals, I don't know:) do a good job in explaining what they do and providing lots of code to look at...
  10. LAbluesman

    connecting VB 6.0 to a Unify/Accell DB using ODBC

    hey all, here's the skinny: I am trying to make a GUI front end for a Unify/Accell DB. However, I am having no luck in figuring out HOW the connection will be made. Every book out there says plenty about Access, but that's it. I'm hitting questions like, &quot;well, I can point-&-click to...

Part and Inventory Search

Back
Top