Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Hyperlink in Outlook that opens a Form in Access

Posted on 2002-07-03
5
Medium Priority
?
300 Views
Last Modified: 2010-04-08
I want to create a hyperlink in Outlook, oh no, not any hyperlink, but one that is able to Open a Form inside of an Access database. First of all is this possible? and if Yes, HOW?
0
Comment
Question by:CyberAccess
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 16

Expert Comment

by:Neo_mvps
ID: 7128602
programmatically....

user clicks a button or label and your click event does something like....

set objOutlook = CreateObject("Outlook.Application")
set objNamespace = objOutlook.GetNamespace("MAPI")
objNamespace.Logon "","", False, False

set colItems = objNamespace.GetDefaultFolder(4).Items
set objMsg = colItems.Add ("IPM.Note.Custom.Message.Class.Company")
objMsg.Display
set objMsg = Nothing
set colItems = Nothing
objNamespace.Logoff
Set objNamespace = Nothing
Set objOutlook = Nothing

0
 

Author Comment

by:CyberAccess
ID: 7137554
That is not what I am trying to do. I want to be inside of Outlook, and have a hyperlink in Outlook that opens a form in my Access database.
0
 
LVL 16

Accepted Solution

by:
Neo_mvps earned 600 total points
ID: 7137675
Then you would do something like this in VBScript behind an Outlook form.

Dim oAccess
Set oAccess = CreateObject("Access.Application")
oAccess.OpenCurrentDatabase "C:\database\TestDatabase.mdb"
oAccess.DoCmd.OpenForm "Test Form"
oAccess.Visible = True

0
 

Author Comment

by:CyberAccess
ID: 7138945
Thanks, I think i can handle the rest from here. You have helped me get a jump on things and Im off to a good start. Check back for more points because i might have more questions in the near future. Thanks Again.
0
 
LVL 16

Expert Comment

by:Neo_mvps
ID: 7139217
your welcome... and i usually do check back often. ;)
0

Featured Post

Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
The core idea of this article is to make you acquainted with the best way in which you can export Exchange mailbox to PST format.
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…

610 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question