By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,099 Members | 2,156 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,099 IT Pros & Developers. It's quick & easy.

Email with Hyperlink - Click to open specific record

P: 11
Hello,

I am in a tough situation... I am working on a database and now I have a hard hurdle to finish my database.

I have a form from which I am able to send a record for approval. Where approval will be through email reply. Now I want to change it to electronic way:

- First send an email to user with a link
- either link should pass the Approved / Rejected word to access table in the server or link should contain path when clicked, access should be opened with specific form and record.

I believe, passing the Approved / Rejected word to access table is very complicated ... if this can be done, it will be excellent ... else at least I should be able to get the other solution worked out ...

Please help me if anyone have any other solutions or work around for my issue...

Thanks in advance...

Regards,
Sri
Aug 6 '12 #1
Share this Question
Share on Google+
10 Replies


Rabbit
Expert Mod 10K+
P: 12,366
You can't do this without creating a web interface.
Aug 6 '12 #2

P: 11
Oh!!! I have come across a link which I believe is some solution for the same. But I could not understand the concept.

http://msgroups.net/microsoft.public...om-email/62542

May be if you check the link, you can help me with the issue...
Aug 7 '12 #3

Rabbit
Expert Mod 10K+
P: 12,366
That won't work. It'll work as a batch command. But it doesn't work as a link.
Aug 7 '12 #4

P: 11
Okay Rabbit ... Do you suggest any better way to get my requirement done?
Aug 7 '12 #5

100+
P: 332
Check this. I don't think it contains complete solution but it might inspire you and make you realize that web interface is the way to go.
http://bytes.com/topic/access/answer...em-link-access.
Aug 7 '12 #6

Rabbit
Expert Mod 10K+
P: 12,366
If by requirement you mean the hyperlink, there's no way to do it.
Aug 7 '12 #7

zmbd
Expert Mod 5K+
P: 5,397
As Rabbit said, you'll need a web interface, sharepoint, etc...

Not sure why you'd like to change; however, if you have 2007/2010 then you might look at: http://office.microsoft.com/client/h...2D8a79e8b74b99
This goes over getting the information back thru the email and could be easier to impliment than what you're considering.

-z
Aug 7 '12 #8

P: 11
Thanks Z ...

I tried this option yesterday... it is good to use ... but is there a way to do this in VBA?

Because, the users are not well aware of access and they may mess-up...
Aug 8 '12 #9

zmbd
Expert Mod 5K+
P: 5,397
Wow...
I'd thought that this would be easier to implement; however, I had to go and do some massive digging on this feature. Apparently, MS didn’t have the foresight (or anticipate) that actual developers might want to use this to actually do something useful for end-users.

HOWEVER ( :) )
With much digging and reading…
“This is not of the faint-of-heart”
http://blogs.office.com/b/microsoft-...using-vba.aspx
http://us.generation-nt.com/answer/d...207748511.html

So… it sounds like there are a few steps and a lot of code but this should put you on the right track…

-z
[edit= 20120808_0943]
Windows-7 found "AccessDCActionFile.xml" file located at
"%userprofile%\AppData\Roaming\Microsoft\Acces s"
[/edit]
Aug 8 '12 #10

zmbd
Expert Mod 5K+
P: 5,397
Found a book with some information about this too:
http://books.google.com/books?id=61P...ection&f=false
Aug 8 '12 #11

Post your reply

Sign in to post your reply or Sign up for a free account.