By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,534 Members | 1,807 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,534 IT Pros & Developers. It's quick & easy.

Mouse wheel on Switchboard problem

P: n/a
I have created a switchboard, created using Access 2000. If I put the
mouse anywhere on the form, outside of the checkboxes and scroll the
wheel backwards, I get the following error.

Run-Time Error '-2147217900(8004e14)':
Syntax Error (missing operator) in query expression in
'[ItemNumber]>0 and [SwitchboardID]='

I know that the Switchboard probably doesn't cater for this event but
sometimes you can't help twiddling the wheel can you?

I have tried changing the Switchboard properties but don't really know
what's causing the problem.

Is it possible to solve this problem or will I have to dispense with
the Switchboard and create my own Form? If so is there a SIMPLE way to
convert the Switchboard to a Form?

Terry
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Frankly, I've always thought that the Switchboard Manager was a complex
solution to a simple problem that tended to obscure what was going on, as it
seems to be doing in your case.

It is trivially simple to create a blank form and add Command Buttons to
open other Forms for various purposes (of course, if you have simple reports
not requiring selection of data, those Command Buttons can be directly on
the Switchboard Form, too). So, that is what I do...

It is, then, easy to see what is being done, simply look at the Click event
for the Command Button -- no logic that you have to puzzle out, no tables
involved, no problems.

No, I don't know of a way to convert the _Switchboard Form and all its
attendant appendages_ into a simple Form, but it is simple to create a Form
that serves as a Switchboard.

Larry Linson
Microsoft Access MVP
"Terry" <tc*****@merseymail.com> wrote in message
news:38**************************@posting.google.c om...
I have created a switchboard, created using Access 2000. If I put the
mouse anywhere on the form, outside of the checkboxes and scroll the
wheel backwards, I get the following error.

Run-Time Error '-2147217900(8004e14)':
Syntax Error (missing operator) in query expression in
'[ItemNumber]>0 and [SwitchboardID]='

I know that the Switchboard probably doesn't cater for this event but
sometimes you can't help twiddling the wheel can you?

I have tried changing the Switchboard properties but don't really know
what's causing the problem.

Is it possible to solve this problem or will I have to dispense with
the Switchboard and create my own Form? If so is there a SIMPLE way to
convert the Switchboard to a Form?

Terry

Nov 12 '05 #2

P: n/a
Thanks Larry,

I created a blank Form as you suggested, it took me about 20 minutes
to make an accurate replica of the origional 5 button screen,
including background colours, general layout and also selection of
data using doCmd. It works just as well if not better!

I found it much more satisfying and rewarding to feel that I was in
control and not at the mercy of the whims of the Switchboard, which I
now see is just a complicated 'Form Template' with code included that
may or may not be used.

By the way there is a solution posted on the address below. This
involves dowloading a .dll file, unzipping it and placing it it system
files. A bit risky I thought and it wouldn't work on other PC's! So
what's the point? But for anyone who is interested here is the
address.

http://www.lebans.com/mousewheelonoff.htm

Thanks

Terry

"Larry Linson" <bo*****@localhost.not> wrote in message news:<9R*******************@nwrddc01.gnilink.net>. ..
Frankly, I've always thought that the Switchboard Manager was a complex
solution to a simple problem that tended to obscure what was going on, as it
seems to be doing in your case.

It is trivially simple to create a blank form and add Command Buttons to
open other Forms for various purposes (of course, if you have simple reports
not requiring selection of data, those Command Buttons can be directly on
the Switchboard Form, too). So, that is what I do...

It is, then, easy to see what is being done, simply look at the Click event
for the Command Button -- no logic that you have to puzzle out, no tables
involved, no problems.

No, I don't know of a way to convert the _Switchboard Form and all its
attendant appendages_ into a simple Form, but it is simple to create a Form
that serves as a Switchboard.

Larry Linson
Microsoft Access MVP
"Terry" <tc*****@merseymail.com> wrote in message
news:38**************************@posting.google.c om...
I have created a switchboard, created using Access 2000. If I put the
mouse anywhere on the form, outside of the checkboxes and scroll the
wheel backwards, I get the following error.

Run-Time Error '-2147217900(8004e14)':
Syntax Error (missing operator) in query expression in
'[ItemNumber]>0 and [SwitchboardID]='

I know that the Switchboard probably doesn't cater for this event but
sometimes you can't help twiddling the wheel can you?

I have tried changing the Switchboard properties but don't really know
what's causing the problem.

Is it possible to solve this problem or will I have to dispense with
the Switchboard and create my own Form? If so is there a SIMPLE way to
convert the Switchboard to a Form?

Terry

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.