keyboard shortcut to 'select' a record

G

Gilbert 2097

Using Access2003 - I want the user to be able to delete an entry (record)
from a continuous form - I have the record selectors down the left side and I
can iterate through them using tab or down arrow but I can't actually select
one until I click on it with the mouse and then press delete. I have some
older folks that are totally ignorant when it comes to using a mouse so is
there a way to actually select a record with a keyboard shortcut so that the
record selector on the left turns black?? I hope I have explained my problem
sufficiently.
Thanx
 
R

RoyVidar

Gilbert 2097 said:
Using Access2003 - I want the user to be able to delete an entry
(record) from a continuous form - I have the record selectors down
the left side and I can iterate through them using tab or down arrow
but I can't actually select one until I click on it with the mouse
and then press delete. I have some older folks that are totally
ignorant when it comes to using a mouse so is there a way to
actually select a record with a keyboard shortcut so that the record
selector on the left turns black?? I hope I have explained my
problem sufficiently. Thanx

Try

Shift + Space
 
G

Gilbert 2097

Thanx for the response Roy. When I open the continuous form by itself the
shift + Space works OK to select a record, but when I open it from another
form using a where clause to limit records I get the little pencil
dot,dot,dot in the record selector instead of it turning black. I don't
know why it would act differently when being opened from another form; I can
still click on it with the mouse and select the record but the shortcut
doesn't work. Anybody got any ideas or explanation?? Thanx,
 
R

RoyVidar

Gilbert 2097 said:
Thanx for the response Roy. When I open the continuous form by
itself the shift + Space works OK to select a record, but when I
open it from another form using a where clause to limit records I
get the little pencil dot,dot,dot in the record selector instead of
it turning black. I don't know why it would act differently when
being opened from another form; I can still click on it with the
mouse and select the record but the shortcut doesn't work. Anybody
got any ideas or explanation?? Thanx, --
Gil

It seems that if you're alredy editing a control value, or you have
the cursor within a control (without the whole control being selected),
that this may occur.

Perhaps you could make your own shortcutkey, or ensure the Shift +
Space combination works - i e in the keydown event (air code).

if ((shift and acshiftmask) = acshiftmask) then
if (keycode = vbkeyspace) then
docmd.runcommand accmdselectrecord
keycode = 0
end if
end if
 
G

Gilbert 2097

Thanx again Roy, I hadn't used the acCmdSelectRecord yet, but it looks like
what I need - I'll have to tinker with it a bit....Thanx again,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top