Solved

Cannot key numbers into VB 3 Access 2 application

Posted on 2001-06-14
5
157 Views
Last Modified: 2010-05-02
I'm supporting a VB3, Access 2.0 DB application in which a small percentage of users are unable to key numbers into several text boxes on screen, but they can key letters into any text box at any time.  Tried keying numbers from both keyboard and number pad but nothing happens when a number key is hit.  I have seen this issue with Win 95, 98, and 2000 workstations in stand alone, NT, and Novell environments.  No pattern there.

In many of these cases Win 95/98 users have been able to get around the problem by going to Control Panel, System, Performance Tab, File System, and change the Typical Role of this machine between the "Desktop Computer" and "Network server." If problem comes up again can change setting back and it usually helps.  Under Windows 2000 get same result by going to Control Panel; System; Advanced tab; Performance Options; under "Application response" change setting from "Applications" to "Background services."

This issue seems to be pc specific.  In cases where program is run from a server if problem comes up on one pc we can immediately go to another pc and key numbers into the same field without any problems.  On one pc with this problem we opened the Access 2.0 database directly (back door) and were able to key numbers directly into the table.

This issue has been a thorn in my side for over two years.  I don't know why changing the system settings helps (keep in mind there have been a few cases where nothing helped).  I would appreciate any ideas or sense anyone can make of this.  Thanks!!








0
Comment
Question by:stuckagain
5 Comments
 
LVL 43

Expert Comment

by:TimCottee
ID: 6191707
stuckagain, when this happens have you tried pressing Ctrl, Alt, Shift and releasing them then trying again. I know it sounds strange but sometimes windows does seem to think that one of these keys is down when in fact it isn't this will cause the system to think that you are pressing this key in addition to the number and this may be an invalid entry to the text box. I cannot say why this happens or how often but it occurs occasionally to me on NT4 and pressing the keys and releasing them always works.
0
 
LVL 14

Accepted Solution

by:
Matti earned 300 total points
ID: 6192316
Hi!

Event driven code in VB3?
Had years ago some of these VB 3.0 problems, need to use faster macine to fix and compile the program.

There comes stack problems and overflows and those do not show in the VB IDE if the prosessor is slow. like the performance difference scale from 486/66mhz to Cyric P 686-150.

So install the VB 3 to faster macine and try to run and fix the code.

Matti
0
 

Author Comment

by:stuckagain
ID: 6255918
The problem version of this application was compiled on an
 AMD K6-2 266 Mhz pc with 64 MB ram.  We now have a compile on a 1 Ghz pc with 256 MB ram.  Still waiting for client feedback but should be ok now. Thanks!!
0
 
LVL 14

Expert Comment

by:Matti
ID: 6256513
Hi!

Ok, that was an old solve, and discovered it by accident and those days it was bossible to reproduce the problem also.

Those AMD processors could be problematic as the old VB does not have any conditional compilation options available when it complies.

http://www.avdf.com/jul97/art_vb003.html

Also there is Power BASIC http://www.powerbasic.com/
This could be a "last chance" but this kind of solution need's more work.

One more think: Do you have Y2K update from MS for Access 2.0, there comes latest versions of VB 3.0/ 4.0 16bit DAO2.5 librarys.


Matti
0
 

Expert Comment

by:vb7guy
ID: 6657231
Sound like a dirty KeyBoard
Clean your Keyboard first. When ever keys get stuck or my fingers get stuck to the keyboard I was my hands first and then I clean the Keyboard. This technique works with all applications. If this does not work then replace your Keyboard.

Finally
if none of this works then stop using the keyboard, just relly on the mouse.
0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Excel - Save a copy of work book 13 90
Convert VB6 MSXML2.ServerXMLHTTP process to C# 2 59
Spell Check in VB6 13 127
VB 6 error 5 in windows 10 but not in XP 7 64
Introduction While answering a recent question (http://www.experts-exchange.com/Q_27402310.html) in the VB classic zone, I wrote some VB code in the (Office) VBA environment, rather than fire up my older PC.  I didn't post completely correct code o…
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

820 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question