#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 interface rather than the Access tables.
Method 1, Manual Update:
One method would be to manually update the tables values. This can done by either one of the methods below:
- Pressing F5
- Pressing Shift+F9
- Closing and reopening the access database
Note: This is a manual method, not VBA.
Method 2, Using Forms and Requery Function:
In this method, we use a datasheet form, rather than the table itself:
Datasheet forms are forms that look like an Access table. We can then use the forms Requery function to update its values:
Form_MyTable1.Requery
Note: The
object needs to be created. For more information on this please see the link below:Form_MyTable1
See also:
If you need assistance with your code, or you are looking for a VBA programmer to hire feel free to contact me. Also please visit my website www.software-solutions-online.com