Deleting a module in remote database using vba is working using this code :
BUT... I wont know what last 3 characters will be in the module name "tools-for_all_db_123" . I would like to delete the module starting with "tools-for_all_db"
Thanks all!
Code:
Dim objAcc As Access.Application
Set objAcc = GetObject("\\grh503\Electronics\database_programs\z_rest_of_em\tools\golive\GoLive.accdb")
objAcc.DoCmd.DeleteObject acModule, "tools-for_all_db_123"
objAcc.Application.Quit
Set objAcc = Nothing
BUT... I wont know what last 3 characters will be in the module name "tools-for_all_db_123" . I would like to delete the module starting with "tools-for_all_db"
Thanks all!