Type: Posts; User: Schmidt
Search took 0.03 seconds.
Don't misunderstand Recordsets as "Table-Representations only" - I mean they can be,
but "a Table" is just a special (very simple) Form of "a Set".
SQL is the language to express and define...
The VB6-way to handle that is (as was already suggested) per "ByRef-Variant-Param",
followed by an internal TypeCheck of the Variant in the Function-Body itself...:
Since it already came out quite clearly, that the feature is not available "across the board"
of ADO-OleDB-Drivers, why not implement it yourself in a small Class - and with broader
If you didn't change any of the TestFilter-settings - and left the entries in the CompareList
as they were in my posted example, then the scan filters for "typical VB-Files first" -
The Results are gathered in a cCollection (which is by default instantiated with its
Property .CompatibleToVBCollection = True)
So you can enumerate per For Each - as well as per OneBased Index...
Erm, what about using:
instead of your MsgBox?
For Each Idx In IdxCollection
Debug.Print "Lines with 'G4': "; ProgArray(Idx)
E.g. vbRichClient5 contains such Classes
An unicode-aware solution for the whole problem could be written up this way:
Private Sub Form_Load()
'simply put the Filenames *without*...
Whilst your ScreenShots above deliver some background-info - what we are more interested in
is your current DB-layout - as already requested a few postings further above:
"... you should describe...
I already gave you help to the best of my knowledge - by encouraging you,
to "try yourself in some other area - seeking another challenge".
Coming up with a decent Virus-Scanner is "out of reach...
That would not be sufficient in case of e.g.:
or *.dll or *.ocx binaries, as e.g. msvcr71.dll,
which often are directly hosted in some Apps Resource- or Bin-Folders.
There's Directory-ListClasses which support multiple wildcard-containing filters -
and the fully qualified filenames (without wildcards) could be matched against a
Hash-List (e.g. a VB.Collection...
I cannot make head or tail from what this app shall accomplish when it's finished at some point.
In your post #42 you write that you will scan all Files and Folders on a drive - and compare
Sorry, but that is not true - everything that was said would help you, if only you'd be willing to invest some time...
And what you wrote in your post #3:
comes across quite impatient - aside...
Oops, sorry - corrected now in original Post #4.
I'd recommend to use ADO instead of DAO when dealing with MDBs (simply more examples).
Have a look at the two simple Demos below - they include a small Helper-Module,
which makes it easy to deal...
Yep - for example the info, if there's an error-message which is thrown, before the IDE "gets down"... ;)
In case it really is "a silent exit" - then you made perhaps a mistake in the...
A full implementation which doesn't use any DoEvents (instead favouring Timers)
is shown below - Ok - and a Start/Stop-Button is also contained, as well as a
slider which you can use to adjust the...
Although it doesn't really make a difference, if you access a self-defined Public-Property of
a certain Form-Class - or a selfdefined TextBox on that same Form-Class - both require
that you use a...
If you encapsulate a bit (in modules, classes and usercontrols) then it's "getting messy more slowly". ;-)
Others mentioned it already - a TrayIcon might just be what you need (able to popup...
Your code-adaptions look good - you adapted the Field-Type from Date to String already -
so everything should work as before in the other example - and after testing it here - it *does*.
Try to remove the MSADO26.tlb from your Setup - it is not needed.
Also the vbRuntime itself (msvbvm60.dll) does not need to be included in the Setup.
As for the "File already exists" error -...
...nothing wrong with a single, direct Jump-instruction here -
the two 'Exit For' Jump-instructions (combined with an additional If-check)
really do look a bit "clumsy" in comparison......
Hopefully you didn't include any of the ADO-libraries, since they come already
preinstalled on any Win-OS.
Was there no error-message - and in case there was - what did it say?
Just a small Update to the version above, now demonstrating also the Filter-capabilities
of the Recordset which are useful in this small Demo, to e.g. filter out "ToDo-Dates of the past"
You did, but thereby ignored the results I've already posted further above (same checksums in
repetitive runs over multiple PreMultiply-UnPremultiply-steps).
So the "naive integer formulas" you...
Have to agree with Tanner on the premultiplication-part, since I cannot reproduce what you describe in a small test I just wrote:
Here's a PNG to download (used within my Demo-Source - the file...
The IsDate()-Function I've choosen works "localized" (country-specific).
And the date in the "new-Date"-TextBox as you see it on my screenshot,
is how we notice dates here in germany ...
IMO in your scenario you don't need a "list comparison" - and I also don't see why everybody
seems so eager, to save "multi-attribute-data" in a plain-text-file with VBs old-fashioned ANSI-FileOps....
If you want to avoid (in a huge Std-Exe-Project) longer compile-times, then you have two options:
1) Compile your entire Project to PCode (the native C-Compiler takes quite a bit longer)
My problem is, that you didn't tell us if you plan to use the RC5-lib I recommended
for all your Unicode-File-stuff - or if you are in search of an "API-solution".
And here's another problem,...
As long as the ByteArray-Blobs fit into memory in a single allocation - you could do that.
This usually makes no problems with PDF-Blobs (which are typically below 10-20MB)-
but could make ...
The use of VBs Len-Function is Ok in this case, since it reflects "properly typed Variables" correctly - with
regards to the inherent Byte-Length of their type (independent of the Content which is...
Whatever you want to put into the Data(Source)-Parameter which comes in per OleStartDrag-Event
(StdPictures, Plain-Text, RTF-Text, FileNames/Paths, your own Bytearrays etc.)...
That's true - and although it would have been nice to have a fix for this particular problem (to avoid
copying of private *.ctl-Files from a "leading source") - *when* it happens to you, it might...
It was not "feeling like arguing" - it was just a correction to your blanket statement where you said that you:
Because that's just misleading info for community-members who consider to use...
And so what?
User-controls are basically the same thing as normal VB-Classes (just having additional "visual behaviours").
And in the same way as with normal VB-Classes - there can be...
Still wondering about the "why trying something like that?"-question.
Was it only for educational purposes - or did you try to solve a real practical problem?
(from your OP that seemed to be the...
Nah - there's dozens of scenarios where UserControls which contain additional Controls make perfect sense.
And I also don't see, where the "additional dependencies" would come from (e.g. when you...
You mean a Control which puts out something like this here?:
Well - for simpler Controls like this, it is often faster to write one from scratch...
The cDirList-Class is part of vbRichClient5.dll (a free Binary which needs to be downloaded and registered first).
As for *.vbgs being "much easier" - that may be true when you still debug things in...
Click Here to Expand Forum to Full Width
Survey posted by VBForums.