ACCESS FEED: [MS_AccessPros] Re: VBA Autocomplete

Glad that fixed it for you, Abdul.

-Bill

--- In MS_Access_Professionals@yahoogroups.com, Abdul Shakeel <maxccess@...> wrote:
>
> Thanks All,
>
> The Timer was the issue..I use this Bill's code (Slightly modified) to 0
> All me timer & its works perfectly
>
> Public Function dev_TbrFormTimerFix()
> 'Purpose : Check all forms to fix missing captions
> 'DateTime : 1/05/2010 13:14
> 'Author : Bill Mosca
> 'Requires :
> Dim doc As DAO.Document
> Dim db As DAO.Database
> Dim intInterval As Integer
>
> Set db = CurrentDb
>
> For Each doc In db.Containers("Forms").Documents
> DoCmd.OpenForm doc.Name, acDesign
> If Forms(doc.Name).TimerInterval <> 0 Then
> intInterval = InputBox(doc.Name & " has non zero timer Enter 0"
> _
> & "or click Cancel to skip.", _
> "Form Timer Interval")
> Forms(doc.Name).TimerInterval = intInterval
> End If
> DoCmd.Close acForm, doc.Name, acSaveYes
> Next
>
> MsgBox "All Forms checked for Timer Interval.", vbInformation
> Set db = Nothing
>
>
> End Function
>
>
> On Thu, Apr 11, 2013 at 7:33 PM, Bill Mosca <wrmosca@...> wrote:
>
> > **
> >
> >
> > John
> >
> > I use my Inactive shutdown form in most of my applications. The code
> > checks to see if the app name ends in an "e". Since I only deploy MDEs or
> > ACCDEs the shutdown form only opens in those types of files. That lets me
> > open my development copy without messing with the shift key (which is
> > always disabled in my production copies).
> >
> > Snippet sample:
> > 'Don't open monitoring forms if dev.
> > If Right(db.Name, 1) = "e" Then
> > GoTo exit_PROC
> > End If
> > 'Don't open monitoring forms if dev.
> > If Right(db.Name, 1) = "e" Then
> > GoTo exit_PROC
> > End If
> > '**************************************************************
> > 'This section of code loads an inactivity monitor and an Admin
> > 'form which responds to the value in the table AdminMessage
> > 'which also provides an open connection to BE to help speed
> > 'up things.
> > strFormName = "frmAdminMsg"
> > If SysCmd(acSysCmdGetObjectState, acForm, strFormName) _
> > = conObjStateClosed Then
> > DoCmd.OpenForm strFormName, acNormal, , , , acHidden
> > End If
> >
> > strFormName = "frmInactiveShutDown"
> > 'check if frmInactiveShutDown is closed. If it is, open it.
> > If SysCmd(acSysCmdGetObjectState, acForm, strFormName) _
> > = conObjStateClosed Then
> > DoCmd.OpenForm strFormName, acNormal, , , , acHidden
> > End If
> > '**************************************************************
> >
> > Bill
> >
> >
> > --- In MS_Access_Professionals@yahoogroups.com, "jfakes.rm" <jfakes@>
> > wrote:
> > >
> > > 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]
> > > > >
> > > >
> > >
> >
> >
> >
>
>
>
> --
> Regards,
> Abdul Shakeel
>
>
> [Non-text portions of this message have been removed]
>