Getting Outlook Calendar into my Access 2016 database

[LeonS]

The title says it all! I have an Access 2016 database and it has various facilities that are opened with a button. I want to add another button which will show a working copy of Outlook Calendar. Thank you.

[Welshgasman]

The title says it all! I have an Access 2016 database and it has various facilities that are opened with a button. I want to add another button which will show a working copy of Outlook Calendar. Thank you.

I normally start here https://www.google.com/search?q=connect+access+database+to+outlook+calend ar&rlz=1C1CHWL_enGB942GB942&oq=link+access+db+to+o utlook&aqs=chrome.3.69i57j0i22i30l3.9180j0j4&sourc eid=chrome&ie=UTF-8


However I only have 2007, and strangely it does not allow access to the Outlook Calendar, but does to the Google calendar I have linked in Outlook.

Of course presentation is up to you? Mine is just a table, but you could use with DaveGri's calendar on this site to populate.?

Edit: My linked calendar does not show actual dates of events?, so no good to man or beast.

[LeonS]

Wonderful!! On reading the material you sent, I also looked at some of my existing code. I created a Macro based on some other macros. I used the RunApplication with a command line of # "outlook.exe /select outlook:calendar" #. and that opened Outlook and took me straight to the Calendar page. Brilliant. So, again, Thank You !!!

[Welshgasman]

I know. What did we ever do before Google

Someone, somewhere has had the problem before you. However I thought you wanted the calendar IN Access, not just be able to change to Outlook.?

BTW the # is meant to be the # in the toolbar, which makes a code block, so code is easily read. Like this

"outlook.exe /select outlook:calendar"

You are the second person to read it that way. I will need to change my signature and try and make it clearer.

[LeonS]

Sorry for getting the # wrong!! I think it would be good to have Outlook in my database, but this is the next best thing. I can open Outlook, while I am in my database, mark the appointment, and then return to my database. Easy - I hope!!
I do have another query, with which you may be able to help. Within a form I have a button to Find, this case, a Salutation. Works perfectly!! I want to find everyone called David - and it produces a list of all the Davids. And down in the bottom left-hand corner there are the arrows to take me through the list. Excellent. But how do I get back to my main database? I seem to be stuck on the list of Davids. Lechyd Da!
This is the current script:
Private Sub Command212_Click()


Dim S As String

S = InputBox("Please enter Salutation", "Salutation", Salutation)
If S = "" Then Exit Sub

Me.Filter = "Salutation LIKE ""*" & S & "*"""
Me.FilterOn = True


End Sub

[Welshgasman]

You at least set the filter off.
You can clear the filter as well to be tidy/ultra safe.

Me.Filter = ""
Me.FilterOn = False

Can also use the Menu options to clear the filter, but I tend to have small button with the clear filter icon that Access produces.