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

Combo box possibilities

P: 14
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.
Nov 17 '06 #1
Share this Question
Share on Google+
5 Replies


MMcCarthy
Expert Mod 10K+
P: 14,534
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:someone@domain.com format.
Nov 18 '06 #2

ADezii
Expert 5K+
P: 8,669
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:
Expand|Select|Wrap|Line Numbers
  1. Me![WebBrowser1].Navigate Me![cboWebSites]
Nov 18 '06 #3

MMcCarthy
Expert Mod 10K+
P: 14,534
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:
Expand|Select|Wrap|Line Numbers
  1. Me![WebBrowser1].Navigate Me![cboWebSites]
Good catch ADezii and good solution.

I misread the question to refer to email address rather than web addresses.
Nov 18 '06 #4

PEB
Expert 100+
P: 1,418
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!
Nov 18 '06 #5

P: 14
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!
Nov 19 '06 #6

Post your reply

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