Combo box possibilities

[Bface]

Here are the other 2 questions I have. I forgot to mention I am on Access 2003/Windows XP.

The second and third question I have is on Combo box. Can a combo box be used to access several documents on the network drive (U) or any other location? For example from the drop down list there are 3 options.
Weekly figures
Monthly figures
Quarter figures

Each one of these would open the related word or excel document.


The third question is, I saw a posting on this but apparently I didn’t get everything. I would like to create a combo box which list web addresses that a user can chose from. First I tried to add the values (web addresses) in the combo box then changed the hyperlink (format tab) on the combo box to yes but that didn’t work. Then I decided to create a table with the addresses as hyperlinks and then created a combo box with the table. Change the combo box hyperlink to yes and it still did not work. I thought for sure the second one would have worked but I had no luck. Hope I made sense. Thanks for any help.

[MMcCarthy]

Here are the other 2 questions I have. I forgot to mention I am on Access 2003/Windows XP.

The second and third question I have is on Combo box. Can a combo box be used to access several documents on the network drive (U) or any other location? For example from the drop down list there are 3 options.
Weekly figures
Monthly figures
Quarter figures

Each one of these would open the related word or excel document.

Instinctively I would say that the best way to do this is to create a table with a list of linked oleobjects and include a field to reference them as above.

The only other way I can think of to do this is to have all the files in one folder and get a list of the contents of the folder to populate the combobox. (There is code for this if necessary)

The files would have to contain some naming convention regarding their weekly, monthly, etc. status. Which would have to be checked for using in the aforementioned code.

The third question is, I saw a posting on this but apparently I didn’t get everything. I would like to create a combo box which list web addresses that a user can chose from. First I tried to add the values (web addresses) in the combo box then changed the hyperlink (format tab) on the combo box to yes but that didn’t work. Then I decided to create a table with the addresses as hyperlinks and then created a combo box with the table. Change the combo box hyperlink to yes and it still did not work. I thought for sure the second one would have worked but I had no luck. Hope I made sense. Thanks for any help.

I can't remember the resolution on that. Maybe someone else will. If not I'll try to find out.

I do remember making a comment regarding the original email entries and whether they had the mailto:[e-mail] format.

[ADezii]

Here are the other 2 questions I have. I forgot to mention I am on Access 2003/Windows XP.

The second and third question I have is on Combo box. Can a combo box be used to access several documents on the network drive (U) or any other location? For example from the drop down list there are 3 options.
Weekly figures
Monthly figures
Quarter figures

Each one of these would open the related word or excel document.


The third question is, I saw a posting on this but apparently I didn’t get everything. I would like to create a combo box which list web addresses that a user can chose from. First I tried to add the values (web addresses) in the combo box then changed the hyperlink (format tab) on the combo box to yes but that didn’t work. Then I decided to create a table with the addresses as hyperlinks and then created a combo box with the table. Change the combo box hyperlink to yes and it still did not work. I thought for sure the second one would have worked but I had no luck. Hope I made sense. Thanks for any help.

1) Populate a Combo Box, say cboWebSites, with any valid entries such as:
www.microsoft.com, www.yahoo.com, etc.
2) Insert the Microsoft Web Browser ActiveX Control onto a Form and use it
exclusively for browsing (name it WebBrowser1)
3) Select a Web Site from the Combo Box and wherever appropriate, add this simple line of code:

Me![WebBrowser1].Navigate Me![cboWebSites]

[MMcCarthy]

1) Populate a Combo Box, say cboWebSites, with any valid entries such as:
www.microsoft.com, www.yahoo.com, etc.
2) Insert the Microsoft Web Browser ActiveX Control onto a Form and use it
exclusively for browsing (name it WebBrowser1)
3) Select a Web Site from the Combo Box and wherever appropriate, add this simple line of code:

Me![WebBrowser1].Navigate Me![cboWebSites]

Good catch ADezii and good solution.

I misread the question to refer to email address rather than web addresses.

[PEB]

Hi with the list, queries or combo boxes you can do it...

At this place
http://www.mvps.org/access/modules/mdl0001.htm

There is an exemple that illustrates an Explorer in Access...

When you click on an entry it is open...

It seek everywhere!

[Bface]

Thank you all for replying. I have created, populated the Combo Box [CboWebSites] and created the Form WebBrowser1 with the ActiveX control. Could someone please let me know where I am suppose to add the line of code.

Thanks!