open crystal report from access

[BRP250]

Hi

Can anybody supply vba code to open a crystal report from MSAccess 2000?

I've done this in vb6, is it the same?

Many thanks,

Bruce

 

[Blorf]

In access vba, try using

Followhyperlink "C:\Blah\Yourreport.XXX"

ChaZ

There Are 10 Types Of People In The world:
Those That Understand BINARY And Those That Don’t.

http://mysite.verizon.net/res0n4sv/

 

[BRP250]

Great thanks, it works. I thought Access would be better than that.

Bruce

 

[Blorf]

Glad it worked. I don't understand what you mean about access though.

There are pobably 100 ways to do it, followhperlink I think is easiset one liner.

ChaZ

There Are 10 Types Of People In The world:
Those That Understand BINARY And Those That Don’t.

http://mysite.verizon.net/res0n4sv/

 

[HitechUser]

BRP250,

Have a look here.. Tek Tips

Good Luck

 

[BRP250]

I need to fill parameters etc. so I do need one of the other methods. I'm just testing them now. From what I can see it is different to VB.

Thanks again, much appreciated.

Bruce