Run Update or Delete in MS Access SQL

PHOTO

Wed May 25 2022 11:53:37 GMT+0000 (UTC)

Saved by @paulbarry

Dim dbs As DAO.Database
Dim lngRowsAffected As Long
Dim lngRowsDeleted As Long

Set dbs = CurrentDb

' Execute runs both saved queries and SQL strings
dbs.Execute cstrQueryName, dbFailOnError

' Get the number of rows affected by the Action query. 
' You can display this to the user, store it in a table, or trigger an action 
' if an unexpected number (e.g. 0 rows when you expect > 0).
lngRowsAffected = dbs.RecordsAffected
  
dbs.Execute "DELETE FROM tblMyTable WHERE Bad", dbFailOnError
lngRowsDeleted = dbs.RecordsAffected

Update or Delete MS Access SQL

https://www.fmsinc.com/microsoftaccess/query/action-queries/SuppressWarningMessages.htm

Save snippets that work from anywhere online with our extensions

Available in the Chrome Web Store

Get Firefox Add-on

Get VS Code extension

Comments

More like this

VBA

@paulbarry

Regex for Access Build Pass through query using Regex to replace Form fields in query VBA to auto Refresh Linked Table Manager or linked tables - Microsoft Access / VBA QUESTION: Get All Procedure Names from Modules | Access World Forums MS Access DLookup Example MS Access Logging Split String or Text Run Update or Delete in MS Access SQL Access VBA custom Function to count substring in string Code to loop through all records in MS Access how-to-filter-an-existing-recordset check-if-textbox-is-empty http://azlihassan.com/apps/articles/visual-basic-for-applications-vba/vba-check-valid-email Email verification Use Temporary tables for quick analysis https://www.access-programmers.co.uk/forums/threads/setting-a-group-of-controls-visible-hidden-or-enabled-disabled.293412/ Templete For Notes Field - Hide on empty and display only when there is text. Filename with spaces running WScript.Shell how-pass-variable-one-form-another-form

Browse more snippets >>