Un-edit-able Switchboard??

[techexpressinc]

MS-Access 07 - It displays ugly. I try to edit the swithbox and the pop-up message happens:

"Compile error, in query expressing 'IIf(IsNull [Arguement]),"',([Arguement])"

And that is it. No editting allowed?? How can I patch up the current switchboard or must I trash it and start all over, there is a cute graphic in the current one so I prefer to fix it.


I did a screen print and pasted it in Word document and uploaded to:

http://www.box.net/shared/713zefoltg


Thank you for any and all help.

Russ - Rneuman at Scaninc.org

 

[gemma-the-husky]

"Compile error, in query expressing 'IIf(IsNull [Arguement]),"',([Arguement])"

i am sure it doesnt say EXACTLY the message you have shown.

When does this happen, and what is the correct message?

 

[techexpressinc]

Re: Un-edit-able Switchboard?? - reply#2

It happens when I - click Database Tools - Switchboard Manager - select the name (default) switchboard - and click Edit.

The exact error message is at the URL
http://www.box.net/shared/713zefoltg

I did a screen print of it.

Thanks for the quick response.
Russ @ techexpressinc.com
and
Rneuman @ scaninc.org

 

[techexpressinc]

Re: Un-edit-able Switchboard - FIXED

I found the problem. I had some bad VB code. That caused the edit of the switchboard to fail.
I had some extra comments in front of the VB code. I removed them and all is running smooth.
The Switchboard had not worked for 3 months since I installed my bad code the last quarter's reporting time.
To see the age calculation VB with the extra front end go to the attachment.
There goes 4 hours of hitting my head on the wall.
Good Grief..
Russ