Search:

Okay,

I have found that the Access 2003 events are not available for automation. I know for start up you can use an AutoExec Macro, I'll just have to see if there are any other macros out there...

Okay,

So this is a VBA question, not technically 6.0 but similar enough. I am working on an Access 2003 Database and would like to have access to the Application events. In other Office 2003...

***Possible Solution***

I have added DoEvents Commands to my file read loop and it seems to be working. Will know for sure tomorrow morning.

I have a simple application that reads a large text file (290,000) lines, and for each line reorganizes the data into a set of objects. These objects are then written to an output file of about 4,000...

Thanx wizbang, that is very helpful. Yeah, actually passing an array would be probably more effective. The calling procedure would look like this


Dim strFilePaths(3) as String
Dim strFindString...

WizBang -

Yeah, I forgot if ParamArrays could be declared a specific data type or just variant. I don't use ParamArrays that often, but felt one would be appropriate for this purpose. And I had...

I like the line by line check with a break as well.

Something Like this?


Public Function SearchFiles(ByVal SearchString as String, ParamArray _
FilePaths() as Variant) as Variant

Dim strFilePathsWithString() as String
Dim intCounter as...

Sorry dglienna, I just found out what the technique is called today. Had I known I would not have posted a thread; and since the thread was already started, I thought I would mention that I found the...

The base class needs to modify system wide globally unique data. If there is a better way to do that, then I would love to hear it. This has been frustrating beyond all end.

Okay, apparently I am trying to create a Singleton Object. After doing some research, I have ordered a book "Advanced Visual Basic 6" and will post if the solutions work.

If anyone has any...

ah, I used fso completely for my test, opening the file and copying it. That must have been why it was able to copy while the file was open.

DataMiser, That is so clever. Don't know if I'd have the know how to implement that...but nicely done. Sounds like it would work. Actually after reading that again...I think I could do it.

If you are using the Scripting.FileSystemObject, you can always take a copy of the file...run your tests on the copy and then recopy, test, recopy, test ad nauseum...only prob will be some delay from...

Is the file constantly open?

Exactly...he could include a timer in the app and have it periodically run some routines to see if the file has been changed...if it has, update the display. In the event of the file being locked, he...

That is it right there. I am a self taught programmer with about 2 yrs experience. I started with 6.0, so I've always had the object.

Sorry Hannes, I thought Me was used in .Net, I have never used in 6.0. Just remembered it's My in .Net. Forgive me, still kind of a noob.

Or is there another way to access the messages from clsJournalBase in my two exportable classes that will allow me to avoid setting up a property in each class as type clsJournalBase?

Finally, the...

DataMiser - Have to agree the standard I/O are nice. I use them for binary/random file access. I just prefer to use the filesystemobject for text files since it provides nice ways of verifying the...

I like the frame idea...very clever...will add that to my tools.

I usually use an array/collection for looping though objects and performing the same method.

You could code the array as

dim...

This can be done by creating an instance of Scripting.FileSystemObject and using the methods that this object provides. I am attaching a link to the msdn library site for the FileSystemObject. This...

Hello all, this is my first post on CodeGuru.

I am currently developing an ActiveX exe using VB 6.0. My plan calls for a private class (clsJournalBase) to be delcared and instanced once through...