Passing value to a report error 2212 (1 Viewer)

K

khan33

New member

Local time

Today, 18:14

Joined

Apr 23, 2011

Messages

8

• Apr 29, 2011

• #1

Dear,

I have a form and a button which contains a report on click event.

This report is based on a query which displays results from a table.

The matching criteria is based passed at run-time.

Unable to pass that value to the report.

Please help.

 

Trevor G

Registered User.

Local time

Today, 15:14

Joined

Oct 1, 2009

Messages

2,341

• Apr 29, 2011

• #2

khan33 said:

Dear,

I have a form and a button which contains a report on click event.

This report is based on a query which displays results from a table.

The matching criteria is based passed at run-time.

Unable to pass that value to the report.

Please help.

Click to expand...

Which Access version are you using, if you have created an Access 2007 database when adding a command button to preview/open a report it will add an if statement on Dirty which you might need to comment out.

If this doesn't help think about adding a cut down version of the database to the forum so someone can take a look and help you.

 

boblarson

Smeghead

Local time

Today, 07:14

Joined

Jan 12, 2001

Messages

32,059

• Apr 29, 2011

• #3

How are you passing the criteria? Is it being done using code? If so, please post that at least.

 

missinglinq

AWF VIP

Local time

Today, 10:14

Joined

Jun 20, 2003

Messages

6,423

• Apr 29, 2011

• #4

Error 2212 states "Microsoft Access couldn't print your object. Make sure that the specified printer is available."

Is the Default Printer, in fact, up, running and connected correctly?

Linq ;0)>