Two questions, both quick

[revver]

ONE
I am about to update my knowledge to version 2010. It seems so different.
Recommendations please for books or other learning resources.
I have used 2007 but most familiar with 2003.

TWO
A new database will have a table containing a field called URL. The main form (unbound) will contain a combo box to select a URL for processing. Once processed, I want the user to be able to go to the site in the default browser, probably by clicking a button on the same form.

My question: Which data type is best for the job, text or hyperlink? Reasons?

 

[choytw]

For question one, I usually just go to Barnes & Noble and get a book. Haven't worked with 2010 so not sure which will be the best for you.

2:

What I did was on the table, I stored the links as text. On the form, I marked the site address as a hyperlink. Then, on the Click event, I have the following Event Procedure:

Private Sub pageAddress_Click()
  Call Shell("explorer.exe " & Me.pageAddress, 5)
End Sub

 

[boblarson]

#1) Check out my "Books I Recommend" link on my website.

#1) Also, you can go here for free online tutorials:
http://www.functionx.com/access/index.htm

#2) I would also store the link as text but you can also make it work by using an alternative method as well, which should use the default browser instead of IE specifically (I think):

Private Sub pageAddress_Click()
   FollowHyperlink Me.pageAddress
End Sub

 

[choytw]

Bob,

Thank you for replying with that! When I was searching for a way to follow a hyperlink inside of Access, the IE version was the first I came across. I personally dislike it when people limit you to one brand of software so will definitely use your variant instead.

Thanks!

 

[boblarson]

Bob,

Thank you for replying with that! When I was searching for a way to follow a hyperlink inside of Access, the IE version was the first I came across. I personally dislike it when people limit you to one brand of software so will definitely use your variant instead.

Thanks!

Well, like I said - I THINK it will use the default browser. Since I am on IE and don't use anything else for my default, I am not 100% confident of that. But it SHOULD.

 

[revver]

Thanks guys.
1 I was going to go to a bookstore to check out what was available but most stores here do not carry much these days. The complex with the nearest one which may have a range is known for its parking problems so I wanted a headstart. I'll check out your links before I go Bob.

2 D'oh. I havent had to use hyperlinks for quite some time. When I had to think about it, for some reason my mind got stuck in the 'they must both be the same' groove. It is so simple once that blinker is removed. I'll have to use the excuse that my mind was focussed on table design, not form design. Thanks again guys.

 

[revver]

Bob,
I went to your site. Home page was fine but the recommendations page was corrupt. It looked like some external assets were unavailable. A link to your reviews page was visible but when I clicked it I got a HTTP 404 error. (Requested URL: /tandemserver/default.aspx)

I'm not sure if it is a temporary error or not. I'll try again later.

Thought you'd like to know.

 

[boblarson]

Thanks, I will fix my link for the reviews.

 

[boblarson]

The link should be fixed now.

 

[revver]

Reviews page works fine. Recommendations page still fails to retrieve assets.

Even with a renamed hosts file I get 8 globes with a superimposed rex x followed by bullet points of what to do to try to fix it. It's the standard "I can't find that" screen repeated 8 times.

Using view source I find that the links are to

http://rcm.amazon.com/e/cm?t=btde-20 etc etc

in an iframe.

I can successfully browse to amazon.com but not to rcm.amazon.com/e/cm

HTH.

BTW, I had more or less decided on "Inside Out" and "Programmers Reference" but now that I've read your reviews my mind is made up.