Help running access reports from vb 6.0 1

[paco2001]

I need help printing a Microsoft access 2000 report from vb 6.0. I have been using the crystal reports that is shipped with visual basic 5.0 and access 97 as my database, but we’ve switched to office 2000 and vb 6.0. The crystal reports that came with vb 5.0 doesn’t work well with access 2000. Microsoft packaged Crystal Reports 4.6.1.0 with vb 6.0, but it doesn’t work at all with access 2000. So I’m left with trying to print an access 2000 report from a vb 6.0 application. I would like to keep the user from having to move from vb to open access then having to find the correct report to print. So please if you have any suggestions on how I can do this I would be for ever in your debt. I tried using the vb 6.0 reports generator, but it’s too basic.

 

[HebieBug]

I know of a work around on this one if you don't want to use CR.
Access gives you the ability of creating macros. If you create a macro that prints the report. Then create a shortcut file. In the Access help there should be a section on command line prompts. From the shortcut you can have it so when the shortcut opens it prints the report through the macro.
Through a shell command in VB you can open the link file. Out pops the the report on the printer with no user intervention in Access