Forum Discussion
How to make a Saved Export
Hello All, My very first post in the MS-Access lounge. I need to automate these steps: Press F-11 to get to the All Access Objects pane. Select a Table named Priority The Priority table has a D...
This can be done with a query (e.g. "PriorityToday") that has a where clause for the current date. Change Datefield to internal date name in table Priority:
SELECT * FROM Priority WHERE [Datefield] = Date();
Export "PriorityToday" as an Excel workbook (right-click menu). On the last page of the export wizard, name a new Saved Export. If you wish, create an Outlook Task.
Done.
By the way, allowing MS Access but not VBA does not make sense to me.