query not showing in form design selection with command button

[skunkworks]

When creating a command button in form design, a delete query does not show. The other query is visible.

[June7]

I just tested this and DELETE query shows up for me. If you want to provide your db for analysis, follow instructions at bottom of my post.

[CJ_London]

works for me as well - perhaps the delete query is wrong in some way

[skunkworks]

Here is db.

[Welshgasman]

All you need for qry1 is

DELETE tbl1.*
FROM tbl1;

You have WHERE in all the columns for the Delete row.?
Despite that the query ran and deleted the records.

DELETE tbl1.author, tbl1.[last-month], tbl1.[this-month], tbl1.adj, tbl1.due, tbl1.[send-report], tbl1.country, tbl1.[hold-pmt], tbl1.method, tbl1.fee
FROM tbl1;

[skunkworks]

Welshgasman the query was originally created as you showed. It was changed to see if that would make a difference. The query works fine in either instance, but the issue with the form persists.

[CJ_London]

works for me


Suggest start again, create a new form

[skunkworks]

After doing a compact and repair and creating a new form, the result is the same. Strange. Is there a workaround to accomplish the following?
delete records in tbl1
use saved import to append records to tbl1
run qry 2
run saved export (not yet created) in Excel format

[Welshgasman]

You could try the sql in VBA?
I like @CJ_London can also see qry1 even after downloading the file again.

Something screwy with your system.
Try a repair of Office. Try an import into a new DB first perhaps?

[CJ_London]

Is there a workaround to accomplish the following?
delete records in tbl1
use saved import to append records to tbl1
run qry 2
run saved export (not yet created) in Excel format

i don't use macros, too limiting - but if you are you can edit them. so for your missing query, choose the other one, then edit the macro
I don't see a saved import, but that would be an append query, not an update query (per your qry2?) - again use the wizard to create the macro
same for your qry2
Don't know what you mean by 'saved export in excel format' - but check out how you might do this with the macro builder

Or you can do it with one click using vba

currentdb.execute "name of query1"
currentdb.execute "name of query2"
currentdb.execute "name of query3"

[skunkworks]

VBA is above my pay grade, but I'll try the macro approach. Thank you!

Thanks to everyone who contributed!

[Welshgasman]

VBA is above my pay grade, but I'll try the macro approach. Thank you!

Thanks to everyone who contributed!

Well, give yourself a rise.
It will serve you much better in the future. You now have ChatGPT and the like. You can Google and use YouTube.
Plenty of help out there. You just have to use it.