Opening pdf files from Access (1 Viewer)

[Tay]

I intend to set up a help system for my db, where users can press a help button on a particular form, and then a pdf document will appear with the relevant help file.I tried using the following code
Private Sub Command1_Click()
FollowHyperlink "c:\pdf\project1.pdf"
End Sub
and this works fine. The problem is that this makes me db grow quite a lot, and seeing that I will be having a number of help files, my db will end up far too large.
Does anyone out there have any idea of another way of doing this, which won't involve the bloating? TIA.

 

[Mile-O]

Two ways I can think of

1) You get the HTML Help Workshop (I believe it's a component of MS Office Developer Edition) or something and there you can create HTML helpfiles and apply the Help ID on controls to specific help files.

2) Simplify things. Create a help table. Listboxs and textboxes. Textbox to search, listbox to diplsy results. Double click the list to get an answer

 

[IMO]

Maybe you could adapt this example db. Don't know if this will make a difference though.

IMO

 

[Tay]

Thank you both.
I don't suppose you could convert the example db to A97? Cheers.

 

[IMO]

Here you are.

IMO

 

[acgrego]

Opening PDF page

Thanks for sharing the file!!!

This is a FANTASTIC idea for my program in access.

My idea is to open a PDF file several times, but the opening page is always diferent.....

I already made some experiments with VB but I can´t do it just because I'm not a expert... :-((((

The event "Linkexecute" (that make the opening page), suported by Adobe isn't acceptable by the VB Access compiler.

Is it possible with this example set the file to open, and the opening page???

THANKS in advance, because I REALLY need help on this!

 

[IMO]

In the Form Open event, change...

Me.AcrobatPath = "C:\"

to the path and file name that you want to open automatically, ie...

Me.AcrobatPath = "C:\Documents and Settings\temp\My Documents\YourFile.pdf"

Goto Tools >> StartUp >> Display Page/Form and select the Form.

HTH
IMO

 

[acgrego]

Thanks IMO,

I already achieved to open the automatically the file I want.

Do you how can I open that file in specific page, once, and then in another page?

What I really need to do is this:

I have a table with links to pdf files, and numbers of the pages to open those files. One column with the file and other column with the page number. So, the same file can be open in different pages.....

This is made always locally in my pc!


Can you help me? If I can do this, then I have my database completed!

Thanks for your time!

 

[acgrego]

I suspect that I need to use something like this:

CAcroAVPageView.Goto pagenumber

and also other kind of declarations, but I just don't know the right code to do it! ......


Please help

 

[acgrego]

IMO

IMO can you help about my problem?

 

[acgrego]

Hi people,

For me, it's very fustrating that nobody can answer me.

After all, I made some web search, and I realised, that my doubt it's common to a lot of people, and I didn't found anywhere the right answer...... .

I think that a lot of people didn't want to share the code.....