Kamis, 11 April 2013

[MS_AccessPros] Re: VBA Autocomplete

 

I agree with what Bill said. I have a database that logs users off after 30 minutes of inactivity and the form has a timer event that opens hidden as the database opens. If I don't open the database using "shift-enter" I the cursor moves back and forth when I'm trying to code. If you can't open the database that way, open the offending form (object) in design mode, then close it.

John F

--- In MS_Access_Professionals@yahoogroups.com, "Bill Mosca" <wrmosca@...> wrote:
>
> I'm also betting there is a form with a timer event open. That pulls the focus off of the code editor for a split second. It causes all kinds of funny things while you are typing.
>
> Regards,
> Bill Mosca, Founder - MS_Access_Professionals
> http://www.thatlldoit.com
> Microsoft Office Access MVP
> https://mvp.support.microsoft.com/profile=C4D9F5E7-BB03-4291-B816-64270730881E
> My nothing-to-do-with-Access blog
> http://wrmosca.wordpress.com
>
>
>
> --- In MS_Access_Professionals@yahoogroups.com, Duane Hookom <duanehookom@> wrote:
> >
> > Abdul,I would make sure all of the code compiles and check for any form open with a timer event running. Duane Hookom MVPMS Access
> > > To: MS_Access_Professionals@yahoogroups.com
> > > From: JohnV@
> > > Date: Wed, 10 Apr 2013 11:01:33 +0200
> > > Subject: RE: [MS_AccessPros] VBA Autocomplete
> > >
> > > Abdul-
> > >
> > > I'm not seeing that behavior. I'm able to move up and down in the list with
> > > my keyboard arrows, and even if I go away for a while, the list stays open.
> > >
> > > John Viescas, Author
> > > Microsoft Access 2010 Inside Out
> > > Microsoft Access 2007 Inside Out
> > > Microsoft Access 2003 Inside Out
> > > Building Microsoft Access Applications
> > > SQL Queries for Mere Mortals
> > > http://www.viescas.com/
> > > (Paris, France)
> > >
> > >
> > >
> > > -----Original Message-----
> > > From: MS_Access_Professionals@yahoogroups.com
> > > [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Abdul Shakeel
> > > Sent: Wednesday, April 10, 2013 10:45 AM
> > > To: MS_Access_Professionals@yahoogroups.com
> > > Subject: Re: [MS_AccessPros] VBA Autocomplete
> > >
> > > Dear John,
> > >
> > > This is not my case when I type Me. auto complete window appears but before
> > > I type anything it hides some time I scroll the list from my keyboard down
> > > arrow and its hide/disappear suddenly.
> > >
> > >
> > > On Wed, Apr 10, 2013 at 1:19 PM, John Viescas <JohnV@> wrote:
> > >
> > > > **
> > > >
> > > >
> > > > Abdul-
> > > >
> > > > If you have it turned on, Intellisense shows a list whenever you type
> > > > something to which it can respond. For example, if you type:
> > > >
> > > > Me.
> > > >
> > > > .. Intellisense should show you a list of all the properties and
> > > > methods of the Me object. The list will disappear if you type
> > > > something that doesn't appear in the list or you move away to
> > > > somewhere else in the code. For example, if you type Me.X where X
> > > > isn't a match in the list, the list disappears. If you backspace over
> > > > the X, it still won't reappear. You have to backspace over the X AND
> > > > the period, then type the period again to see the list.
> > > >
> > > > Is this your problem?
> > > >
> > > > John Viescas, Author
> > > >
> > > > Microsoft Access 2010 Inside Out
> > > >
> > > > Microsoft Access 2007 Inside Out
> > > >
> > > > Microsoft Access 2003 Inside Out
> > > >
> > > > Building Microsoft Access Applications
> > > >
> > > > SQL Queries for Mere Mortals
> > > >
> > > > http://www.viescas.com/
> > > >
> > > > (Paris, France)
> > > >
> > > > From: MS_Access_Professionals@yahoogroups.com
> > > > [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Abdul
> > > > Shakeel
> > > > Sent: Wednesday, April 10, 2013 8:41 AM
> > > > To: MS_Access_Professionals@yahoogroups.com
> > > > Subject: [MS_AccessPros] VBA Autocomplete
> > > >
> > > >
> > > > Dear All
> > > >
> > > > I am facing a problem with VBA auto complete (Intellisence) when ever
> > > > I want grab something the auto complete window shows & always hides
> > > > after some seconds. please suggest
> > > >
> > > > --
> > > > Regards,
> > > > Abdul Shakeel
> > > >
> > > > [Non-text portions of this message have been removed]
> > > >
> > > > [Non-text portions of this message have been removed]
> > > >
> > > >
> > > >
> > >
> > >
> > >
> > > --
> > > Regards,
> > > Abdul Shakeel
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> > >
> > >
> > > ------------------------------------
> > >
> > > Yahoo! Groups Links
> > >
> > >
> > >
> > >
> > >
> > >
> > > ------------------------------------
> > >
> > > Yahoo! Groups Links
> > >
> > >
> > >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>

__._,_.___
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (7)
Recent Activity:
.

__,_._,___

Tidak ada komentar:

Posting Komentar