07 Switchbox Not Working! - please help

[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:

MS-Access Switchboard Error v4-28-9.docx - File Shared from Box.net - Free Online File Storage


Thank you for any and all help.

Russ - Rneuman at Scaninc.org

[techexpressinc]

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

[RuralGuy]

You can attach items directly to your post in this forum.

[techexpressinc]

I added a screen image of the problem in two formats.

Russ

[RuralGuy]

Thanks Russ,
Any chance you could attach your db? Remove any sensitive data of course.

[techexpressinc]

that be a little toughier I would have to make a copy delete out about all data and zip it.
Let me sleep on that one.
Russ

[RuralGuy]

Maybe create a new db and just import the SwitchBoard stuff and see if you still have the same issue. If so the post the new db here.

[techexpressinc]

I tried that and then did the Tools - Switchboard - now shows this when i
edit the default:

"Enter Case Management".

i am still confused on how to fix it.

Russ

[RuralGuy]

I don't get any errors except when the form does not exist. It sequences through the additional switchboards just fine. Have you enabled your code yet?

[RuralGuy]

Russ,
Is there something I should do to expose the error?

[techexpressinc]

The error occurs when I try to edit the switchboard.


enable code - hmmm -This is an adopted db i am not familiar with that process?
Russ

[RuralGuy]

Is the db in a trusted location? Did you look at the link I supplied in Post #9? I'll download the new db. Is there something different?

[RuralGuy]

I can edit the SwitchBoard form without a problem. Why did you post the SwitchBoard table as an Excel file? I'm confused.

[techexpressinc]

I thought maybe the SwitchBoard table would point to an the pbl. You can not upload .mdb so I did it as an Excel file, zipped.

I did number #9 and enable and it had a vb error.

Access does not let me edit the switchboard thou.
Russ

[RuralGuy]

So it now has a compile error? I can't read your .doc file well enough. What is the error? Do you get it each time you compile? Again, I can edit the SwitchBoard code and the tables without a problem.