Dear all,
Is it possible to change via code the default view (pivot, datasheet, etc) of a query in autoexec ?
This post is relevant to post and a possible workaround:
https://www.accessforums.net/queries...vot-50801.html
Dear all,
Is it possible to change via code the default view (pivot, datasheet, etc) of a query in autoexec ?
This post is relevant to post and a possible workaround:
https://www.accessforums.net/queries...vot-50801.html
In VBA:
DoCmd.OpenQuery "queryname", acViewPivotTable
I suppose macro has equivalent.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.