Does someone know the VBA code to remove the data form a Numeric (Long) field ?
Novice
Windows 10 
Access 2010 64bit
Does someone know the VBA code to remove the data form a Numeric (Long) field ?
VIP
Windows 11 Access 2021
Could use an UPDATE action SQL to remove data from a field. VBA can execute this action.
CurrentDb.Execute "UPDATE tablename SET fieldname = Null"
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Using a numeric value result from a query in VBA Code
IIf - if value in field A is zero use column B content, otherwise content of field A
Posting Permissions
Reply With Quote