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

cant change datatype to hyperlink cause of linked table - how to open link?

P: 1
I have a linked table with some URL's in it. I need the table to stay linked but i cant get the hyperlinks to work in my form unless I change the datatype in access to hyperlink. I cant change the datatype becuause the table is linked. Any Ideas ? I realise probaly an on-click event but i ama way newbie !
May 18 '12 #1
Share this Question
Share on Google+
2 Replies

Expert Mod 15k+
P: 31,419
You want it, but you know you can't have it, but you want to know how to get it anyway? Strange question. If you want a hyperlink then make it a hyperlink if you can. If you can't then, well, you can't.
May 19 '12 #2

P: 759
Try to use a temporary table with a field as you need (hyperlink).
Fill this table with hyperlinks from the original table then use this table as record source for your form.

I know: This approach involve a lot of knowledge in Access and in VBA.
May 19 '12 #3

Post your reply

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