User Profile

Collapse

Profile Sidebar

Collapse
BHo15
BHo15
Last Activity: Dec 30 '20, 04:18 PM
Joined: Feb 3 '14
Location: Texas
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • BHo15
    started a topic Object Required on VBA IE Automation
    in Visual Basic

    Object Required on VBA IE Automation

    Greetings All.

    Having trouble automating a website. When I try to assign a value to a text box on the page, I get Run-Time Error 424 Object Required.

    Here is my VBA...

    Code:
                .document.getElementById("IO:3b05fe9b1b00ac14a6fdfd9f034bcbd3").Value = strAssessment(i)
            Sleep (250) 'Had to add sleep to give it time to complete each of these tasks
    Here...
    See more | Go to post
    • BHo15
      replied to Need help with IE selecting drop down
      in Access
      Interesting Rabbit. I never would have guessed that. I'll give it a go.
      See more | Go to post

        Leave a comment:

      • BHo15
        replied to Need help with IE selecting drop down
        in Access
        Yes sir, I tried that, and it is still not connecting correctly. It keeps saying "object required".
        See more | Go to post

          Leave a comment:

        • BHo15
          replied to Need help with IE selecting drop down
          in Access
          I’ve been working in Access for about 15 years, and though it’s rare, I have had need to write VBA FOR IE, so I was just hoping that others did as well. Bytes is my favorite message board for Access and VBA. So I always like to start here.
          See more | Go to post

            Leave a comment:

          • BHo15
            replied to Need help with IE selecting drop down
            in Access
            Oh well. It was a good thought.
            See more | Go to post

              Leave a comment:

            • BHo15
              replied to Need help with IE selecting drop down
              in Access
              I lot of views on this? Anyone able to help?
              See more | Go to post

                Leave a comment:

              • BHo15
                replied to Conditional Format Button based on value in another table
                in Access
                I had luck with a DCount on the table that is supporting the form. So you could do something like
                Code:
                If DCount("*","tbl_TableName","ID = " & Me.ID)>0 Then Me.btn_PastMedicalHistory.BorderColor = RGB(255, 224, 0)
                See more | Go to post

                  Leave a comment:

                • BHo15
                  started a topic Need help with IE selecting drop down
                  in Access

                  Need help with IE selecting drop down

                  I am trying to select from a dropdown in IE from Access VBA. You cannot right click on the dropdown and inspect element. I ended up using something on found online, and it worked for a while, but it has now stopped working. Here is what I was using...

                  Code:
                  IEWindow.Document.querySelector("div[id=pagecontents] div[class=container] div[id=resultOptions] form[name=resultOptions] select[id=selectResult]").Focus
IEWindow.Document.querySelector("div[id=pagecontents]
                  ...
                  See more | Go to post
                  • BHo15
                    replied to Controlling combobox in Internet Explorer
                    in Access
                    I see from the HTML I pasted that there is an ID "favScans" which actually has the choice options listed below it (I did not see that one when I was working with it). I just tried the code with using favScans instead, but it would not let me interact with that element at all (error 70 Permission DENIED!!!).
                    See more | Go to post

                      Leave a comment:

                    • BHo15
                      replied to Controlling combobox in Internet Explorer
                      in Access
                      Thanks NeoPa. I was using Inspect and not View Source. That did the trick.

                      So, here is the unadulterated HTML...

                      Code:
                              <div id="scc-scanengine-head">
            <!-- SELECT ALERT -->
            <div id="selectScan" class="form-item">
                <div class="form-item-label"><strong>Your Saved Scans</strong></div>
                      ...
                      See more | Go to post

                        Leave a comment:

                      • BHo15
                        started a topic Controlling combobox in Internet Explorer
                        in Access

                        Controlling combobox in Internet Explorer

                        I'm having trouble controlling a combobox in Internet Explorer. I've done it before by using IE.Document.get ElementByID("co ntrolName").Sel ectedIndex = 2, and then IE.Document.get ElementByID("co ntrolName").Fir eEvent ("onchange") . But... that is not working this time. I keep getting error 438 on the .SelectedIndex line.

                        Here is a pared down version of my code...

                        Code:
                        Public Sub StockChartsTrades()
                        ...
                        See more | Go to post
                        • BHo15
                          replied to My subform is not requerying
                          in Access
                          My client LOVES datasheet forms and wants no part of standard or continuos forms. So to be able to use controls (text boxes, combo boxes, list boxes, etc) we put them on a parent form.

                          Your idea do form.recordsour ce is great, but in this case it was a supporting query to the recordsource that needed to be adjusted, and not the recordsource query itself.

                          Thanks.
                          See more | Go to post

                            Leave a comment:

                          • BHo15
                            replied to My subform is not requerying
                            in Access
                            Gotcha. Both of the link fields are blank. The parent form has no data (only controls).
                            See more | Go to post

                              Leave a comment:

                            • BHo15
                              replied to My subform is not requerying
                              in Access
                              Yes sir. The parent is unbound, and the child is a bound datasheet. It is the bound datasheet that is not requerying.
                              See more | Go to post

                                Leave a comment:

                              • BHo15
                                replied to My subform is not requerying
                                in Access
                                BTW Phil... I never answered your question. The parent form is unbound.
                                See more | Go to post

                                  Leave a comment:

                                • BHo15
                                  replied to My subform is not requerying
                                  in Access
                                  Good thought, but I actuallly did breaks several times. I saw clearly that it was updating the query SQL code. It also complied very nicely.

                                  Oh well, I’ll just chalk this one up to the unexplained. At least closing and reopening the form worked.

                                  Thanks.
                                  See more | Go to post

                                    Leave a comment:

                                  • BHo15
                                    replied to My subform is not requerying
                                    in Access
                                    My bad NeoPa. I got the code from a client's machine, and I just did a screen print of it and then retyped it. So unfortunately I can't just post the original code.

                                    BUT... Here it is again. I put it in Notepad++ and cleaned it up, and had my wife help me proof read it.

                                    Code:
                                    Private Sub cmdObtainHolding_Click()
‘This is working as expected
	CurrentDB.QueryDefs(“qry_Trades_Sum”).SQL = “SELECT Sum(tbl_Trades.Change_Amount)
                                    ...
                                    See more | Go to post

                                      Leave a comment:

                                    • BHo15
                                      replied to My subform is not requerying
                                      in Access
                                      I will say the option group code is simplified, in that there is not a Select Case to determine which option was selected. I just wanted to get it working to requery the form before building the Select Case.
                                      See more | Go to post

                                        Leave a comment:

                                      • BHo15
                                        started a topic My subform is not requerying
                                        in Access

                                        My subform is not requerying

                                        If have a form with several controls on it, and a subform. When I use the control to choose date and strategy, and then hit a button, the query's sql adjusts properly, and the subform requeries great, and all is well.

                                        BUT... When I select an option group instead, the query's sql DOES update properly, but the subform does not requery. I can't figure out why.

                                        Here is the code


                                        Code:
                                        Private Sub cmdObtainHolding_Click()
                                        ...
                                        See more | Go to post
                                        • BHo15
                                          replied to Blank screen when opening a database
                                          in Access
                                          I don't WHY I didn't find this in the first go-round, but I just found something that will work.

                                          DoCmd.RunComman d (acCmdDatabaseS plitter)

                                          I can add this to a button on the switchboard, and then she can create a backend database on her network.

                                          Sigh...

                                          Anyway fellas... Thanks for the help.
                                          See more | Go to post

                                            Leave a comment:

                                          No activity results to display
                                          Show More
                                          Working...