[x]
Posted via EE Mobile

Search, ask, and monitor your questions on the go with EE Mobile. Visit Experts Exchange from your mobile device and never be out of touch again.
11/04/2009 at 09:42AM PST, ID: 24871709 | Points: 500
[x]
Attachment Details

How to automate cascading option boxes on a web page using Access 2000 VBA

Asked by DonGarry in Microsoft Access Database, Microsoft Development

We are using the following vba code to access a web page:
' Create an object of type InternetExplorer
    Set objIE = CreateObject("InternetExplorer.Application")
     objIE.navigate strUrl
 
'Here are the two boxes we are trying to automate:
First option box is :
 objIE.Document.Forms(0).all("ctl00_PageContentPlaceHolder_vSubClass").Value = 2
'In this case Value = 2 puts "Import Cars" in the BuySell box
'No problem getting the value into the first box...but can't seem to get the first box to post back

'The second box which is hidden until the web page post back is done from the first box
Second option box is:
objIE.Document.Forms(0).all("ctl00_PageContentPlaceHolder_vClass").Value = "2001 Import Cars"

Se have a jpg image of the boxes on the web page
We have attached the full source code of the page.

How can we automate the process....do a post back on the first box, then fill in the second box
 
Attachments:
 
BuySellCombos.jpg (7 KB) (File Type Details) 
These are the combo boxes were are trying to automate
These are the combo boxes were are trying to automate
 
 
PageSourceCode.txt (162 KB) (File Type Details) 
This is the complete page source code
 
Related Solutions: How would I generate a Web Page Post Back using Access VBA
[+][-]11/04/09 10:04 AM, ID: 25742032

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]11/04/09 10:24 AM, ID: 25742229

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 30-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]11/04/09 10:54 AM, ID: 25742559

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]11/04/09 11:29 AM, ID: 25742931

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 30-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]11/04/09 11:40 AM, ID: 25743045

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]11/04/09 11:48 AM, ID: 25743144

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 30-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]11/04/09 12:08 PM, ID: 25743375

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]11/04/09 12:28 PM, ID: 25743562

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 30-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]11/04/09 12:41 PM, ID: 25743670

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]11/04/09 03:09 PM, ID: 25745106

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 30-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]11/05/09 10:06 AM, ID: 25752162

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]11/05/09 10:21 AM, ID: 25752289

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 30-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]11/05/09 11:51 PM, ID: 25757379

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]11/06/09 09:57 AM, ID: 25761353

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 30-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]11/07/09 01:51 PM, ID: 25768208

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 30-day free trial to view this Author Comment or ask the Experts your question.

 
 
Loading Advertisement...
20090824-EE-VQP-74 - Hierarchy / EE_QW_Related_20080208