Results 1 to 3 of 3
  1. #1
    kcrty is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Feb 2013
    Posts
    8

    Need to pull string from table and insert string into VBA code

    Hey guys,

    Yes, I'm a NooB, I'm usually pretty quick at figuring things out via google-youtube, but I've been stuck for 3 days now.

    I need to pull info from a table and insert it into my code (see below).

    Private Sub cmdMBHPelig_Click()

    Set objIE = CreateObject("InternetExplorer.Application")
    objIE.Top = 0
    objIE.Left = 0
    objIE.Width = 1400
    objIE.Height = 950
    objIE.AddressBar = 0
    objIE.StatusBar = 0
    objIE.Toolbar = 0
    objIE.Visible = False 'We will see the window navigation
    objIE.Navigate ("web url")

    Do
    DoEvents
    Loop Until objIE.ReadyState = 4

    objIE.Document.GetElementByid("loginForm:loginPane l:username").value = "usernameid"
    objIE.Document.GetElementByid("loginForm:loginPane lassword").value = "password"
    objIE.Document.GetElementByid("loginFormroviderLogin_1_id3:submitButton").Click
    Do
    DoEvents
    Loop Until objIE.ReadyState = 4

    objIE.Visible = True
    objIE.Document.GetElementByid("form1: eligibilitySearch: member_memberID").Value = "need to pull string from table"
    ' objIE.Document.GetElementByid("form1:verifyMemberE ligibility_1_id21:verifyMemberEligibility_1_id22") .Click

    Do
    DoEvents
    Loop Until objIE.ReadyState = 4



    End Sub

  2. #2
    JeffChr is offline Advanced Beginner
    Windows 7 64bit Access 2010 32bit
    Join Date
    Feb 2014
    Posts
    82
    what table?
    what record?
    what field?
    part of the field or all of the field?

  3. #3
    kcrty is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Feb 2013
    Posts
    8
    Hey Jeff, I realy appreciate any help you can give me.

    I am the owner of a private practice, I am trying to set up a system where the clinicians can press a cmd button in Access and the VBA code will log them in, and then fill in other fields in the insurance provider web site. I can plug in the login info as this won't change very often, but other information (such as the client's name) will always be different. Therefore I need to find a way to pull info out of the database and place that data into the insurance provider web site via VBA.

    What table: - Client demographic table, "a demographics"
    What Records: (strings - based on !me/current-active record)
    What field, 'name, address, city, state, phone etc.
    all of the field.....

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 5
    Last Post: 09-18-2013, 06:44 PM
  2. Replies: 6
    Last Post: 09-10-2013, 08:37 AM
  3. Replies: 7
    Last Post: 05-28-2013, 09:11 AM
  4. Search for a String in VBA code.
    By dandoescode in forum Access
    Replies: 3
    Last Post: 06-21-2012, 11:00 AM
  5. Replies: 3
    Last Post: 01-05-2012, 10:47 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums