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!

  • Congratulations Chris Miller 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. simon1tan

    Finding row/column of clicked object within a table

    I'm trying to find the row and column of a checkbox within a table. When I click on the checkbox, I want to know what row and column I am in. Any ideas?
  2. simon1tan

    logged in Username of remote machine

    I build an db just like that and then some! Here is my function: Function getLoggedOn(sComputer) On Error Resume Next counter = 0 If sComputer <> "" Then If ping(sComputer) = True Then Set objWMIService = GetObject("winmgmts:{impersonationLevel=impersonate}!\\" &...
  3. simon1tan

    source.close not working,

    haha. error occurs on the sourcedoc.Close statement. I kinda of have it figured out by opening the document visible=false and readonly=true. Not even using sourcedoc.close anymore. Hopefully it doesn't cause any issues down the road.
  4. simon1tan

    source.close not working,

    Word 2010 Hi, in my VBA I'm opening a external word doc to get some text: Set sourcedoc = Application.Documents.Open(sFile) Once I get the text, I try to close this document: oFFld("Text2").Result = sourcedoc.Range sourcedoc.Close I'm getting an error message "Runtime error 4198. Command...
  5. simon1tan

    Lostfocus not the same as click?

    I have a textbox. I want it to trigger on lostfocus, copy text from another word document, paste into a field or replace a designated text pattern in current document. I have it working using a command button click but textbox lostfocus does not work. And you are right, it seems like a focus...
  6. simon1tan

    Lostfocus not the same as click?

    I've got some VBA code to copy and paste in word. Using a button and the click event, this code works wonderfully. Using a textbox and the lostfocus event, the code errors out at Selection.HomeKey saying "Method 'HomeKey' of object 'Selection' failed". When I comment out Selection.Homekey, the...

Part and Inventory Search

Back
Top