Tag Archives: Requery

#Deleted Text in Tables, VBA Access

If you are working directly with Access tables in VBA and attempt to delete records, the records will be replaced by a #Delete text. There are 2 workarounds to fix this: Method 1: User manually updates the table Method 2: Using userforms as the user

No Thumbnail

VBA Access Table Not Updating

When modifying access table using VBA, there are times the values being displayed in the table will not update. There is no direct VBA solution to update the values the table is displaying, but there are 2 workarounds: Method 1: User manually updates the table