How to use VBA or macros to set the size of the access database window and possibly its location on the desktop?
How to use VBA or macros to set the size of the access database window and possibly its location on the desktop?
Non comprende. Lo siento.
Please use # icon on toolbar when posting code snippets.
Cross Posting: https://www.excelguru.ca/content.php?184
Debugging Access: https://www.youtube.com/results?sear...bug+access+vba
:-) sorry
How to use VBA or macros to set the size of the access database window and possibly its location on the desktop?
Do not know TBH.
You can maximise and restore
https://www.youtube.com/watch?v=S2tMFJ0x-5E
I *think* would need a windows API for that as it is just a window, but that is just a guess.
Perhaps not?
https://learn.microsoft.com/en-us/of....window.resize
Found via ....
https://www.google.com/search?q=vba+...t=gws-wiz-serp
Edit: Access does not have an ActiveWindow property?![]()
Please use # icon on toolbar when posting code snippets.
Cross Posting: https://www.excelguru.ca/content.php?184
Debugging Access: https://www.youtube.com/results?sear...bug+access+vba
After some time I came back to the problem, surprisingly after a short haggling I managed to get a satisfactory result from chatGPT :-)
Code:Private Declare PtrSafe Function MoveWindow Lib "user32" (ByVal hwnd As Long, ByVal x As Long, ByVal y As Long, ByVal nWidth As Long, ByVal nHeight As Long, ByVal bRepaint As Long) As Long Private Sub Details_Click() Dim hwndAccess As Long hwndAccess = Application.hWndAccessApp MoveWindow hwndAccess, 10, 10, 1000, 1000, True End Sub
maybe this would be of interest?
https://isladogs.co.uk/control-appli...ace/index.html
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.