Access AddToFavorites Method Example

AddToFavorites Method – the Add To Favorites method adds the name of the current database to the Favorites folder.  When applied to a Control object, the AddToFavorites method adds the hyperlink address contained in a control to the Favorites folder.

The Add To Favorites method has the same effect as clicking AddToFavorites on the Favorites menu on the Web toolbar when view a page on the internet.
Here is an example of adding to favorites the hyperlink contained in a control field on a form:

We add our Blue Claw Database Design URL to the field called Field1 on the form.  This happens when the form loads in the Form Load event.  You could also allow the user to type in the hyperlink address or select it from a list.

Private Sub Form_Load()
Me!

Field1.HyperlinkAddress = “https://blueclawdb.com/”
End Sub

Next, we add the link to our favorites list when the user clicks the Field1 hyperlink.

Private Sub Field1_Click()
Me!Field1.Hyperlink.AddToFavorites
End Sub

 

Microsoft Office VBA, MS Access 2003, 2007, 2010, 2013, 2016