Print MS Access report form visual basic

[El_Embozador]

Hi , please can you tell how i can print an MS ACCESS Report form visual
basic, i ned a sample code ..

Thanks

[Norman Yuan]

This question has been ansered in variuos VB NG for many, many times over
many years. If you do a Google search comp.lang.basic.* or
miscrosoft.public.vb.*, you could get scores of post regarding this topic.

Anyways, here is the hint:

1. Set reference to Access Object Library in your VB project. (that means,
your app will need Access installed to run this functionality);

2. Launch Access from your code by creating Access.Application object:

Dim acApp As Access.Application
Set acApp=New Access.Application

then you need to open the *.mdb (or *.adp file if it is an Access Project):

acApp.OpenCurrentDatabase("......")
acApp.OpenCurrnetProject(".....")

3. Use DoCmd object to open existing report in *.mdb file.

acApp.DoCmd.OpenReport "......."

You need to investigate Access Object Model, particularly,
Access.Application and DoCmd objects. Once you learn more on them, you could
even dynamically modify existing reports before you open them for
previewing/printing.
"El_Embozador" <bo****@telcel.net.ve> wrote in message
news:DL****************@news01.t-net.net.ve...

Hi , please can you tell how i can print an MS ACCESS Report form visual
basic, i ned a sample code ..

Thanks