Switchboard that can not be edited ??

T

Tech Express

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

--
 
T

Tech Express

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.



Russ @ techexpressinc.com

and

Rneuman @ scaninc.org
 
B

Bob Quintal

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])"
Click to expand...
The code from the screengrab has an extra left parenthesis -(
It should read
IIf(IsNull([argument]),"",[argument])
NOT IIf(IsNull([argument]),"",([argument])
 
T

Tech Express

--------------------------------------------------------------------------------

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
--
Russ at scaninc.org


Bob Quintal said:
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])"
Click to expand...
The code from the screengrab has an extra left parenthesis -(
It should read
IIf(IsNull([argument]),"",[argument])
NOT IIf(IsNull([argument]),"",([argument])
Click to expand...
 
T

Tech Express

--------------------------------------------------------------------------------

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
--
Russ at scaninc.org


Bob Quintal said:
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])"
Click to expand...
The code from the screengrab has an extra left parenthesis -(
It should read
IIf(IsNull([argument]),"",[argument])
NOT IIf(IsNull([argument]),"",([argument])
Click to expand...
 
Top