Delete multiple rows in one step (1 Viewer)

[sibbbra]

When I select multiple rows I want my delete button in the form to delete all the records I have selected. It just ends up deleting the row selected at first.
That doesn't choose all the selected entries. Any way to select all rows and delete in a single step. SQL is as:

SELECT [Line gen].Order_ID, [Line gen].Order_Date, [Line gen].Customer_ID, [Line gen].Voucher_ID, [Line gen].Customer_Name, [Line gen].Delete
FROM [Line gen];

kindly help !

 

[Eugene-LS]

If I understand you correctly, it's like this

Dim sVal$
    sVal = "Delete FROM [Line gen] WHERE ([Line gen].[Delete]=True);"
    CurrentDb.Execute sVal

 

[arnelgp]

are the records you want to delete in subform?
you can add timer to your subform to save the current PK number and the SelHeight (number of selected).
add 1 hidden textbox to your main form.

on the subform's timer event, save the pk(s) selected rows to the hidden textbox.

see this demo.

 

[Mike Krailo]

That's an interesting demo Arnel, but isn't that limiting using a datasheet instead of a listbox where you could make multiple selections anywhere in the list first? The current subform only allows contiguous records to be selected.

 

[arnelgp]

That's an interesting demo Arnel, but isn't that limiting using a datasheet instead of a listbox where you could make multiple selections anywhere in the list first? The current subform only allows contiguous records to be selected.

the OP did not mention any listbox.
i think it is fairly easy if that is the case.

 

[Mike Krailo]

The other way would be to mark the selected records with a checkbox in a regular form.

 

[sibbbra]

are the records you want to delete in subform?
you can add timer to your subform to save the current PK number and the SelHeight (number of selected).
add 1 hidden textbox to your main form.

on the subform's timer event, save the pk(s) selected rows to the hidden textbox.

see this demo.

thanx but there is error comin at
CurrentDb.Execute sVal

 

[Eugene-LS]

thanx but there is error comin at

Show what variable sVal contains please

 

[sibbbra]

nothing helped yet i am attaching db

 

[sibbbra]

Show what variable sVal contains please

i have attached file. plz help

 

[sibbbra]

see my db

Show what variable sVal contains please

 

[Eugene-LS]

i have attached file. plz help

If you had started by publishing an example, there would have been a solution a long time ago...
...
Here you are.

 

[sibbbra]

If you had started by publishing an example, there would have been a solution a long time ago...
...
Here you are.

Thanx !
I have no proper words to thank u. and how can I select all the checkboxes with say a button, What should I do?

 

[Eugene-LS]

and how can I select all the checkboxes with say a button, What should I do?

See below please

 

[sibbbra]

So kind o u

Eugene-LS​

I shall pray to God ......for u certainly......... !

 

[Eugene-LS]

I shall pray to God ......for u certainly......... !

You'd better press the "Like" button at least once

 

[Mike Krailo]

I'll do it Eugene.

 

[sibbbra]

But when I filtered the results based on criteria in query, all records are selected, instead of filtered ones, how to achieve that...I just want to delete the filtered and thenselected results. plz

 

[Eugene-LS]

@sibbbra
File below ...

 

[sibbbra]

This is the best access forum in the world, no doubt