473,769 Members | 2,120 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

access97 - auto syntax problem since vba critical upgrade

running on XP pro
adding vba code, I want to type in 'X = "good"'
when I type the 'X', and a 'space', if I wait a second, the cursor
automatically moves back over the 'space'

when I type the 'X', a 'space' and the '=', if I wait a second, I get
just 'X=' in red (like when you've got a syntax error)

when I quickly type in 'X', '=' and '"', after a second I get 'X = ""'
(making it hard to enter a string)

I created a new MDB and imported everything and the problem went away
for two hours, now it's back

I've compacted and repaired, no luck

I've unchecked all the coding options under tools->options->Module, no
luck
(they're normally all checked except 'keep debug window on top')

this happened a few times in the past 6 months and just restarting the
mdb fixed the problem

but it's happened three times in the past two days, after installing
the last critical XP upgrade and the office upgrade, ms-37 - vba patch

has anyone seen this ? or does anyone know how to rectify the problem
?
Nov 12 '05 #1
1 1962
le*********@nat pro.com (Roger) wrote in message news:<8c******* *************** ***@posting.goo gle.com>...
running on XP pro
adding vba code, I want to type in 'X = "good"'
when I type the 'X', and a 'space', if I wait a second, the cursor
automatically moves back over the 'space'

when I type the 'X', a 'space' and the '=', if I wait a second, I get
just 'X=' in red (like when you've got a syntax error)

when I quickly type in 'X', '=' and '"', after a second I get 'X = ""'
(making it hard to enter a string)

I created a new MDB and imported everything and the problem went away
for two hours, now it's back

I've compacted and repaired, no luck

I've unchecked all the coding options under tools->options->Module, no
luck
(they're normally all checked except 'keep debug window on top')

this happened a few times in the past 6 months and just restarting the
mdb fixed the problem

but it's happened three times in the past two days, after installing
the last critical XP upgrade and the office upgrade, ms-37 - vba patch

has anyone seen this ? or does anyone know how to rectify the problem
?

It looks to me as a form of spontaneous cursor-movement problem. You
could simlate it just by using the right and left cursor-keys. I don't
think it is an office-defect.
Look for possible hardware-problems (bad keyboard) or
software-initiated cursor-problems. Think of running keyboard-macro's,
remote-control-software on your PC or keyboard-driver problems (some
keyboards have special features and dito drivers). Eventually some
other ill-behaving software like a virus or hacker-tool could be
responsible for these spontaneous key-movements. In any case try
running the same database on another machine to be sure if it is
office- or PC-related.

Marc
Marc
Nov 12 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

699
34158
by: mike420 | last post by:
I think everyone who used Python will agree that its syntax is the best thing going for it. It is very readable and easy for everyone to learn. But, Python does not a have very good macro capabilities, unfortunately. I'd like to know if it may be possible to add a powerful macro system to Python, while keeping its amazing syntax, and if it could be possible to add Pythonistic syntax to Lisp or Scheme, while keeping all of the...
16
2546
by: David W. Fenton | last post by:
I have an app for a client (Access97, all the final service releases and Jet service packs, full installation (not runtime)), that displays a graphic in an image control based on a path/filename stored in a field in a data table. It works just great on my PC for BMP, GIF and JPG. But on the client's PC, JPG doesn't work (dunno if GIF works or not -- didn't try it; BMP does work). I wrote to Larry about this and he hasn't any...
1
1276
by: Ton | last post by:
I hope someone can help. A few years ago I built an access97 database and program. It ran fine in a setup with 4 users. Earlier this week they upgraded everything to WindowsXP. The access application and database now only work in single user mode. The program starts ok and the menu is shown etc. But updating a record isn't possible they get an error like ".../.../xxx.mdb is invalid"
5
2578
by: Brakeshoe | last post by:
I would like to find out how to turn on the Auto Complete variable names feature while editing source code in Visual Studio. It seems to appear on intermittantly, and when it does the variable list is incomplete or contains variables that do not even exist in the project being worked on. It seems like there should be a setting to turn this on and keep it up to date but I cannot find anything in MSDN. It is also a complete mystery why it...
5
2385
by: stefaan.himpe | last post by:
Hello list, Is anyone aware of a (light-weight, easy-to-use) auto-upgrade framework for python scripts? I find it hard to believe no one has wanted this before, yet google doesn't find too much relevant stuff. Thanks, Best regards,
10
2702
by: lesperancer | last post by:
you start with a small application in access97, then you have more modules and more... and you reach the point where tables like 'item' and 'employee' reach the limit and you know there's more indexes required for RI to come does creating a RI programatically instead of the relationship window still consume one of the 32 indexes ? does access2000 / 2003 allow more indexes per table ?
1
1844
by: IamKJVonly | last post by:
I have office 97 which includes access97 and have built many access97 databases and use VB4 as the front end. I have just gotten a new computer which has 1 gig of memory on it and when I try to install office 97 on it. everything installs ok execpt access97 won't run. I have since tried it on another machine and it seems to be a memory problem. If the computer's memory is more than 512megs. then access97 won't run. Is there a patch or...
22
3085
by: nospam_news | last post by:
I currently get asked about my usage of "auto". What is it for? The keyword is clearly superflous here. In contrast to the huge majority of C/C++ developers I write definitions very explicitly like that: int main(char argc, char *argv, char *env) { try { auto Exception mainException(1); mainException.setErrNo(42);
2
3387
by: Roger | last post by:
I've got two tables in sql2005 which have an 'ntext' field when I linked the first table in access97 last week using an odbc data source the access-field type was 'memo' when I link the 2nd table today, it is linked as a text(255) field, ditto for the first table if I link it today if I link the 2nd table using access2003 (and the same odbc data source) it is linked as a memo field
0
9579
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9422
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
1
9987
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
9857
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
7404
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5294
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5444
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3952
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
3558
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.