Help with MS Access VB

Hi,

Pls help me with this...

When I use the docmd.OpenReport("ReportName") option for opening a report within ms access, it is working fine. But when i run this form from another PC on the LAN, i get an error message : "Wrong number of arguments or invalid procedure". What could be the problem???

Thanks in advance.

Binish

Did you include the lastest version of MDAC with your installation setup package?

I am running it directly from MS Access. using MS Access forms

Seeing as it is across a LAN.. I presume that this is the same database?

You are opening the report with the default of printing and normal window view. Does your report require parameters that are not being correctly set?

Test the other machine to see if it can create a report.. if you get an error message stating no printers then please refer to this from M$

http://support.microsoft.com/default...roduct=acc2002

I think the default for OpenReport is to Print the report. Do you have a specific printer called out? If so, it is probably not available across the net ... at least not by the same spec called out in your local program.

Try opening the report to the local display instead of to a printer ...

DoCmd.OpenReport "rptname", acViewPreview, , , acWindowNormal

If you do Open the Report directly to a printer, make sure you have it set to the default printer.

Thanks,

I am already doing acViewPreview and acWindowNormal. The problem is not with the printer settings either...

P.S. - I'm opening the access form saved on an mdb file on my machine from another machine on the network.