I hope someone can help with this.
I have been asked to update some old reports in an Access 2003 database (originally Access 2 then Access 97). These are Purchase Orders of various formats, but all have a signature block. The signature has to be changed, but has an ole class: Microsoft Imager 1.0 Picture. When I try to delete the box I get an error message : The Ole Server isn't registered. To register the Server reinstall it.
I do not have Microsoft Imager, and the ole type is Embedded. I was going to create a new form and copy all the other controls to it, but there is a logo on the form which I need to copy, and that generates the same error message when I try to copy it.
Any help would be greatly appreciated - I did complete one document which did not have the logo problem - it took almost 10 hours to find all the nearly invisible expandable text boxes, and get all the references and code behind the report working.
The following might help you however, it is undocumented and as such you should be very careful in how you use it. It is does help when you come across events such as that which you seem to me to be describing.
If you create two command buttons on a form and assign the following to their on click event procedures respectively.
- Private Sub SaveReportAsText_Click()
-
Application.SaveAsText acReport, "rpttest", "D:\Document\rpttest.txt"
-
End Sub
- Private Sub LoadReportFromText_Click()
-
Application.LoadFromText acReport, "rpttest", "D:\Document\rpttest.txt"
-
End Sub
You obviously need to change the name 'rpttest' to your report name and the path to the respective path on your computer.
The troublesome report will be outputted to a text file you can then locate the area of the text file housing your troublesome control (between two sets of BEGIN and END statements) and delete the specific 'huge block' of text that relates to the embedded control.
Save the text file and then load the report back in using the LoadFromText command button. The report will be rebuilt and should then be minus the control with everything else intact including formatting and any code behind the report.
Be careful how you use this because clearly you are editing the main file that rebuilds the report. You might want to test this on a report that doesnt matter first until you are happy that you can use it on the one you intend to deal with. The text file itself might also serve you as to finding and accounting for any hidden controls because the file contains everything which you will see as you scan your eyes down it.
Regards
Jim