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

.hyperlink information from within a subform

P: 4
Hi Everyone,

I have just created a hyperlink from within a simple form that I have to pull and open a PDF file that matches with a customers order.

My code is below:

FollowHyperlink "\\Frontdesk\FrontDesk\PDFOrders\" & Order & ".pdf"

That works great - now I have a challenge, and I dont think it will work, but I am not the greatest with the programming end of things, so I wanted to ask.

I have a form that shows each customer, then a subform that only shows orders from that customer. As you can imagine customers may have 1 order or 5...

Can I use the same idea for hyperlink as above on the form and still get Access to open the orders for a customer from within the subform?

I simply tried putting the same code on the main area of the form, but as I expected it doesnt look in the subform. Even if I could get it to look in the subform, what happens when it sees 2 or more numbers in the "order" column?

I have added a picture incase that helps.

Any help is appreciated!

Attached Images
File Type: jpg Sample.jpg (27.0 KB, 525 views)
Apr 13 '10 #1
Share this Question
Share on Google+
6 Replies

Expert Mod 15k+
P: 31,492
Check out How to Programmatically Create a Hyperlink on a Form. It could be easier than you think.
Apr 13 '10 #2

P: 4
Thanks Neo, I will take a look.
Does that mean you know/think what I want to do is possible?

*UPDATE* - Ok, so I took a look at that thread you referenced... I dont have any programming background so I am seriously struggling with understanding what each of those lines will do. Classically I have copied programming that I have found somewhere and manipulated it slightly to accomplish what I need (Like the hyperlink example above) but my instincts are telling me that without some more background lessons, deciphering that code is a little above my pay grade. :)

Apr 14 '10 #3

Expert Mod 15k+
P: 31,492

To be honest, that wasn't the thread I thought I was linking you to. I need to dig up something I did a while back that made creating these links for a form perfectly possible just in the query itself. Generally speaking, no code required.
Apr 14 '10 #4

P: 4
Oh, no problem - I appreciate the help.
I was having issues just getting the simple one working today over the network, but I resolved that. Now I just want to see if I can make it pul multiple orders.

Thanks for the help!
Apr 14 '10 #5

Expert Mod 15k+
P: 31,492

P: 4
Thanks Neo!
I will take a read over that and see if it is easier to understand.

Apr 15 '10 #7

Post your reply

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