Wrox Programmer Forums
|
Access VBA Discuss using VBA for Access programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old February 5th, 2004, 04:56 PM
Authorized User
 
Join Date: Jun 2003
Posts: 91
Thanks: 0
Thanked 0 Times in 0 Posts
Default Crazy Thing happening

Has anyone ever experienced an issue with the VBE where it automatically backspaces after each space to where the words are run together in a continuous string if you are not paying attention? For example:

If I am entering the following -- DoCmd.OpenForm "frmMain"
I end up with -- docmd.openform"frmMain"

Also as this is happening it appears that the intellisense functionality is not working either; it does not offer the drop down to choose events or properties and it also is not autocapitalizing the control names, events, and properties.

I have verified through options that all of this is turned on and should be working. I have also compiled the code to assure that there isn't anything there that could be causing this problem.

If anyone has ever seen or experienced this in the past I would surely appreciate knowing the way that you resolved it because quite frankly it is annoying!

Thanx in advance.

Kenny Alligood
__________________
Kenny Alligood
 
Old February 5th, 2004, 04:59 PM
Friend of Wrox
 
Join Date: Jul 2003
Posts: 174
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Sounds like a reference issue and one is missing. Go to Tools > References and verify that none say "Missing:" in front of them.

If that isn't the issue, what are the references which you have listed?

Beth M
 
Old February 5th, 2004, 05:01 PM
Authorized User
 
Join Date: Jun 2003
Posts: 75
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Kenny,
   Do you have a timer event on a form that is firing. I have see this happen when the timer event fires.

HTH,
Mike
 
Old February 5th, 2004, 07:24 PM
Authorized User
 
Join Date: Jun 2003
Posts: 91
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanx for the reply. Actually I had an extra reference that I no longer needed so your advise was helpful. However, it appears that the Timer firing like DataMan suggested was the real culprit of the problem.

Kenny Alligood
 
Old February 5th, 2004, 07:25 PM
Authorized User
 
Join Date: Jun 2003
Posts: 91
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Good call Mike that resolved the issue. I appreciate your insight!!

Kenny Alligood
 
Old February 5th, 2004, 07:29 PM
Friend of Wrox
 
Join Date: Jul 2003
Posts: 174
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Cool! I don't always have to have the exact answer! :)
 
Old February 5th, 2004, 08:21 PM
Authorized User
 
Join Date: Jun 2003
Posts: 75
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Glad I could help. We all contribute to the board and for that I'm thankful...one is never too old to learn a new trick or two.
 
Old February 17th, 2004, 11:32 AM
Registered User
 
Join Date: Feb 2004
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to dubs70 Send a message via MSN to dubs70
Default

Beth-

I have a similar problem and do have a reference that says "Missing" in front of it. What do I do to resolve this issue?? Thanks in advance!!

Sarah
NGIT
Quote:
quote:Originally posted by BethMoffitt
 Sounds like a reference issue and one is missing. Go to Tools > References and verify that none say "Missing:" in front of them.

If that isn't the issue, what are the references which you have listed?

Beth M
 
Old February 17th, 2004, 11:46 AM
Friend of Wrox
 
Join Date: Jul 2003
Posts: 174
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Which one is prefaced with "missing"? If you relay this info, we might be able to tell you where to 'find' it. :)

Basically, if you uncheck the reference, click OK, then reopen the dialog box browse out to find it, select it, click ok again and all should be fine. But, if you can't find it, let us know and we will try to assist you in locating the file.

Regards,

Beth M
 
Old February 17th, 2004, 12:19 PM
Registered User
 
Join Date: Feb 2004
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to dubs70 Send a message via MSN to dubs70
Default

Thanks Beth-

It is the BP2000.MDE reference that says missing in the references box. I did a search for it on my computer and couldn't find it. Any help would be much appreciated!!! Thanks!!!!

Sarah W
NGIT






Similar Threads
Thread Thread Starter Forum Replies Last Post
Almost crazy trevo4f BOOK: Beginning ASP 3.0 2 May 15th, 2008 11:22 AM
About CSS Chapter 5 the <thing> + <thing> {} part thenetduck BOOK: Beginning CSS: Cascading Style Sheets for Web Design ISBN: 978-0-7645-7642-3 0 February 7th, 2007 03:45 AM
weird namespace thing happening Martijn XSLT 6 January 26th, 2007 01:00 PM
What is happening here? code_lover SQL Language 0 January 11th, 2007 07:29 AM
Eight chapter - very strange things happening marjan BOOK: Beginning PHP4/PHP 5 ISBN: 978-0-7645-4364-7; v5 ISBN: 978-0-7645-5783-5 2 May 1st, 2004 06:32 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.