Ok I found the solution here with a couple of added steps that I took to make it work with reports. This was working fine but report windows were also getting minimized.
I called this function on the On Load event of the main start up form. I also did the following:
1. This puts the access app and puts it in the middle of the screen and to make sure that the users dont see it, I changed the 'Movable' property of the main startup form to 'No' so the minimized database application window sits behind the form.
2. For reports - the reports were also getting minimized on the middle of the screen and also it seemed like not all data was visible. I thought it needed to be refreshed so I added:
