E-Mailing Reports - Snapshot Viewer Error

[Ally]

I have various command buttons in order to mail various reports which until yesterday were working perfectly. (Using Acc '97)

Now I get varying errors. One of them says:

”This recordset is not updateable.”

Another two say:

”Training Database can’t find the name “Enter Month Range for Title” / “Enter TrainerID” you entered in the expression.

You may have specified a control that wasn’t on the current object without specifying the correct form or report context.

To refer to a control on another form or report, precede the control name with the name of a collection, usually either Forms or Reports and the name of the form or report to which the control belongs. For example, Forms![Products]![UnitsInStock].”

I am also able to open the reports, just to view them, and they work fine. Also, if I send it to .rft format, there’s no problem, therefore, it must be something to do with the snapshot viewer.

Anyone got any ideas please? I'm completely stuck.

 

[Ally]

I've played around taking out the parameters but it came up with:

Method 'SendObject' of 'IDoCmd' failed.

Then I put parameters into a report in another database and tried emailing as a snapshot and it works, so it would appear it's definitely something to do with this database.

But what, I don't know. I tried importing everything into a blank database but that didn't work either. Does anyone have any ideas please.

 

[Ally]

Sorted - in case anyone's interested

Just in case anyone's interested, with some help from Microsoft, the problem lies with the OLE object that's in the reports. On changing it to an image control, sorts the problem.