Good day,Please am having a database of cooperative society; with monthly contributions from their salary to cooperative account. Instead of manually updating for each month how do I program my database to automatically update.I don't know anything about VBA.
Automatically updating records
- Thread starter brodaman
- Start date
Ranman256
Well-known member
- Local time
- Today, 09:41
- Joined
- Apr 9, 2015
- Messages
- 4,354
you dont need vba. Make an update query to update many records at once.
if you want to pick and choose the ones to update for the query, dbl-click from a list box,this runs an append query to a 'chosen' table.
The update query will link to this to update the main table.
All done with querys or macros. no vba.
see photo:
if you want to pick and choose the ones to update for the query, dbl-click from a list box,this runs an append query to a 'chosen' table.
The update query will link to this to update the main table.
All done with querys or macros. no vba.
see photo:
