Screen Position of File Open/Save dialog box

[Danick]

I'm using Ken Getz ahtCommonFileOpenSave API: Call the standard Windows File Open/Save dialog box.

http://access.mvps.org/access/api/api0001.htm

This works great and does exactly what I need. But the dialog box positions itself at the bottom right hand corner of the screen.

Is there anyway to DoCmd.MoveSize the dialog box to a better location?

Thanks

 

[sneuberg]

I'm curious as to why you need to use this instead the FileDialog described in https://msdn.microsoft.com/en-us/library/office/ff196794.aspx

I've attached a database which has a class module in it name clFormWindow which I used to position and size a form in it's form load. Maybe you can use that.

 

[Danick]

I'm curious as to why you need to use this instead the FileDialog described in https://msdn.microsoft.com/en-us/library/office/ff196794.aspx

I've attached a database which has a class module in it name clFormWindow which I used to position and size a form in it's form load. Maybe you can use that.

I'm using Access 2003

 

[Danick]

If anyone else is trying to figure this out, I found this code that seems to be doing what I am trying to do. But now that I understand it, I may just keep the original code from Ken Getz and modify the FileDialogHook which seems to just place the dialog box where the curser was when the cmd button was pressed. Brilliant!!

http://stackoverflow.com/questions/...rt-position-for-openfiledialog-savefiledialog