473,320 Members | 1,976 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Unable to delete unbound object frame

4
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.
Sep 24 '07 #1
7 3754
MMcCarthy
14,534 Expert Mod 8TB
Firstly, I am moving this to Access forum as you have mistakenly posted in the articles area.

Is the OLE object bound to a field in a table? If so open the table in design view and try changing the properties of the OLE object to reflect an application you do have on your system.
Sep 24 '07 #2
AndyS
4
Firstly, I am moving this to Access forum as you have mistakenly posted in the articles area.

Is the OLE object bound to a field in a table? If so open the table in design view and try changing the properties of the OLE object to reflect an application you do have on your system.

The properties are:
Display type : Content
Update options: automatic
Verb: 0
ole type: embedded
ole type allowed: either
class: MsImager.1
I can find no references to another table or external file
Sep 24 '07 #3
NeoPa
32,556 Expert Mod 16PB
I don't know about the OLE stuff but I often use the Access built-in documentor. This will find all the objects on any form or report in your database. It can give quite a lot of detail too, if configured to.
Sep 25 '07 #4
Jim Doherty
897 Expert 512MB
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.

Expand|Select|Wrap|Line Numbers
  1. Private Sub SaveReportAsText_Click()
  2. Application.SaveAsText acReport, "rpttest", "D:\Document\rpttest.txt"
  3. End Sub
Expand|Select|Wrap|Line Numbers
  1. Private Sub LoadReportFromText_Click()
  2. Application.LoadFromText acReport, "rpttest", "D:\Document\rpttest.txt"
  3. 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
Sep 26 '07 #5
AndyS
4
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.

Expand|Select|Wrap|Line Numbers
  1. Private Sub SaveReportAsText_Click()
  2. Application.SaveAsText acReport, "rpttest", "D:\Document\rpttest.txt"
  3. End Sub
Expand|Select|Wrap|Line Numbers
  1. Private Sub LoadReportFromText_Click()
  2. Application.LoadFromText acReport, "rpttest", "D:\Document\rpttest.txt"
  3. 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
Well it looked like it might work. I exported the report and tried a very minor change - a couple of calculations in the code section where I changed a couple of 1's to 2's. I imported the report without any problem. I exported again and this time just changed the name of a line from Line102 to Line302, checking to make sure that I did not already have a Line302. The import failed with a Property not Found error. So I finally tried to delete the entire Embedded75 block - as you say 'a huge block' of text. When I tried the import Access aborted with the standard 'Office has encountered a problem' message.

I tried twice more to ensure that I was doing the delete correctly and not deleting any extra begin or end statement but got the same result each time.

I created a new text file between each attempt.

I noticed that there is a Checksum in the third line of the text file. Could this be causing a problem?

I just went back in and noticed a typo - Accounting spelled Accouuningting - in the Status Bar Text for a text box. I corrected it and the text file again failed to load. Why does this report extract have a Status Bar Text for a textbox on a report - it does not show anywhere and is not on the property list.
Sep 26 '07 #6
Jim Doherty
897 Expert 512MB
Well it looked like it might work. I exported the report and tried a very minor change - a couple of calculations in the code section where I changed a couple of 1's to 2's. I imported the report without any problem. I exported again and this time just changed the name of a line from Line102 to Line302, checking to make sure that I did not already have a Line302. The import failed with a Property not Found error. So I finally tried to delete the entire Embedded75 block - as you say 'a huge block' of text. When I tried the import Access aborted with the standard 'Office has encountered a problem' message.

I tried twice more to ensure that I was doing the delete correctly and not deleting any extra begin or end statement but got the same result each time.

I created a new text file between each attempt.

I noticed that there is a Checksum in the third line of the text file. Could this be causing a problem?

I just went back in and noticed a typo - Accounting spelled Accouuningting - in the Status Bar Text for a text box. I corrected it and the text file again failed to load. Why does this report extract have a Status Bar Text for a textbox on a report - it does not show anywhere and is not on the property list.
Hi Andy,

Like I say it is an undocumented feature but has certainly helped me many times in fixing corrupted FORMS and REPORTS for issues such as yours. With the intention being to write out the entire structure of a form or report to a plain text file. With regard to checksum line you speak of...the term checksum is generally used to check the validity of something so I very much doubt that is an issue and is a required area of the file.

Editing this file is not for the faint of heart obviously, because it contains in itself program logic lots of Begin and End statements that LoadFromText would use to rebuild the report. It may well be that you might have selected one to many 'Begins' or not enough 'ends' in your editing or left a block section in there that shouldnt have been left or perhaps deleted something that shouldnt have been deleted.

It, of course might not at the end of the day be your ultimate answer, but it was worth a shot to save you having to rebuild the report from scratch

Regards

Jim
Sep 27 '07 #7
AndyS
4
Thanks for your help.

I will try a few more things and let you know if I get any further,

Andy
Sep 27 '07 #8

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: Tom | last post by:
I have an unbound object frame on a subreport containing a chart linked to a chart in an Excel worksheet. I can open the subreport in design view, select the unbound frame, go to Edit - OLE/DDE...
0
by: ghanley | last post by:
I have searched the web all day for a lead on this. I have found how to control the Graph object mut not the embedded excel unbound object frame. I am trying to chart the data below on one...
0
by: davidchildreth | last post by:
It would make my clients life easier if he could place attached file into an unbound object frame on a form. This activity causes bloat if there are many such insertions. I would like to...
4
by: Susan Bricker | last post by:
I have a command button on a form that is supposed to Delete the record being displayed. The record is displayed one to a form. The form is not a Pop-Up nor is it Modal. Tracing the btnDelete...
2
by: TD | last post by:
I would like to set the value of the Y axes on my graph at runtime. I created the graph my opening a form and placing an unbound object frame on it then placed the MS Graph control into this. Next...
2
by: itm | last post by:
I am using a Word document on a report in an unbound object. The document does not appear on the report the same way it appears as a Word document. It is much smaller. I tried changing the size...
0
by: Buddy Home | last post by:
Hello, I'm trying to upload a file programatically and occasionally I get the following error message. Unable to write data to the transport connection: An established connection was aborted...
3
by: Buddy Home | last post by:
Hello, I'm trying to upload a file programatically and occasionally I get the following error message. Unable to write data to the transport connection: An established connection was aborted...
0
by: chico_yallin | last post by:
I am trying to use an Excel file as a template for an Access report. To do this, I have linked the excel range to an unbound OLE frame. The OLE frame is placed over the report detail area and...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.