In VBA if I start an Access.Application, open a database (with OpenCurrentDatabase) and open a report in design mode, then make changes manually and exit, there is no prompt to Save. But it does save the changes.
If I open the same database by double-clicking in File Explorer and change the report design, it does prompt to save.
It's the same for the design of a table.
It's nothing to do with setwarnings=true - tried with & without.
My simplified code is below.
Dim accobj As Access.Application
Set accobj = New Access.Application
accobj.Visible = True
accobj.OpenCurrentDatabase dbname, True
accobj.DoCmd.OpenReport repname, acViewDesign
I've also tried it with :
Set accobj = CreateObject(Access.Application)
Any help please. Access settings somewhere? Thanks
If I open the same database by double-clicking in File Explorer and change the report design, it does prompt to save.
It's the same for the design of a table.
It's nothing to do with setwarnings=true - tried with & without.
My simplified code is below.
Dim accobj As Access.Application
Set accobj = New Access.Application
accobj.Visible = True
accobj.OpenCurrentDatabase dbname, True
accobj.DoCmd.OpenReport repname, acViewDesign
I've also tried it with :
Set accobj = CreateObject(Access.Application)
Any help please. Access settings somewhere? Thanks
