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)...
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...
Here's the SQL:
"Select actlast, actfirst, actmid, actsoc,..<there are about 40 fields>..prtotph from actmem where actsoc = '<someSS#>' and actfirst = '<someFIRST>' and actlast = '<someLAST>'"
For the actsoc, actfirst, actlast that come after the WHERE, the SQL must have at least one...
ok, this in "interesting". 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...
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("Word.Application") <-------ERROR OCCURS HERE!!!!!
appWord.WindowState = wdWindowStateMinimize...
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...
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...
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.
Hey,
If you are looking for the 'general and beginner's stuff' of VB, I'd recommend this...
"Visual Basic 6: How to Program,.. by Deitel&Deitel". 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...
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, "well, I can point-&-click to...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.