473,498 Members | 2,018 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Problem with Access 2000 or ?????

Ron
Hi All,

I've recently installed a program written in Access 2000 on a laptop. The
laptop had an existing Office 2000 Pro which of course included Access. But
the program acts oddly (more oddly than I would have programmed, anyway).

On everyday controls, everything acts normally. But on some controls (and
they're always the same ones) the operator can't add or change data. Take a
birthday field as an example. If the client was born on Jan 27th, 1954
you'd normally type in 1 slash 7 slash 1954. But when they type in the 1,
the position of the cursor doesn't move. It stays on the 1. So, when they
type the slash it replaces the 1 with a slash. Then the 2 replaces the
slash, and the 7 replaces the 2, etc. Cursor never moves. Now, you can
type 1 and hit the right arrow and then the slash and then the right arrow,
then the 2 and right arrow, etc and it all works fine. But to just
type...they can't.

Same program doesn't operate this way on any other system I've tried it on.
And, to make it interesting, this doesn't even need to be in a form I've
designed...works the same if I just double click on the table and try and
enter or change info on the datasheet.

I installed same program on another computer that had Access 2003 on it and
it's fine. Doesn't do this. Same program on another computer with Access
2000. No problems like this

So, is this a setting in Access 2000 somewhere that's just set in some way
for some reason and I can change it? If so, where? Or, maybe a bad install
of Access and I need to remove that one and install again?

What does anyone suggest?

TIA
ron
Aug 1 '07 #1
9 1968
Probably a daft suggestion, but have you got numlock or insert mode on your
keyboard set wrongly?

Also on Tools -->Options--Keyboard, there are options on how the cursor
moves. Try 'Move after entry' Next Field, 'Arrow key' Next Field, Select
entire field and Cursor stops at first/las field unchecked.

Phil

"Ron" <ro********************@verizon.netwrote in message
news:lq4si.7620$yg1.2038@trnddc04...
Hi All,

I've recently installed a program written in Access 2000 on a laptop. The
laptop had an existing Office 2000 Pro which of course included Access.
But the program acts oddly (more oddly than I would have programmed,
anyway).

On everyday controls, everything acts normally. But on some controls (and
they're always the same ones) the operator can't add or change data. Take
a birthday field as an example. If the client was born on Jan 27th, 1954
you'd normally type in 1 slash 7 slash 1954. But when they type in the 1,
the position of the cursor doesn't move. It stays on the 1. So, when
they type the slash it replaces the 1 with a slash. Then the 2 replaces
the slash, and the 7 replaces the 2, etc. Cursor never moves. Now, you
can type 1 and hit the right arrow and then the slash and then the right
arrow, then the 2 and right arrow, etc and it all works fine. But to just
type...they can't.

Same program doesn't operate this way on any other system I've tried it
on. And, to make it interesting, this doesn't even need to be in a form
I've designed...works the same if I just double click on the table and try
and enter or change info on the datasheet.

I installed same program on another computer that had Access 2003 on it
and it's fine. Doesn't do this. Same program on another computer with
Access 2000. No problems like this

So, is this a setting in Access 2000 somewhere that's just set in some way
for some reason and I can change it? If so, where? Or, maybe a bad
install of Access and I need to remove that one and install again?

What does anyone suggest?

TIA
ron

Aug 2 '07 #2
Ron

"Phil Stanton" <ph**@stantonfamily.co.ukwrote in message
news:46**********************@ptn-nntp-reader02.plus.net...
Probably a daft suggestion, but have you got numlock or insert mode on
your keyboard set wrongly?
Hi Phil,

The only dumb question is one you don't ask. No numlocks as there's no
number keypad on this laptop. And I've tried insert both ways.
Also on Tools -->Options--Keyboard, there are options on how the cursor
moves. Try 'Move after entry' Next Field, 'Arrow key' Next Field, Select
entire field and Cursor stops at first/las field unchecked.

Phil
Tried changing all these individually, "Apply"ing the change and running the
program again. No changes to my problems but they did change the way the
keyboard was responding. None of these options effects only some types of
controls, and that's what I'm having problems with. Only some types.

I've further learned the cursor only weirds out on "masked" controls. And
example is phone number controls. All my phone number controls utilize a
mask such as !\(999") "000\-0000;;

These are the controls I'm having problems with. Or, date controls where
I've masked them. I don't mask the date control in the table itself , like
I do with the above phone number. I wait to mask date fields on the input
form, and so on date controls, I can input into the table itself through the
datasheet with no problem...but as soon as I use my input form (with the
mask for that control), the cursor will not move to the next character as
I've indicated. But, if I've masked the input in the table (like the phone
numbers), I can't input correctly even in the datasheet.

This is very strange.

I've deleted Office 2000 via Control Panel/Add Remove Programs and installed
it again and still the same problems. Even tried using a different
Office2000. Same problems

HELP, someone!?!?
ron
Phil

"Ron" <ro********************@verizon.netwrote in message
news:lq4si.7620$yg1.2038@trnddc04...
>Hi All,

I've recently installed a program written in Access 2000 on a laptop.
The laptop had an existing Office 2000 Pro which of course included
Access. But the program acts oddly (more oddly than I would have
programmed, anyway).

On everyday controls, everything acts normally. But on some controls
(and they're always the same ones) the operator can't add or change data.
Take a birthday field as an example. If the client was born on Jan 27th,
1954 you'd normally type in 1 slash 7 slash 1954. But when they type in
the 1, the position of the cursor doesn't move. It stays on the 1. So,
when they type the slash it replaces the 1 with a slash. Then the 2
replaces the slash, and the 7 replaces the 2, etc. Cursor never moves.
Now, you can type 1 and hit the right arrow and then the slash and then
the right arrow, then the 2 and right arrow, etc and it all works fine.
But to just type...they can't.

Same program doesn't operate this way on any other system I've tried it
on. And, to make it interesting, this doesn't even need to be in a form
I've designed...works the same if I just double click on the table and
try and enter or change info on the datasheet.

I installed same program on another computer that had Access 2003 on it
and it's fine. Doesn't do this. Same program on another computer with
Access 2000. No problems like this

So, is this a setting in Access 2000 somewhere that's just set in some
way for some reason and I can change it? If so, where? Or, maybe a bad
install of Access and I need to remove that one and install again?

What does anyone suggest?

TIA
ron


Aug 2 '07 #3
On Aug 1, 2:38 pm, "Ron" <ronSPAMBLOCKINGwest...@verizon.netwrote:
Hi All,

I've recently installed a program written in Access 2000 on a laptop. The
laptop had an existing Office 2000 Pro which of course included Access. But
the program acts oddly (more oddly than I would have programmed, anyway).

On everyday controls, everything acts normally. But on some controls (and
they're always the same ones) the operator can't add or change data. Take a
birthday field as an example. If the client was born on Jan 27th, 1954
you'd normally type in 1 slash 7 slash 1954. But when they type in the 1,
the position of the cursor doesn't move. It stays on the 1. So, when they
type the slash it replaces the 1 with a slash. Then the 2 replaces the
slash, and the 7 replaces the 2, etc. Cursor never moves. Now, you can
type 1 and hit the right arrow and then the slash and then the right arrow,
then the 2 and right arrow, etc and it all works fine. But to just
type...they can't.

Same program doesn't operate this way on any other system I've tried it on.
And, to make it interesting, this doesn't even need to be in a form I've
designed...works the same if I just double click on the table and try and
enter or change info on the datasheet.

I installed same program on another computer that had Access 2003 on it and
it's fine. Doesn't do this. Same program on another computer with Access
2000. No problems like this

So, is this a setting in Access 2000 somewhere that's just set in some way
for some reason and I can change it? If so, where? Or, maybe a bad install
of Access and I need to remove that one and install again?

What does anyone suggest?

TIA
ron
Have you installed the Service Packs? Help -About Microsoft Access
should show
Microsoft® Access 2000 (9.0.8961 SP-3).

Aug 2 '07 #4
Ron
Okay, installed all current service packs and updates to everything. Had no
effect. Still have the problem, as I was pretty sure would happen, since
I've never had to update/install service packs to get it to run on any other
computer I've installed it on. Of course, good idea anyway, but that wasn't
contributing to this particular problem.

Any other ideas?
ron

"lyle" <ly************@gmail.comwrote in message
news:11**********************@i13g2000prf.googlegr oups.com...
On Aug 1, 2:38 pm, "Ron" <ronSPAMBLOCKINGwest...@verizon.netwrote:
Hi All,

I've recently installed a program written in Access 2000 on a laptop. The
laptop had an existing Office 2000 Pro which of course included Access.
But
the program acts oddly (more oddly than I would have programmed, anyway).

On everyday controls, everything acts normally. But on some controls (and
they're always the same ones) the operator can't add or change data. Take
a
birthday field as an example. If the client was born on Jan 27th, 1954
you'd normally type in 1 slash 7 slash 1954. But when they type in the 1,
the position of the cursor doesn't move. It stays on the 1. So, when
they
type the slash it replaces the 1 with a slash. Then the 2 replaces the
slash, and the 7 replaces the 2, etc. Cursor never moves. Now, you can
type 1 and hit the right arrow and then the slash and then the right
arrow,
then the 2 and right arrow, etc and it all works fine. But to just
type...they can't.

Same program doesn't operate this way on any other system I've tried it
on.
And, to make it interesting, this doesn't even need to be in a form I've
designed...works the same if I just double click on the table and try and
enter or change info on the datasheet.

I installed same program on another computer that had Access 2003 on it
and
it's fine. Doesn't do this. Same program on another computer with Access
2000. No problems like this

So, is this a setting in Access 2000 somewhere that's just set in some way
for some reason and I can change it? If so, where? Or, maybe a bad
install
of Access and I need to remove that one and install again?

What does anyone suggest?

TIA
ron
Have you installed the Service Packs? Help -About Microsoft Access
should show
Microsoft® Access 2000 (9.0.8961 SP-3).
Aug 3 '07 #5


I am having the same problem as yours, the cursor will ont move to the
next character. And I discover that it works on Access 2003. Any
solution for Access 2000?

Alex

*** Sent via Developersdex http://www.developersdex.com ***
Aug 6 '07 #6
Ron
Hi Alex,

I haven't found a solution. I've uninstalled Access, then installed it
again. Same problem. I've taken the software that won't work off this
computer and put it on another computer and it works fine, so it's something
to do with this particular computer but I have NO idea what. About time to
give up and throw this computer out the window and go buy a new one I think.
The sale ads have been calling my name anyway.

Hang in,
ron

"Alex Lau" <al********@hotmail.comwrote in message
news:46*********************@news.qwest.net...
>

I am having the same problem as yours, the cursor will ont move to the
next character. And I discover that it works on Access 2003. Any
solution for Access 2000?

Alex

*** Sent via Developersdex http://www.developersdex.com ***

Aug 7 '07 #7
On Aug 7, 10:02 am, "Ron" <ronSPAMBLOCKINGwest...@verizon.netwrote:
Hi Alex,

I haven't found a solution. I've uninstalled Access, then installed it
again. Same problem. I've taken the software that won't work off this
computer and put it on another computer and it works fine, so it's something
to do with this particular computer but I have NO idea what. About time to
give up and throw this computer out the window and go buy a new one I think.
The sale ads have been calling my name anyway.

Hang in,
ron

"Alex Lau" <alexlau...@hotmail.comwrote in message

news:46*********************@news.qwest.net...


I am having the same problem as yours, the cursor will ont move to the
next character. And I discover that it works on Access 2003. Any
solution for Access 2000?
Alex
*** Sent via Developersdexhttp://www.developersdex.com***- Hide quoted text -

- Show quoted text -
Have you applied all of the Windows updates to the laptop? Have you
compared all (and I do mean all) of the Regional and Language options
in control panel on both computers? This is a shot in the dark but I
can't help but wonder if region/language settings might have something
to do with the problem. Let us know what you find out.

Bruce

Aug 7 '07 #8


Hi Ron,

I have fixed the problem already. The problem is casued by the IME
stuff. I don't know what input language you have installed in your
computer. Maybe you can have a try at changing the input language when
you input the data. It works fine to me. I hope it will help you.

Alex

*** Sent via Developersdex http://www.developersdex.com ***
Aug 8 '07 #9
Ron
Hiya Bruce,

Yup, this did the trick. The previous user set it up to use a secondary
language that included Chinese characters. Once those were eliminated from
the Code Page Conversion Tables, it works like a champ.

Thanks,
ron

"Bruce" <de***************@gmail.comwrote in message
news:11**********************@k79g2000hse.googlegr oups.com...
On Aug 7, 10:02 am, "Ron" <ronSPAMBLOCKINGwest...@verizon.netwrote:
>Hi Alex,

I haven't found a solution. I've uninstalled Access, then installed it
again. Same problem. I've taken the software that won't work off this
computer and put it on another computer and it works fine, so it's
something
to do with this particular computer but I have NO idea what. About time
to
give up and throw this computer out the window and go buy a new one I
think.
The sale ads have been calling my name anyway.

Hang in,
ron

"Alex Lau" <alexlau...@hotmail.comwrote in message

news:46*********************@news.qwest.net...


I am having the same problem as yours, the cursor will ont move to the
next character. And I discover that it works on Access 2003. Any
solution for Access 2000?
Alex
*** Sent via Developersdexhttp://www.developersdex.com***- Hide quoted
text -

- Show quoted text -

Have you applied all of the Windows updates to the laptop? Have you
compared all (and I do mean all) of the Regional and Language options
in control panel on both computers? This is a shot in the dark but I
can't help but wonder if region/language settings might have something
to do with the problem. Let us know what you find out.

Bruce

Aug 8 '07 #10

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

Similar topics

11
4394
by: Wayne Wengert | last post by:
I am using VS.NET 2003, VB.NET, ADO.NET and an Access 2000 database. I want to display a list of all tables in an Access database. I want to put that list of table names in a listbox so the user...
13
3777
by: Wolfgang Kaml | last post by:
Hello All, I have been researching newsgroups and knowledgebase all morning and not found a solution that would solve the problem I have. I am having an ASP or ASPX web page that implement a...
3
2334
by: Steven Fox | last post by:
============================================================ About DB2 Administration Tools Environment ============================================================ DB2 administration tools level:...
0
1309
by: Ruth Craig | last post by:
We recently upgraded some of our department's machines from WINNT to Windows 2000. Up until this point, we were running Access 2000 on WINNT and had no problems with our databases. After the...
4
3930
by: D | last post by:
I've created a report with many subreports of aggregate data. I want my client to be able to export this data to Excel to make her charts, etc. Only one problem: one of the fields is a "SchoolYear"...
2
1329
by: Wayne Aprato | last post by:
The following problem seems to manifest itself in Access 2000, but I have not experienced it with Access 97. When I make a duplicate of a form before I make design changes to that form that I...
4
5389
by: Mal | last post by:
I have an ACC 2000 database that has a strange behaviour I have a small table, with just a few fields... My report has very simple grouping and sorting, no code bar a NODATA event. I have a...
1
3364
by: Badboy36 | last post by:
Hello user from googlegroups, i made a microsoft access database with front and backend. i created the backend in microsoft access97. for the frontend i made two versions (one for microsoft...
13
13229
yolenman
by: yolenman | last post by:
Hello - This is my first posting to this group, so please bear with me. Also note, that while I'm intelligent, databases are not in my field of knowledge. I'm working with a small limousine...
0
7121
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,...
0
7162
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
7197
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
7375
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...
0
5456
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
1
4899
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...
0
3078
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
1411
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 ...
1
650
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.