Re: abjMouseWheel

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

I am using Vista x64 on one and Vista x32 on the other. Both of them have all the updates for Office, Windows, etc.

"Gina Whipp" <NotInterested@xxxxxxxxxxxxx> wrote in message news:Oy00ghjCKHA.1492@xxxxxxxxxxxxxxxxxxxxxxx
Perhaps it's a setting with the mouse and not with the database! What
version of Windows? This one really has me stumped!

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors II

http://www.regina-whipp.com/index_files/TipList.htm

"Jack Leach" <dymondjack at hot mail dot com> wrote in message news:8D215C5F-3FD3-45D2-8E82-53605B954C2C@xxxxxxxxxxxxxxxx
This means that any new modules created will have it in there, but you will
need to go through to all of your existing modules and add it.

After you do this, compile the code, and if you get any errors along the
lines of "Compile Error - Variable Not Defined", this means that there is in
fact an issue (usually a misspelled variable name or something of the sort).

I would recommend adding it to one module, compile, fix errors, move to the
next module, compile, fix errors, etc. If there is declaration issues this
will make it a little easier to handle.

--
Jack Leach
www.tristatemachine.com

"I haven't failed, I've found ten thousand ways that don't work."
-Thomas Edison (1847-1931)



"David" wrote:

Alright, I read up on this and I see what they are.
All of the modules that I have, each have a Compare Option at the top. And
none of the Modules have the Option Explicit. So I went to Options under
Tools and noticed that the "Require Variable Declaration" was UNCHECKED. So
I checked it. Now, how do I further correct this error?
David

