Delete a record from a table

[UT227]

I have a form with a list box [lstAttachedFiles]. I want to delete the record from the list box. I looked up a code: Docmd.Execute "DELETE * FROM tblTrainingAttachment WHERE ScheduleID = Me.lstAttachedFiles"
It took me to the debugger where it just highlighted the .Execute. Is there a way to make a button to do this?

[JoeM]

Try:
Docmd.RunSQL "DELETE * FROM tblTrainingAttachment WHERE ScheduleID = " & Me.lstAttachedFiles
instead.

See: https://docs.microsoft.com/en-us/off...s.docmd.runsql

Note that your variable has to be outside of the quotes, or else it will be treated as literal text.
This is assuming that you ID field is numeric. If it is text, you will need to add single quotes, i.e.
Docmd.RunSQL "DELETE * FROM tblTrainingAttachment WHERE ScheduleID = '" & Me.lstAttachedFiles & "'"

[UT227]

That worked perfectly. Thanks. Is there a way to delete the file from the server also? I have 2 text boxes to show where the file on the server is: [txtFolderPath] and [txtFileName]. Not only does the record need to be deleted from the database, but the file needs to be deleted from the server. Is there a way to do that also?

[Gicu]

Use Kill [txtFolderPath] & "" & [txtFileName]

https://docs.microsoft.com/en-us/office/vba/language/reference/user-interface-help/kill-statement
Cheers,

[UT227]

Perfect. Thanks a lot.

[UT227]

I just thought of something. If the user changes his mind when Access asks if he wants to delete the file. The way I have it set up, it will delete it anyway. I just added the KILL code just after the DELETE code. How would I not kill the file on the server if he clicks on NO?

[UT227]

After a little thought, seems that I turn off the warnings and make my own Yes/No box and put the command there. Amazing what a cup of coffee with help with.