Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Modules / DAO / VBA / October 2004

Tip: Looking for answers? Try searching our database.

Visual Basic Editor

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
dhowe - 24 Oct 2004 12:15 GMT
I am going crazy! Today when I go into visual basic editor and enter a new
line of code it keeps trying to autocorrect. As soon as I type something the
preceding text goes red. The drop down list of options appears for an instant
and then dissapears, eg if I type "Me.Parent. etc" , as soon as I type in the
. the drop down list appears for a moment and then dissapears and the line
goes red. I have tried changing the Options under Tools , all to no avail.
any suggestions?
Thanks
dhowe
Douglas J. Steele - 24 Oct 2004 13:12 GMT
Are you using a timer anywhere in your application? What you're describing
often happens under those circumstances, so you need to disable the timer.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> I am going crazy! Today when I go into visual basic editor and enter a new
> line of code it keeps trying to autocorrect. As soon as I type something the
[quoted text clipped - 5 lines]
> Thanks
> dhowe
dhowe - 24 Oct 2004 23:49 GMT
I am not intentionally using a timer. Is there any way to search for timers
in my code? This problem doesn't happen in my backup copies from a couple of
days ago.

> Are you using a timer anywhere in your application? What you're describing
> often happens under those circumstances, so you need to disable the timer.
[quoted text clipped - 11 lines]
> > Thanks
> > dhowe
Rick Brandt - 24 Oct 2004 23:52 GMT
>I am not intentionally using a timer. Is there any way to search for timers
> in my code? This problem doesn't happen in my backup copies from a couple of
> days ago.

It would have to be running in a form that you have open at the same time you
are in the code editor.

Signature

I don't check the Email account attached
to this message.     Send instead to...
RBrandt    at       Hunter      dot      com

dhowe - 25 Oct 2004 03:13 GMT
I thought I had it beaten but I was wrong.
I deleted my clock and the editor worked fine but next time in it was doing
the same thing.
It is fine in design mode and tries to autocorrect in all my forms.

> >I am not intentionally using a timer. Is there any way to search for timers
> > in my code? This problem doesn't happen in my backup copies from a couple of
> > days ago.
>
> It would have to be running in a form that you have open at the same time you
> are in the code editor.
Dirk Goldgar - 25 Oct 2004 03:28 GMT
> I thought I had it beaten but I was wrong.
> I deleted my clock and the editor worked fine but next time in it was
> doing
> the same thing.
> It is fine in design mode and tries to autocorrect in all my forms.

This is the classic symptom of having a form open with a Timer event
that is firing, as Doug and Rick pointed out.  In the Access application
window (as opposed to the VB Editor window) check every open form -- and
subforms on those forms -- to see if it has an active Timer event.  Bear
in mind that forms may be hidden, in which case you may click the menu
item Window -> Unhide... (if that option is disabled, there are no
hidden forms).

I suppose it is possible that your symptoms are caused by something
else, but I have never seen such a case.  We've seen these symptoms a
lot, and it has always been due to the firing of a Timer event.  Do you
understand what we mean by a Timer event?  The relevant properties in a
form's property sheet are the Timer and TimerInterval properties on the
Event tab of the form's property sheet in design view.

Signature

Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

dhowe - 30 Oct 2004 10:23 GMT
Thanks Dirk.
I deleted my clock but left my timer "event procedure" and my timer interval
in the event properties. Once I deleted these it was fine. If I needed a
clock on my form how would i do it without having the same problem?

> > I thought I had it beaten but I was wrong.
> > I deleted my clock and the editor worked fine but next time in it was
[quoted text clipped - 16 lines]
> form's property sheet are the Timer and TimerInterval properties on the
> Event tab of the form's property sheet in design view.
Dirk Goldgar - 31 Oct 2004 03:37 GMT
> Thanks Dirk.
> I deleted my clock but left my timer "event procedure" and my timer
> interval in the event properties. Once I deleted these it was fine.
> If I needed a clock on my form how would i do it without having the
> same problem?

I don't think you can, without going to extreme lengths -- setting up
some task external to Access that would run the timer.  But there's
nothing wrong with having a timer event on a form;  it's just that you
don't want to edit code while that form is open in form view and the
timer is running.  Is there some reason you need to have this clock form
open while you're editing code?

Signature

Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

dhowe - 25 Oct 2004 00:05 GMT
Another clue is that as I type in a line of code and a space after the word
the cursor jumps back to the end of the previous word. Also if I am typing in
a word such as "True" the cursor jumps back in front of the "T"
Thanks again for any help

> Are you using a timer anywhere in your application? What you're describing
> often happens under those circumstances, so you need to disable the timer.
[quoted text clipped - 11 lines]
> > Thanks
> > dhowe
dhowe - 25 Oct 2004 00:19 GMT
Thanks a million!!
I had a textbox showing the current Time on the form. Once I deleted it the
problem went away.
Thanks again
dhowe

> I am going crazy! Today when I go into visual basic editor and enter a new
> line of code it keeps trying to autocorrect. As soon as I type something the
[quoted text clipped - 5 lines]
> Thanks
> dhowe
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.