Search results for query: *

Or, you could create a macro within the Excel workbook and execute it from Access. Microsoft Knowledge Base Article - 194611 How To Create and Call an Excel Macro Programmatically from VB http://support.microsoft.com/default.aspx?scid=kb;EN-US;194611

Any chance Word is calling your VirusScanner for a document scan upon opening?

Crystalyzer, Thanks for posting your solution to your own question. While my needs were not quite the same as yours I was able to find my way based on some of the ideas presented in your code. Thanks!

I tried that. If there is a pattern there I was unable to detect it. Sadly, I could even find filenames with ".doc" extensions withing .pdf files. I am guessing that the .pdf was a .doc first. M$ has a way to tell what the data is, but they sure have obfuscated how they do it.

While that reveals a lot of information I was unable to find anything that would tell me the Type of the data file stored in an OLE field. Did I miss something?

If your reply will be "you shouldn't store documents within an Access database" please do not waste the space. I don't have a choice in the matter. Lets say that you have a table tblTest with 2 fields - an AutoNumber and an OLE Container. Now suppose that there are two records in this table...

Wow. This is old. I guess there is no answer?

Care to share what you did?

The MS KnowledgeBase has this: Mouse wheel events do not work in the Visual Basic 6.0 IDE http://support.microsoft.com/default.aspx?scid=kb;en-us;837910 At the bottom they claim it applies to VBA as well, but I couldn't get it to show up in my Add-Ins under VB. Sadly, the link entered by...