FYI – Illegal Operation (concerning forms) (2000)

Topic

New Reply

Just FYI,

I have twice locked up a file with the illegal operation message after adding a button to a form (I think). After trying all else, I set the security settings to high and disabled all macros. I then opened the VBA project and deleted (and exported) the form I thought that might be causing the problem. I then imported the forms back, saved, closed, and reopened and all seems well.

Out of curiosity, does anyone know what specifically occurs when you export a form, other than creating a form specific file with a .frm extension? What happens to the buttons, captions, and other controls? Are these stored as numerical settings within the .frm file? I would be interested to understand the process.

Thanks,

Reply | Quote

Replies

Michael,

When you export a Userform you actually create 2 files, one with a .frm extension and one with a .frx extension – known as the OleObjectBlob . The file with the .frx extension stores details of the controls and other OLE stuff, in binary format (I think). The .frm file is useless without the .frx file. It just stores the form screen metrics etc.

It is interesting that exporting and re-importing the form seems to have sorted out your problems. There must have been some form of corruption in the form.

Andrew C

Reply | Quote

I thought it was pretty interesting too…I think my ones are mutating into zeros and vice versa while I sleep.

Reply | Quote

Hi Michael,

Have you ever tried using my Autosafe utility?

find it at

http://www.bmsltd.ie/mvp%5B/url%5D
(near bottom of page)

Edited Mar 13th 2004 to update link

Reply | Quote