"Jack Leach" <dymondjack at hot mail dot com> wrote in message
news:F3692748-EEB7-4C54-B5DD-550F7BDAE4BA@xxxxxxxxxxxxxxxx
> These should be in the top of each Module. Open your code window and > each
> module you click on these two lines should be the first uncommented > lines.
>
> Option Compare Database tells your code how to compare strings, > numbers,
> etc.
> Option Explicit tells your code that each variable needs to be defined > for
> it to be used. This is very important... make sure they're at the top > of
> each module (commented code (in green, something like: 'commented > code)
> can
> go before these, or empty spaces, but nothing else.
>
> -- > Jack Leach
> www.tristatemachine.com
>
> "I haven''t failed, I''ve found ten thousand ways that don''t work."
> -Thomas Edison (1847-1931)
>
>
>
> "David" wrote:
>
>> I'm not sure what
>> "Option Compare Database
>> Option Explicit" are. I'm not sure what you mean by the "top. of >> every
>> database". I don't see those words anywhere near the top (or >> anywhere
>> else
>> for that matter) in the database.
>>
>> For the On_Close event, I found this:
>>
>> Private Sub Form_Close()
>> DoCmd.Restore
>> End Sub
>>
>> This was part of the Form code.
>>
>> David
>>
>> "Gina Whipp" <NotInterested@xxxxxxxxxxxxx> wrote in message
>> news:eReMEPcCKHA.1340@xxxxxxxxxxxxxxxxxxxxxxx
>> > David,
>> >
>> > Yes, it is and I forgot... Do you have...
>> >
>> > Option Compare Database
>> > Option Explicit
>> >
>> > ...at the top of every database? (And yes when nothing appears it >> > is a
>> > good thing.)
>> >
>> > Also, do you have anything in the On_Close event of the form in
>> > question?
>> >
>> > -- >> > Gina Whipp
>> >
>> > "I feel I have been denied critical, need to know, information!" -
>> > Tremors
>> > II
>> >
>> > http://www.regina-whipp.com/index_files/TipList.htm
>> >
>> > "David" <msgroup@xxxxxxxxxxxxx> wrote in message
>> > news:ujQcB7bCKHA.3724@xxxxxxxxxxxxxxxxxxxxxxx
>> >> Gina,
>> >> To the best of my understanding, I open up, let's say the
>> >> abjMouseWheel
>> >> to view its code in vba. I then go to Debug and then compile. I >> >> did
>> >> that although nothing appears to have occurred. I guess that >> >> meant
>> >> that
>> >> there were no errors, right?
>> >> David
>> >>
>> >> "Gina Whipp" <NotInterested@xxxxxxxxxxxxx> wrote in message
>> >> news:OUK1ttbCKHA.3368@xxxxxxxxxxxxxxxxxxxxxxx
>> >>> David,
>> >>>
>> >>> Do you know how to Compile the code?
>> >>>
>> >>> -- >> >>> Gina Whipp
>> >>>
>> >>> "I feel I have been denied critical, need to know, >> >>> information!" -
>> >>> Tremors II
>> >>>
>> >>> http://www.regina-whipp.com/index_files/TipList.htm
>> >>>
>> >>> "David" <msgroup@xxxxxxxxxxxxx> wrote in message
>> >>> news:O9uMzqbCKHA.1340@xxxxxxxxxxxxxxxxxxxxxxx
>> >>>> Yes, the reference was removed.
>> >>>>
>> >>>> "Gina Whipp" <NotInterested@xxxxxxxxxxxxx> wrote in message
>> >>>> news:uXmePobCKHA.4004@xxxxxxxxxxxxxxxxxxxxxxx
>> >>>>> Did you remove the Reference?
>> >>>>>
>> >>>>> -- >> >>>>> Gina Whipp
>> >>>>>
>> >>>>> "I feel I have been denied critical, need to know, >> >>>>> information!" -
>> >>>>> Tremors II
>> >>>>>
>> >>>>> http://www.regina-whipp.com/index_files/TipList.htm
>> >>>>>
>> >>>>> "David" <msgroup@xxxxxxxxxxxxx> wrote in message
>> >>>>> news:65A4D08A-F65B-41CB-94AC-DE7FDE4CFAA8@xxxxxxxxxxxxxxxx
>> >>>>>> Jack, You know it's funny but I tried what you suggested,
>> >>>>>> importing
>> >>>>>> etc. Right as soon as I finished importing, it was then >> >>>>>> working.
>> >>>>>> I
>> >>>>>> could page up and down with my records using my Mouse Wheel. >> >>>>>> I
>> >>>>>> have
>> >>>>>> only one Form in the db.
>> >>>>>> Then, when I closed the db and then re-opened, it again no >> >>>>>> longer
>> >>>>>> worked. The form no longer recognized the mouse wheel for some >> >>>>>> odd
>> >>>>>> reason.
>> >>>>>> What the heck is going on??? This is the same version of >> >>>>>> Access
>> >>>>>> and
>> >>>>>> Vista that I was previously using. What is Access 12.0, is >> >>>>>> that
>> >>>>>> A2007?
>> >>>>>> Any clue what's happening?--David
>> >>>>>>
>> >>>>>> "Jack Leach" <dymondjack at hot mail dot com> wrote in message
>> >>>>>> news:CE9A9BA4-87AE-4056-A283-7A414786B71E@xxxxxxxxxxxxxxxx
>> >>>>>>> VBA App Extensibility 5.3 give access to the VBA IDE... >> >>>>>>> modify
>> >>>>>>> text
>> >>>>>>> in the
>> >>>>>>> code window with it, etc. I highly doubt the average >> >>>>>>> developer
>> >>>>>>> have
>> >>>>>>> need of
>> >>>>>>> this, but it does have its uses (I'm not sure what else it >> >>>>>>> does,
>> >>>>>>> nor
>> >>>>>>> do I
>> >>>>>>> have a lot of experience utilizing it).
>> >>>>>>>
>> >>>>>>> ref: http://www.cpearson.com/excel/vbe.aspx
>> >>>>>>>
>> >>>>>>>
>> >>>>>>> Personally I avoid the activeX and OLE refs as well if I >> >>>>>>> don't
>> >>>>>>> have
>> >>>>>>> specific
>> >>>>>>> need of them.
>> >>>>>>>
>> >>>>>>>
>> >>>>>>> Just out of curiousity David, have you tried importing >> >>>>>>> everything
>> >>>>>>> into a new
>> >>>>>>> db? Make sure you turn Autocorrect off and select your
>> >>>>>>> references
>> >>>>>>> accordingly in the new db before importing if you try it. By >> >>>>>>> the
>> >>>>>>> sounds it's
>> >>>>>>> only one or two forms, not all of them that are having this
>> >>>>>>> problem?
>> >>>>>>> If it
>> >>>>>>> doesn't work on any of the forms there's a possibility you >> >>>>>>> may
>> >>>>>>> have
>> >>>>>>> struck
>> >>>>>>> some difference between the Access 12.0 Obj Lib and the >> >>>>>>> previous
>> >>>>>>> version you
>> >>>>>>> were using.
>> >>>>>>>
>> >>>>>>> -- >> >>>>>>> Jack Leach
>> >>>>>>> www.tristatemachine.com
>> >>>>>>>
>> >>>>>>> "I haven't failed, I've found ten thousand ways that don't >> >>>>>>> work."
>> >>>>>>> -Thomas Edison (1847-1931)
>> >>>>>>>
>> >>>>>>>
>> >>>>>>>
>> >>>>>>> "Gina Whipp" wrote:
>> >>>>>>>
>> >>>>>>>> Uncheck... ' Microsoft Visual Basic for Applications
>> >>>>>>>> Extensibility
>> >>>>>>>> 5.3'
>> >>>>>>>>
>> >>>>>>>> This appears to only be needed back in Access 97 and it is >> >>>>>>>> the
>> >>>>>>>> exact
>> >>>>>>>> Reference that was causing the problem in the other similar
>> >>>>>>>> issue I
>> >>>>>>>> refered
>> >>>>>>>> to. (Not really sure you need 'Microsoft Active X Data >> >>>>>>>> Objects
>> >>>>>>>> 2.5
>> >>>>>>>> Library'
>> >>>>>>>> but without close examination I hesitate to remove the check
>> >>>>>>>> mark.
>> >>>>>>>>
>> >>>>>>>>
>> >>>>>>>> -- >> >>>>>>>> Gina Whipp
>> >>>>>>>>
>> >>>>>>>> "I feel I have been denied critical, need to know,
>> >>>>>>>> information!" -
>> >>>>>>>> Tremors
>> >>>>>>>> II
>> >>>>>>>>
>> >>>>>>>> http://www.regina-whipp.com/index_files/TipList.htm
>> >>>>>>>>
>> >>>>>>>> "David" <msgroup@xxxxxxxxxxxxx> wrote in message
>> >>>>>>>> news:O915EwXCKHA.4608@xxxxxxxxxxxxxxxxxxxxxxx
>> >>>>>>>> > Here are the references in their respective order:
>> >>>>>>>> >
>> >>>>>>>> > Visual Basic for Applications
>> >>>>>>>> > Microsoft Access 12.0 Object Library
>> >>>>>>>> > OLE Automation
>> >>>>>>>> > Microsoft Active X Data Objects 2.5 Library
>> >>>>>>>> > Microsoft Visual Basic for Applications Extensibility 5.3
>> >>>>>>>> >
>> >>>>>>>> > That's it. Nothing else is checked and nothing is shown
>> >>>>>>>> > "MISSING"!
>> >>>>>>>> >
>> >>>>>>>> > "Gina Whipp" <NotInterested@xxxxxxxxxxxxx> wrote in >> >>>>>>>> > message
>> >>>>>>>> > news:uoeLqlXCKHA.5780@xxxxxxxxxxxxxxxxxxxxxxx
>> >>>>>>>> >> David,
>> >>>>>>>> >>
>> >>>>>>>> >> Check your References, while the modules do not have any
>> >>>>>>>> >> files
>> >>>>>>>> >> associated
>> >>>>>>>> >> to them, 'MISSING' References can cause problems like >> >>>>>>>> >> this.
>> >>>>>>>> >> So
>> >>>>>>>> >> let's
>> >>>>>>>> >> eliminate that as the culprit. Also, and yes I know this
>> >>>>>>>> >> asking
>> >>>>>>>> >> a wee
>> >>>>>>>> >> bit BUT can you please type the References you do have >> >>>>>>>> >> set
>> >>>>>>>> >> and
>> >>>>>>>> >> the order
>> >>>>>>>> >> in which they are set. (Recently came across and issue >> >>>>>>>> >> where
>> >>>>>>>> >> too many
>> >>>>>>>> >> and the incorrect References were checked causing the
>> >>>>>>>> >> database
>> >>>>>>>> >> to behave
>> >>>>>>>> >> strangely.)
>> >>>>>>>> >>
>> >>>>>>>> >> -- >> >>>>>>>> >> Gina Whipp
>> >>>>>>>> >>
>> >>>>>>>> >> "I feel I have been denied critical, need to know,
>> >>>>>>>> >> information!" -
>> >>>>>>>> >> Tremors II
>> >>>>>>>> >>
>> >>>>>>>> >> http://www.regina-whipp.com/index_files/TipList.htm
>> >>>>>>>> >>
>> >>>>>>>> >> "David" <msgroup@xxxxxxxxxxxxx> wrote in message
>> >>>>>>>> >> news:eSDDYfXCKHA.1252@xxxxxxxxxxxxxxxxxxxxxxx
>> >>>>>>>> >>> Gina,
>> >>>>>>>> >>> I am also have the same problem with another module for >> >>>>>>>> >>> the
>> >>>>>>>> >>> same form.
>> >>>>>>>> >>> This module converts an integer to have a decimal point
>> >>>>>>>> >>> installed
>> >>>>>>>> >>> automatcally (by dividing it by 100) without having to >> >>>>>>>> >>> enter
>> >>>>>>>> >>> a
>> >>>>>>>> >>> decimal
>> >>>>>>>> >>> and simply hitting Enter. I also do not know how to
>> >>>>>>>> >>> "install"
>> >>>>>>>> >>> this
>> >>>>>>>> >>> module.
>> >>>>>>>> >>> I do appreciate your help on this.
>> >>>>>>>> >>>
>> >>>>>>>> >>>
>> >>>>>>>> >>> "Gina Whipp" <NotInterested@xxxxxxxxxxxxx> wrote in >> >>>>>>>> >>> message
>> >>>>>>>> >>> news:uIIBpVXCKHA.5068@xxxxxxxxxxxxxxxxxxxxxxx
>> >>>>>>>> >>>> David,
>> >>>>>>>> >>>>
>> >>>>>>>> >>>> Does any of your code work? Is your database in a >> >>>>>>>> >>>> Trusted
>> >>>>>>>> >>>> Location?
>> >>>>>>>> >>>> The module does work in Access 2007.
>> >>>>>>>> >>>>
>> >>>>>>>> >>>> -- >> >>>>>>>> >>>> Gina Whipp
>> >>>>>>>> >>>>
>> >>>>>>>> >>>> "I feel I have been denied critical, need to know,
>> >>>>>>>> >>>> information!" -
>> >>>>>>>> >>>> Tremors II
>> >>>>>>>> >>>>
>> >>>>>>>> >>>> http://www.regina-whipp.com/index_files/TipList.htm
>> >>>>>>>> >>>>
>> >>>>>>>> >>>> "David" <msgroup@xxxxxxxxxxxxx> wrote in message
>> >>>>>>>> >>>> news:OuB%23G%23WCKHA.4792@xxxxxxxxxxxxxxxxxxxxxxx
>> >>>>>>>> >>>>> Here is what I have that used to work on an older >> >>>>>>>> >>>>> machine
>> >>>>>>>> >>>>> that was
>> >>>>>>>> >>>>> also running A2007.
>> >>>>>>>> >>>>>
>> >>>>>>>> >>>>> Public Function DoMouseWheel(frm As Form, lngCount As
>> >>>>>>>> >>>>> Long)
>> >>>>>>>> >>>>> As Integer
>> >>>>>>>> >>>>> On Error GoTo Err_Handler
>> >>>>>>>> >>>>> 'Purpose: Make the MouseWheel scroll in Form View >> >>>>>>>> >>>>> in
>> >>>>>>>> >>>>> Access 2007.
>> >>>>>>>> >>>>> ' This code lets Access 2007 behave like
>> >>>>>>>> >>>>> older
>> >>>>>>>> >>>>> versions.



.

Relevant Pages

  • Re: abjMouseWheel
    ... I tested it on Windows XP. ... I fixed the References and was hoping that made a difference on ... Gina Whipp ... "Option Compare Database ...
    (microsoft.public.access.modulesdaovba)
  • Re: abjMouseWheel
    ... After you do this, compile the code, and if you get any errors along the ... Option Compare Database tells your code how to compare strings, numbers, ... Gina Whipp ... Check your References, while the modules do not have any ...
    (microsoft.public.access.modulesdaovba)
  • Re: abjMouseWheel
    ... David, my next idea would be to have you post the code so we can take a look ... "Gina Whipp" wrote: ... After you do this, compile the code, and if you get any errors along the ... "Option Compare Database ...
    (microsoft.public.access.modulesdaovba)
  • Re: abjMouseWheel
    ... "Gina Whipp" wrote in message ... "David" wrote in message ... After you do this, compile the code, and if you get any errors along the ... > Option Compare Database tells your code how to compare strings,> numbers, ...
    (microsoft.public.access.modulesdaovba)
  • Re: abjMouseWheel
    ... Option Compare Database tells your code how to compare strings, numbers, etc. ... Gina Whipp ... Check your References, while the modules do not have any files ... MsgBox strMsg, vbInformation, "Cannot scroll" ...
    (microsoft.public.access.modulesdaovba)