Recent content by DugzDMan

Since it's Access, you might try to put in an auto number field. Maybe it will create the auto number field in the order that they were inserted???

You can actually do this with FSO: strFileExtension = fso.GetExtensionName(strInputFile)

If you're just using an mdb file, then you should be fine, but I'd still check, just to be certain. Good Luck!

What type of DB are you pulling from? Some dbs insert data by hashing it and placing it in order of the has. I'm not sure if any of them use the date/time as a part of the hash they create. If so, there might (not sure) be a way to pull that info to at least create the initial order. From...

I would think you are still fine, but you might want to check the MS site, just to make sure. Are you doing this for work or personal? I just ask because were I work, we can send these issues to legal and they'll look up what kind of licenses and such we would have to get to do projects...

Using the latest Jet Driver should work. Like petevick said, you're not distributing any Access items. You're simply including Access functionality in your program. Nothing else will have it (at least not by installing your program). As far as the database ADO is Active-X Data Objects...

That all depends on the database your pulling against. What are the fields you are pulling? What database are you pulling from?

Yep, I checked it out and this works. Thanks guys!!! That's a star for each :-)

I believe I was making an elementary mistake. I haven't had time to go through all the code again to make sure, but I think I was referencing the wrong file (one that contains the same type of data, but more lines). I hope to get back to this early this week. Thanks for all the help!!

Thanks you guys! That should work just fine, I'll have to check when I get back into work.

Is there an In string type function in CF. In VB there is the InStr(String A, String B) function which searchs String A for the presence of String B. If it is found, it returns the position where String B starts in String A. If it isn't found, it returns 0. I'm looking for something similar...

There also an option inside OE to check to see if it is the default mail client. You can turn this on in options, if you want to check each time.

I also have Outlook XP, but do not receive any warnings whatsoever. It doesn't allow me to open, save, anything. They are just blocked. Do you this will work for me as well?? Thanks!!

I'm thinking it must be somewhere with the names I am using while manipulating the files (open file, clean, write to temp file while processing, close files, rename temp file as clean file, open clean file to process, etc.). I have to get to work early, so I'm going to look at it tomorrrow...

You may have figured something out by now, but I'll try anyway. When I create a meeting in my calendar, there is a checkbox to make the meeting private. There is still a place holder for that timeframe, so that people know you are busy, but the title is Private and no one can get any more info...