Access 2000: opening a report with a button on more than one form.

[Ally1205]

Hello all,
My Acess2000 database holds records of members of an organization which I manage. I've got a button on my most-used form, called 'local members and helpfulness', which opens a report designed to print one envelope, using address data from the current member record showing in the form. I did this by configuring the button execute a macro. The button's 'On click' event is set to the macro name: 'mcrPrintC5env':




It works fine; the report shows up in preview mode so that I can click 'print' to print off that single addressed envelope. However, if I put an identical button on another form which uses the same data from the same "local members list" table (via a different query), it doesn't work. When I click the button in form view, a popup input box appears:

Can anyone tell me how to rectify this problem? Sorry if it's a dumb question! ...Thank you!

[BluffMeAllIn]

HI Ally,

When you put the identical button on a different form did you copy and past or actually create a new button and new macro for it identical to the previous? The popup box is looking for a parameter of Forms!local members and helpfulness because it does not recognize this as a variable or essentially opened form to pick reference from.

In the details of the macro, I don't use them much myself as I actually prefer to code the VBA for more control, but it must have reference to the form that the button/macro were created on and so copying it to a new form isn't working because its a new form. Easiest suggestion would be to create the button and macro on the new form from scratch or get into the details of the macro and associate it to the new form.

Clear as Mud??

Dave

[ItsMe]

.....
identical button on another form which uses the same data from the same "local members list" table (via a different query), it doesn't work. When I click the button...Thank you!

Like Dave mentioned, your report is looking for a parameter that is not available. It seems your macro is looking for a specific form name. You will probably need another macro for the second form. Also, your control button name should not be part of the Where Condition.

Maybe it will be easier to write out some VBA. Why not start with using the Wizard to create a new control button on the second form. The wizard will ask if you want specific criteria to be displayed. If you are still having trouble, post the VBA that the Wizard creates for the newest control button's Click Event.

[Ally1205]

Dave,
Thank you for the reply. I have already tried putting a new button on the second form, and configuring it the same as the other button. I get the same result described in my first message. I'm not savvy on coding, but the first form, with the correctly-working button has the following code in its 'On Current' event procedures):
- - - - - - - - - -
Private Sub cmdPrintC5_Click()
On Error GoTo Err_cmdPrintC5_Click

Dim stDocName As String

stDocName = "rptPrintC5env"
DoCmd.OpenReport stDocName, acNormal

Exit_cmdPrintC5_Click:
Exit Sub

Err_cmdPrintC5_Click:
MsgBox Err.Description
Resume Exit_cmdPrintC5_Click
End Sub
- - - - - - - - - - - -
The second form (with the disfunctional button) has the following code in its On Current event procedures:
- - - - - - - -
Private Sub cmdPrintC5_Click()
DoCmd.RunCommand acCmdSaveRecord
DoCmd.OpenReport "rptPrintC5env", acViewPreview, , "[MailingListID] = " & [RecordID]
Me.Visible = False
End Sub
- - - - - - -
Looking at the button's 'on click' coding, I see this:

Regards
Ally1205

[BluffMeAllIn]

Hi Ally,

Perhaps there is an onOpen even of some kind associated with the rptPrintC5env because from what you have above as indicated there is no specific association to the form indicated in the error message. Therefore it would seem that the report has logic of some kind which is trying to reference the local members and helpfulness form.

You will need to have a look at the report itself and determine what macro's or vba logic might be associated with events for the form. You can look at the events through the properties same as you would a form.

Thanks,
Dave

[Ally1205]

Dave, The report has a 'Filter' property that references the 'members and helpfulness' form.:

Should I make a new report and new macro for each form which needs to print envelopes, with each report referencing (in the 'Filter' property) the specific form that bears the actual command button that executes the macro that opens the form-specific report? (Hope that phraseology made sense!) Having asked all that, I see that the next property under Filter, specifies that the Filter is not 'on'... so is it even needed? I don't remember having this problem when I built a very similar application in Access95 some years ago.
Thanks again,
Regards,
Ally1205

[ItsMe]

If you like, you can remove the filter on the form and we can provide you with the appropriate code for your forms. You can also upload your DB for analysis. Just remove private data. There is not any need to create another report.

[Ally1205]

Thanks, ItsMe. I removed the filter in the report's Filter property, but the result was exactly the same. Where should I upload my DB to?
Ally

[ItsMe]

Make a copy of your DB and use the copy.

In the table, use Ctrl + A to select all of the records. Use the Shift key to click a few records and de-select them. Now you can delete the highlighted ones. Leaving a few records will help to test the DB. Change some of the fields with names, Social Sec numbers, Phone, etc.

[Ally1205]

Thanks - I did that okay. Is it my .mdb file that I should upload? I tried to attach it to a 'new thread' message (per the FAQ), but the upload failed (twice)...

[ItsMe]

It might be too large of a file. What ever format is fine as long as it is not 2013. Try removing objects that are not needed and zip the file down.

[John_G]

Hi -

The record source for the report - Local Members List - is that a table or a query? If it is a query, are there any criteria expressions in the query which refer to a field on the form Local Members and Helpfulness ? If so, that may the source of your error - if you try running the report from a different form, then the query cannot find the form Local Members and Helpfulness, (it's not open), so it asks you to supply a value through the "Enter Parameter Value" dialog.

HTH

John

[Ally1205]

Hi John, Thank you for the suggestion. 'Local Members List' is the name of the main table. Each form I use gets its data from a query (a different query for each form. Each query draws data from the main 'Local Members List' table and a (linked) secondary table.).
Regards,
Ally1205

[Ally1205]

It might be too large of a file. What ever format is fine as long as it is not 2013. Try removing objects that are not needed and zip the file down.

Thanks... I will try your suggestions in about 12 hours, when I'm back on my office PC with the DB on it.
Ally1205

[Ally1205]

I have attached my zipped Access2000 mdb file: Ally1205.zip. (It wouldn't upload until I zipped it.)

Thanks for the kind help,
Ally1205