User Profile

Collapse

Profile Sidebar

Collapse
JMANTN
JMANTN
Last Activity: Aug 13 '10, 12:22 AM
Joined: Apr 18 '10
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • JMANTN
    replied to Using Access 2007 to automate Internet Explorer issue with drop down box selection
    in Access
    Hate to reply to my own thread but in case anyone else comes across this figured I'd show the code that worked for me which took me two days and a lot of trial and error...



    Code:
    Private Sub Testing17_Click()

On Error Resume Next

Dim IE As Object
Dim document, element
Dim btn As HTMLButtonElement

Set IE = CreateObject("internetexplorer.application")
    ...
    See more | Go to post

      Leave a comment:

    • JMANTN
      started a topic Using Access 2007 to automate Internet Explorer issue with drop down box selection
      in Access

      Using Access 2007 to automate Internet Explorer issue with drop down box selection

      I have data that sometimes needs to be uploaded to a 3rd party website and I’m trying to automate this process with Access 2007. I’m having a difficult time with my VBA syntax and with identifying the HTML names/id’s of objects I want to control.

      I have referenced Microsoft HTML Object Library & Microsoft Internet Controls and should note the version of Internet Explorer my company currently uses is IE6 (I know can’t...
      See more | Go to post
      • JMANTN
        replied to changing code to get data from a yes/no field instead of form & SendMessage help
        in Access
        I have finally figured this out and my issue was that the exception selected on the form wasn't being picked up by vba correctly due to the table layout so I created a hidden text field on the form with a dlookup referencing which exception was selected and have it reflect the TTV code and that fixed everything.

        Topher: your assistance with the looping through each record saved me a ton of time however it was getting hung up after the...
        See more | Go to post

          Leave a comment:

        • JMANTN
          replied to changing code to get data from a yes/no field instead of form & SendMessage help
          in Access
          Topher, Thanks I will give that a try once I have a working process with this. Out of curiosity have you ever tried SendMessage versus the method you described? As once I get this working with my db I'm definitely changing it and updating it.

          I haven't stopped working on this since this morning but taking a break from it tonight. I've updated some of the code so I'll post below.

          Code:
          Private Sub cmdEnterTRNG_Click()
          ...
          See more | Go to post

            Leave a comment:

          • JMANTN
            replied to changing code to get data from a yes/no field instead of form & SendMessage help
            in Access
            I was so close yet so far away! Thank You! I've been working on this for 5 hours today!

            It seems like I will need to find a way to loop through each record in the table that hasn't been marked as missed or leaveblank as this processes only one agent but at least that's working :)

            Also it's not copying the exception however I suspect that's on my end as well. Thanks so much. I'm going to try and fix the exception portion...
            See more | Go to post
            Last edited by JMANTN; Apr 21 '10, 10:37 PM. Reason: just seen reply

              Leave a comment:

            • JMANTN
              started a topic changing code to get data from a yes/no field instead of form & SendMessage help
              in Access

              changing code to get data from a yes/no field instead of form & SendMessage help

              Hello,

              I'm trying to incorporate some code that was used in an old database (access 2003 but everything works in 2007) by someone who no longer works with me that utilizes sendkeys to send employee (agent) exceptions into their schedule which is in a different application. The old database works fine as is however I'm making a database for training and trying to use the code with mine and just started learning VBA and could use some...
              See more | Go to post
              • JMANTN
                replied to Duplicate Record issue with Training Database with Multiple tables & temporary tables
                in Access
                Thank you very much TheSmileyOne as I had my AGENT_ID and Course_Number's indexed but not correctly and that fixed my issue! I've been stuck on that for weeks.

                Since I'm still learning I think I'll try and find out how to use VBA to step through each record to check against two or more fields as well sounds like a challenge for a beginner :)

                Thanks again!
                See more | Go to post

                  Leave a comment:

                • JMANTN
                  started a topic Duplicate Record issue with Training Database with Multiple tables & temporary tables
                  in Access

                  Duplicate Record issue with Training Database with Multiple tables & temporary tables

                  Hello, I'm hoping someone could help me out with a problem I've ran into while trying to create a training database. I'm just a beginner with Access and VBA so please take that into consideration.

                  The problem I'm having is the possibility of record duplication in my current database. I'm hoping maybe there's a way to set up a relationship or query/vba to prevent this.

                  I currently have a form (frmCE_AddAgent Training)...
                  See more | Go to post
                  No activity results to display
                  Show More
                  Working...