How Can I delete a Single Record in DataSheet View

[mkkashif]

Hello Dear Sir
How Can i Delete a record in a datasheet view.
i mean if we want to delete a single record.i have to right click on beging of record then push the delete from menu and after that a msg appear.or select the record and press delete the keyboard.

My """""Question """""
i don't want to use the mouse in upper cases i have to use the mouse.
how can i select a record with single button by keyboard and delete it.i want to delete the record with single button press don't want to use the mouse.and don't want a message.
Any Help will Greatly Appreciated

 

[mkkashif]

No Can Guide Me

Hello Dear Sir
How Can i Delete a record in a datasheet view.
i mean if we want to delete a single record.i have to right click on beging of record then push the delete from menu and after that a msg appear.or select the record and press delete the keyboard.

My """""Question """""
i don't want to use the mouse in upper cases i have to use the mouse.
how can i select a record with single button by keyboard and delete it.i want to delete the record with single button press don't want to use the mouse.and don't want a message.
Any Help will Greatly Appreciated

 

[Ukraine82]

You can make 2 command buttons by using the wizard.

First button will be the find record.

Second button will be the delete record.

hth,

Michael

 

[mkkashif]

No Can Guide Me

i think it is not answer of my question

 

[Ukraine82]

Are you talking about deleting a specific record in a form?

Michael

 

[mkkashif]

i have got the Problem

i want to select a single record in the datasheet view .
the way is to shift+spacebar.
to select a single record.
is there any way to do that by custom key.
i mean to do that by my own code and by single key.is this posible.
to assign the Shift+SpaceBar key with custom keys.

 

[Pat Hartman]

The problem is identifying WHICH record you want to delete as Ukraine82 suggested. How would you do that? The RecordSource for your subform may contain 100's of records. How will Access know which one you want to delete if you don't point to it with the mouse or select it with some other method?

 

[Ukraine82]

I'm sorry I can't really help you with that. I hope somebody here can help you out.

sorry,

Michael