 |
| 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
|
|
|
|

February 5th, 2004, 04:56 PM
|
|
Authorized User
|
|
Join Date: Jun 2003
Posts: 91
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
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
|
|

February 5th, 2004, 04:59 PM
|
|
Friend of Wrox
|
|
Join Date: Jul 2003
Posts: 174
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
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
|
|

February 5th, 2004, 05:01 PM
|
|
Authorized User
|
|
Join Date: Jun 2003
Posts: 75
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
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
|
|

February 5th, 2004, 07:24 PM
|
|
Authorized User
|
|
Join Date: Jun 2003
Posts: 91
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
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
|
|

February 5th, 2004, 07:25 PM
|
|
Authorized User
|
|
Join Date: Jun 2003
Posts: 91
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Good call Mike that resolved the issue. I appreciate your insight!!
Kenny Alligood
|
|

February 5th, 2004, 07:29 PM
|
|
Friend of Wrox
|
|
Join Date: Jul 2003
Posts: 174
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Cool! I don't always have to have the exact answer! :)
|
|

February 5th, 2004, 08:21 PM
|
|
Authorized User
|
|
Join Date: Jun 2003
Posts: 75
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
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.
|
|

February 17th, 2004, 11:32 AM
|
|
Registered User
|
|
Join Date: Feb 2004
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
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
|
|
|

February 17th, 2004, 11:46 AM
|
|
Friend of Wrox
|
|
Join Date: Jul 2003
Posts: 174
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
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
|
|

February 17th, 2004, 12:19 PM
|
|
Registered User
|
|
Join Date: Feb 2004
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
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
|
|
 |