PDF in Document Manager

[Pitt]

I am building a DB for managing customers, products, and their related
documents. Before my time, my employer was storing documents as "PDF." I got
everything else under control except the "PDF". The problem is that I am not
able instruct Access to automatically reference "PDF" files but it can find
DOC, TXT, and XLS reliably.

If someone can provide a sample code or preexisiting db to reference that
would be great. Most of the information I find on the internet is too
complicated for me to fully understand (I'm a novice w/ no formal training
just hands on) so please provide an explanation if possible.

(Arvin Meyer: Incredible work, thanks for your contribution. I got a lot of
direction from your sample db.)

 

[M Skabialka]

I am using the same sample database right now as a start for an application
I am building. Since I am not looking the files types in his example, I
changed them in this module:
Sub ReadFolderInfo(rs As Recordset, strFolderName As String)
....
Select Case Types 'changed types as follows
Case "DLF", "ZIP", "JPG", "GIF", "AVI"

You can put anything you want in this line for the kind of douments you are
searching for.

Eternal gratitude to Arvin for that database.

Mich

 

[Pitt]

Thanks for the response. I did that already but I get the error msg:

3265: Item not found in this selection

I'm lost in the sauce with this one. There are pdf files in the folder but
it recognizes everything else (indicated in the Case) but not PDF...

Got any ideas?

 

[M Skabialka]

Do you mean you can't open it as a hyperlink? You do have a PDF reader,
like Acrobat, right?
What code gives you this error message?

 

[Pitt]

Do you mean you can't open it as a hyperlink? You do have a PDF reader,
like Acrobat, right?
What code gives you this error message?