Recent content by Doteco

Thanks Strongm, I also discovered that it could be acheived using the DSOFile.dll With the following declaration:- Private m_oDocumentProps As DSOFile.OleDocumentProperties and then this code... Public Function GetPropTitle(sFile As String) As String Dim oSummProps As...

When you hover the mouse over a file a "tool tip" listing:- Type: Title: - (but only if a title has been given to the file.) Date Modified: & Size: ... is displayed. Is there any way in VB6 to get the "Title" component of this information - as opposed to the "name" of the file...

Hi Jefftopia, just did a search on VB, CR and parameters and found your post of 30 jul 02 where you answered your own question - it helped me too and fixed my problem - so a big "thank you" for taking the time back then to post the solution. Regards, Doug.

No I didn't have - but have now and it's working fine. Missed the bleeding obvious looking for something complex. Thanks for taking the time to post your reply. Regards, Doug.

I've never used "StdPicture" before and am getting an error "User defined type not defined" on a line: Public pic as StdPicture I must be missing something but can't work out what. Could someone tell me what I need to do. Thanks in anticipation. Doug.

Got it working now - the table had a date field and some of the records I saved the date as '0000-00-00' both through code from VB or by setting that as the default in MySQL (& VB sending nothing for that field). Turned out the error was generated whenever it tried to delete a record with...

Hi, I'm working on an app - VB6 front end & MySQL backend - have a routine to delete all the records in selected tables. Works fine on all tables bar one in which it deletes the first record then does a recset.movenext and in the attempt to delete the next record throws up the following...

Yes, I can see how that would work... thanks again. Doug.

Thanks SonOfEmidec1100 - you were right but I didn't discover your post until I'd submitted my second one (we must have been replying at the same time) - though I did discover that "Resume" after "SkipIt:" just kept "Resuming" itself and the code would hang - whereas "ResumeNext" did the trick...

Just worked it out !! For those who are interested... "the on error goto oops" took me to the error handler outside of the loop - then if it was a particular type of error, control was sent back into the loop (just before the "next i" bit) to a label called "SkipIt:" - by putting "Resume...

I have a loop (looping through records in a recordset) which has an "on error goto..." statement (in the loop) that deals with the error by skipping that record and moving on to the next... works OK for the first error that it comes accross but next time around it throws up an error message and...

Thanks Matt, Since my initial post I have discovered ntsvc.ocx - the one that I assume you are referring to - and using it has enabled me to list a program in the services.msc file which then runs as a service at boot-up. Thanks again for your reply, Doug.

I need to add an entry into the "services.msc" file (via code) and assume that this can be done through an API call. Does anybody know the API or, if it's not by API then how do I do it ? Using XP. Thanks, Doug. "A nose by any other name still smells the same."

Thanks - had a quick look at it and will give it a go. Appreciate your help. Doug

I'm using XP but the final application may need to be compatible with Win98, ME etc. If I can get it working on XP for starters that'd be good. Yes, I only need it to find local users on a standalone PC. Thanks, Doug.