Search:

Type: Posts; User: dnrodrigo

Page 1 of 2 1 2

Search: Search took 0.05 seconds.

  1. Replies
    4
    Views
    435

    Take a look at the Application.ActiveDocument...

    Take a look at the Application.ActiveDocument object... it has properties that you might be able to use (Name, Path, etc)
  2. Replies
    2
    Views
    342

    You might be able to use the following method; ...

    You might be able to use the following method;

    ftp://username:password@hostname/

    But for security reasons, it is not advisable.
  3. History entries in the "Address" drop-down box of...

    History entries in the "Address" drop-down box of IE are stored here;

    HKEY_CURRENT_USER\Software\Microsoft\Internet Explorer\TypedURLs
  4. Replies
    4
    Views
    971

    1. Look in the registry...

    1. Look in the registry (HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\TimeZoneInformation)

    2. Use the GetTimeZoneInformation API
  5. check out this thread =>...

    check out this thread => http://vbforums.com/showthread.php?s=&threadid=248736
  6. Replies
    14
    Views
    603

    select t1.sstid as Agent, sum(t2.policy_amount)...

    select t1.sstid as Agent, sum(t2.policy_amount) as Amount
    from useraccounts as t1, policy as t2
    where t1.sstid = t2.agentid
    group by t1.sstid
    order by Amount desc
  7. Replies
    4
    Views
    451

    Years = DateDiff("yyyy", Date1, Date2) Months =...

    Years = DateDiff("yyyy", Date1, Date2)
    Months = DateDiff("m", Date1, Date2)
    Days = DateDiff("d", Date1, Date2)
  8. Replies
    177
    Views
    140,714

    Here's an article on how Micro$oft does it;...

    Here's an article on how Micro$oft does it; http://www.extremetech.com/article2/0,3973,10426,00.asp
  9. Replies
    6
    Views
    559

    Try SendKeys "(`{esc})"

    Try SendKeys "(`{esc})"
  10. Replies
    6
    Views
    559

    So you're trying to use SendKeys from a VB...

    So you're trying to use SendKeys from a VB program to send keystrokes to another program?
  11. Replies
    15
    Views
    1,250

    Wow... you have definately taken on a most...

    Wow... you have definately taken on a most complicated project! (especially with VB).

    I have used a variety of programs that do what you are trying to do... everything from command-line based...
  12. Replies
    6
    Views
    559

    http://vbforums.com/showthread.php?threadid=247130

    http://vbforums.com/showthread.php?threadid=247130
  13. Replies
    177
    Views
    140,714

    Ah yes... the problem is not OS specific; Some...

    Ah yes... the problem is not OS specific; Some hardware manufacturers don't embed serial number information in their parts.

    As far as evexa's drive returning a 0, this is quite possible. There...
  14. Replies
    177
    Views
    140,714

    Why not use the motherboard SN? 'Add a reference...

    Why not use the motherboard SN?
    'Add a reference to Microsoft WMI Scripting Library

    Private Sub Form_Load()

    Dim List
    Dim Object
    Dim WMI

    Set WMI = GetObject("WinMgmts:")
  15. Thread: oracle query

    by dnrodrigo
    Replies
    1
    Views
    354

    select item_no, activity, ...

    select item_no,
    activity,
    account_no
    from pcms.pcms_item_activity
    where item_no='40331'
    and activity='0610'
    and acct_no in (select acct_no
    from ...
  16. Replies
    2
    Views
    428

    $dim = substr($dim, length($dim)-1, 1);

    $dim = substr($dim, length($dim)-1, 1);
  17. Replies
    2
    Views
    312

    Const LWRBOUND = 101 'lowest acceptable value...

    Const LWRBOUND = 101 'lowest acceptable value
    Const UPRBOUND = 999 'highest acceptable value
    Const MAXITEM=100
    Dim A(MAXITEM) As Integer

    cmdGenerate_Click
    Randomize
    For x=1 to...
  18. Replies
    2
    Views
    844

    in almost every case, you'll need admin rights to...

    in almost every case, you'll need admin rights to the remote server.

    use net time \\servername > nettime.txt then parse the text file.

    - or -

    write a file to the remote server, then read...
  19. Replies
    4
    Views
    585

    Try placing a DoEvents command in your loop; ...

    Try placing a DoEvents command in your loop;

    Do While Power
    DoEvents
    ...
    Loop
  20. DIR /S > FOO.TXT

    DIR /S > FOO.TXT
  21. Replies
    2
    Views
    523

    Backdoor to Yahoo Quotes ==> Intel Corp....

    Backdoor to Yahoo Quotes ==> Intel Corp. (cut and paste URL into your browser).

    Place your stock symbol in the ?s= parameter.

    As far as I can tell, the &f= parameter (format) takes a..z, and...
  22. Replies
    3
    Views
    819

    If not explicitly specified using Public,...

    If not explicitly specified using Public, Private, or Friend, Function procedures are public by default (including in forms).
  23. Replies
    15
    Views
    1,596

    To copy text to the clipboard, you need to...

    To copy text to the clipboard, you need to specify the CF_TEXT clipboard format as the Format parameter in the SetClipboardData API call;'From Micro$oft Knowlege Base Article 210216
    Declare Function...
  24. Replies
    1
    Views
    1,196

    http://www.developersdex.com/gurus/code/603.asp

    http://www.developersdex.com/gurus/code/603.asp
  25. Replies
    15
    Views
    1,596

    The *Clipboard* API's utilize the Windows...

    The *Clipboard* API's utilize the Windows clipboard, not the VB clipboard object.
  26. Replies
    15
    Views
    1,596

    The Clipboard is a VB object... your program...

    The Clipboard is a VB object... your program ends, the object is gone.

    A simple way to place data on the Windows clipboard;Option Explicit

    Private Declare Sub keybd_event Lib "user32" (ByVal...
  27. Replies
    8
    Views
    791

    No need for thanks Ray, I thrive on...

    No need for thanks Ray, I thrive on troubleshooting.

    You know, sometimes I wonder who really benefits more from these forums... those searching for answers... or those providing them :)
  28. Replies
    8
    Views
    791

    Well... yes, the EULA of SP3 does state that...

    Well... yes, the EULA of SP3 does state that Micro$oft is taking over the world, and that includes your system... but, in actuality, there is a new control panel applet Automatic Updates that allows...
  29. Did you try NET TIME /SET

    Did you try NET TIME /SET
  30. Replies
    8
    Views
    791

    Dude... you might have a problem with your...

    Dude... you might have a problem with your particular keyboard driver.

    I am running your exact code from above (the original code with Form_KeyPress), and I can use Tab or Enter, no bell, works...
  31. Replies
    2
    Views
    458

    If not... take a look at the SetWindowsHookEx API

    If not... take a look at the SetWindowsHookEx API
  32. Replies
    2
    Views
    458

    Can't you just use the KeyPress and KeyDown...

    Can't you just use the KeyPress and KeyDown events, then just set the KeyAscii or KeyCode to 0?
  33. Replies
    8
    Views
    791

    Ray... I think you were almost there. No...

    Ray... I think you were almost there. No guarantee... but try this;Private Sub Form_KeyPress(KeyAscii As Integer)
    'Make Enter key act as TAB key for ease of data entry
    'Note: needs the...
  34. Replies
    3
    Views
    819

    Try public sub whatever B =...

    Try


    public sub whatever
    B = Form1.Walkability(4,5)
    msgbox B
    end sub
  35. Replies
    15
    Views
    1,596

    Did you try; Clipboard.Clear...

    Did you try;


    Clipboard.Clear
    Clipboard.SetText "Can you hear me now?"
  36. Thread: Clear Forms

    by dnrodrigo
    Replies
    12
    Views
    704

    Option Explicit Private Declare Function...

    Option Explicit

    Private Declare Function GetWindowLong Lib "user32" Alias "GetWindowLongA" (ByVal hWnd As Long, ByVal nIndex As Long) As Long
    Private Declare Function SetWindowLong Lib "user32"...
  37. dynamic_sysop... did you intend to say...

    dynamic_sysop... did you intend to say EnumProcesses. The EnumWindows API only enumerates top-level windows on the screen.

    Here's a KB article that explains how to do this;...
  38. Replies
    1
    Views
    396

    If you're running a batch file, I assume you're...

    If you're running a batch file, I assume you're calling CMD.EXE or COMMAND.COM (or using "COMSPEC"... the right way).

    If this is the case, you could use the /c switch to tell the command...
  39. Replies
    3
    Views
    661

    Hmmm... if "re-declaring" a constant was allowed,...

    Hmmm... if "re-declaring" a constant was allowed, it wouldn't be a constant would it... it would be a variable!

    :eek:
  40. Try Clipboard.Clear just prior to...

    Try Clipboard.Clear just prior to Clipboard.SetText
Results 1 to 40 of 59
Page 1 of 2 1 2



Click Here to Expand Forum to Full Width