I have this hugh problem that's been racking my brains for many months now.

I have MS Access 2003 (running 2000 format). I've loaded the Acrobat 7.0 type library and am trying to use the PDDoc.GetNumPages method to populate Field2 in a table named tblPageCount. My problem is that it's not working.

My idea, I've seen it done, is to generate a directory listing of .pdfs to a .txt file or table and have a message box display the number of PDFs and the pagecount. So for example there's 5 PDF the msgbox would state File: 1 Page 25, then update file 2 page 100...and so forth till it reaches the end, file: 5 pages: 400.

My hope is that if I can figure this out then I could use the PDF method to print all pages, portrait or landscape and in-between PDF files to print a color page from tray 2 on my canon 105 printer.

Now I'm not asking for you to spell this out for me, I know it's old school and I'm a real Noob at this. But if you could give me a little help or point me in the right direction that would be such a big help

Thanks,
James