[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 550
  • Last Modified:

access 2007, vba checkbox to delete multiple records

how do i add to access table checkbox(and use datasheet or table) to delete multiple records
0
ahashash
Asked:
ahashash
1 Solution
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
As an example, if your checkbox is bound to a field named 'ckDelete':

Currentproject.Connection.Execute "DELETE * FROM YourTable WHERE ckDelete = True"

0
 
ahashashAuthor Commented:
perfect
0

Featured Post

NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now