Find Command Button

[Guest]

Hi all,
Do you mind to advise if the built in find button record can be called
without the 'replace' tab? Also, whenever I want to scroll up and down the
form, the wheel of the mouse can't achieve this feature. It turns out to
scroll up and down the records instead. Can you advise how I may change its
scroll function from records to form? Also, are there any built in functions
to check if the input data is characters only?

 

[Guest]

Hi KFC,

As far as I know, the find function cannot be called without the replace.
I'm sure Access MVP Allen Browne would have mentioned it in his article if it
was possible. See the last topic, "Find Dialog" on this page:

Flaws in MS Access
http://allenbrowne.com/bug-09.html


To disable the scroll wheel, try Stephen Leban's Mousehook sample:

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


To check for character only data entry, try this Knowledge Base article:

Validation Rule to Accept Only Alphabetical Characters
http://support.microsoft.com/?id=210385


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

:

Hi all,
Do you mind to advise if the built in find button record can be called
without the 'replace' tab? Also, whenever I want to scroll up and down the
form, the wheel of the mouse can't achieve this feature. It turns out to
scroll up and down the records instead. Can you advise how I may change its
scroll function from records to form? Also, are there any built in functions
to check if the input data is characters only?

 

[Guest]

Hi Tom,
I did try the sample you recommended but it seems didn't work. Do you
have any other ideas on disabling the wheel or enable the wheel function to
the page up or page down function instead? Thank you for your kindness

 

[Guest]

Hi Tom,
Sorry to bother you. The sample you recommended works fine while I forgot
to copy the dll to the mdb stored directory. Thank you for your kindness

 

[Guest]

Hi KFC,

I'm glad you found the problem.


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________