Hi, Just made the switch from Access '03 to '07, and the transistion isn't going well. I guess I will start with the VB code. Everything worked in '03, but when I switched to '07 and opened a report, I got the following error:
The expression On Format you entered as the event property setting produced the following error: A problem occurred while Microsoft Office Access was communicating with the OLE server or ActivX Control.
*The expression may not result in the name of a macro, the name of a user-defined function, or [Event Procedure].
* There may have been an error evaluating the function, event, or macro.
This error occurs when an event has failed to run because Microsoft Office Access cannot evaluate the location of the logic for the event. For example, if the OnOpen property of a form is set to =[Field], this error occurs because Access expects a macro or event name to run when the event is fired.
A custom Macro in this report has failed to run, and is preventing the report form rendering.
I am able to open VB, and compile the code, but the debug tool doesn't work at all. The code is basically defining colors with RGB values, and changing the back color of certain text boxes to the defined color stored in table values. I am getting a security error when I open the report, and wants to know if I trust the sorce and enable ActivX and macro, or allow Access to filter it. I have been clicking trust the source, but it still asks me each time I open it. I can view the layout and the design view, but not open the report. Thanks for any help. Paul