Executing an Access Report from VB With Parms

[shyguy]

Hi All

Can Anyone help me with some Code?

I Would like to execute an MS Access Report, stored in the Report Tab in MS Access DB, from VB 5 Code and pass a From and a To Date Paramter to the Code/Report.

Could you email me directly to:

[email protected]

as my email has changed and I won't get a notification when you reply

Many Thanx

[smalig]

Try follow code:

Dim Rep As Access.Application

Set Rep = New Access.Application
Rep.OpenCurrentDatabase("d:\db1.mdb")
Rep.DoCmd.OpenReport "Test1"
Rep.CloseCurrentDatabase

------------------
smalig
[email protected]
smalig.tripod.com