By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,896 Members | 1,997 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,896 IT Pros & Developers. It's quick & easy.

Problem with Access 2000 or ?????

P: n/a
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
Share this Question
Share on Google+
9 Replies


P: n/a
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

P: n/a
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

P: n/a
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

P: n/a
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

P: n/a


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

P: n/a
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

P: n/a
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

P: n/a


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

P: n/a
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 discussion thread is closed

Replies have been disabled for this discussion.