Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. krieg313

    Better method for while ieobj,busy Doevents

    Is there a better way to tell the browser to wait until a page has loaded to continue? I've tried while ieobj.busy doevents wend do while ieobj.busy loop and even variable1 = ieobj.document.all.getelementsbytagname("td").length while ieobj.document.all.getelementsbytagname("td").length <...
  2. krieg313

    OLE Get URL from Clicked Linked.

    Well the title says it all, how would i get the url of the link i just clicked? Dim ObjForTesting As Object Dim Link As Object Dim ElementCol As Object Set ObjForTesting = CreateObject("InternetExplorer.Application") With ObjForTesting .Visible = True .navigate...
  3. krieg313

    Get URL path after Clicking on Link

    Anyone home? I guess everyone's on vacation.
  4. krieg313

    Get URL path after Clicking on Link

    Well the title says it all, how would i get the url of the link i just clicked? Dim ObjForTesting As Object Dim Link As Object Dim ElementCol As Object Set ObjForTesting = CreateObject("InternetExplorer.Application") With ObjForTesting .Visible = True .navigate...
  5. krieg313

    Automate OK Dialog Box Click in OLE

    How can I stop Dialog Boxes / Error Messages from opening in my OLE object "IBMReflection"? here is the code: Private Sub cmdQuery_Click() Dim hostpassword As String Dim Session As Object Const SessionCon = "149.83.123.3" Set Session = CreateObject("ReflectionIBM.Application") With Session...
  6. krieg313

    Copy/Paste from OLE to Access 2003

    MsgBox Clipboard.GetText 'or Debug.Print Clipboard.GetText Text2 = Clipboard.GetText when i run the code, It gives off error Run-time error "424" Object Required.
  7. krieg313

    Copy/Paste from OLE to Access 2003

    ps. Clipboard was declared as object.
  8. krieg313

    Copy/Paste from OLE to Access 2003

    Text2.Text = Clipboard.GetText gives off error : Object Variable or with blocl variable not set.
  9. krieg313

    Copy/Paste from OLE to Access 2003

    Thanks for the response. Yes it copies text into the clipboard, because after the code stops, if i do Ctrl + V anywhere i get the text mentioned above.
  10. krieg313

    Copy/Paste from OLE to Access 2003

    I am having trouble pasting data from my OLE object below. The code logs in to an application, goes into a certain screen and then from a certain position to another it copies text, which is not in any format whatsoever. here is an example: SPECIAL BROKER PULL 0 0...
  11. krieg313

    Automation of VB enter key

    ...opening a new form? No. - Are you passing this value to something else? To Sub Command3() - Are you pasting this value in another text box? No. * User inputs 7 numbers (0-9) * After the 7th key is pressed Command3 is called. ** Also is there a way for Access to detect the keystrokes in...
  12. krieg313

    Automation of VB enter key

    Thanks for the reply. I've tried the snippet above but it gives off error Object Required, As for Calling the validation Text box code, well i dont know how to that. what im looking for is right after the 7th key is pressed BtnOk would be called.
  13. krieg313

    Automation of VB enter key

    I'd like to have the code press enter after a certain amount of characters have been entered in a textbox. This is what i have but it doesn't work. Private Sub Text0_KeyDown(Keycode As Integer, shift As Integer) 'Dim str As String Dim str As Object Set str = Text0 'str = "1234567" If...
  14. krieg313

    Code works on IE 6 but not IE 7

    Well, it turns out IE7 didnt like me naming my Constants Username and username1 because after i changed username1 to USRNM, everything was working as it should, i am curious to know why it didn't work before i changed the name. hopefully someone answers~!
  15. krieg313

    Code works on IE 6 but not IE 7

    Sorry about that, I should have been more specific. The line that is giving me trouble is username.Value = str_usr Password.Value = str_pw LogInBtn.Click Run-Time Error "91" Object variable or with block variable not set. HTH
  16. krieg313

    Code works on IE 6 but not IE 7

    I'd really appreciate a reply or at least redirect me to a helpful post.
  17. krieg313

    Code works on IE 6 but not IE 7

    The Code below was made in access 2003 and tested on IE6 and it worked fine, but after testing it on ie7 it gives off errors such as Object variable not defined, or Subscript out of range Sub Kick_Off_Log_In() Const str_usr = "qcc04" Const str_pw = "qc" Dim username As...
  18. krieg313

    VBA String Manipulation

    It Works! But can you explain how it works? I'd like to do the same for Workcenter B too.
  19. krieg313

    VBA String Manipulation

    I'll give it a try and post my results.
  20. krieg313

    VBA String Manipulation

    ...'sublvl = InStrRev(MainTable, "Sub-Level") MailMethod = Mid(Maintable, InStr(1, Maintable, "Mail Method ") + 12) 'Look Below for comments'********************** 'mailmethod2 = InStr(Maintable, "Mail Method ") 'MailMethod = Left(mailmethod2, 4) 'MailMethod = Right(MainTable...

Part and Inventory Search

Back
Top