I am working at the same issue. You can sync Outlook with google calendar, see youtube. If you set an appointment or task in Outlook ( with vba) it will sync automatically with G Calendar. We can work on it together? There is not si much info about using the api with vba. But that’s un option to.
You can use excel as report and enter the data in Access. You can name a range or A Cell in excell and write the data straight from Access to this named range or cell. It’s nit much code with vba. I can make it for you. You can also read the data from the excel sheet into Access. I can make it...
I installed vba-web from github. I think the included a new reference to "Visual Basic For Applications". In the vbe editor of ms access - Tool References - I find 3 times a Reference for "Visual..." all 3 with the same name but with a different path. I can't uncheck the current reference...