Re: [MS_AccessPros] Re: VBA Autocomplete

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@comcast.net> 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]



------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/MS_Access_Professionals/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/MS_Access_Professionals/join
(Yahoo! ID required)

<*> To change settings via email:
MS_Access_Professionals-digest@yahoogroups.com
MS_Access_Professionals-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
MS_Access_Professionals-unsubscribe@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/