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 TouchToneTommy 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. AncientTiger

    How to screenshot a userform and save the capture as JPG

    WOW!! Thanks Strongm, you're the best :) ------------------------------------ [yinyang] Over 35 years of programming, and still learning every day! [yinyang]
  2. AncientTiger

    How to screenshot a userform and save the capture as JPG

    Unfortunately, I'm not finding any way in VBA to work with the clipboard like VB6 can.... Hoping someone here has that expertise :) ------------------------------------ [yinyang] Over 35 years of programming, and still learning every day! [yinyang]
  3. AncientTiger

    How to screenshot a userform and save the capture as JPG

    strongm, you prompted me to dig out my old notes on the process... you're right, that wasn't the method... I used this: Microsoft Windows Image Acquisition Library v2.0 (wiaaut.dll) FPATH = "C:\test.bmp" Dim picfile As New WIA.ImageFile Dim picprocess As New WIA.ImageProcess Set picfile = New...
  4. AncientTiger

    How to screenshot a userform and save the capture as JPG

    I've done this before in VB6, but is there a way in Excel VBA to screencapture the userform (already know how to do this), then save the image in the clipboard to a JPG file? I recall that in VB6 if was a simple as sending the image to a picturebox control from the clipboard, then saving the...
  5. AncientTiger

    What's a good tool for logging failures

    I have looked at the event viewer, but nothing was logged. The first reference to anything amiss was the log notation about the unexpected shutdown, and it just said when it happened, but no details ------------------------------------ [yinyang] Over 35 years of programming, and still learning...
  6. AncientTiger

    What's a good tool for logging failures

    Being a bit of a novice at building PCs, I'm wondering of I can get some advice... I have a custom built PC that is powering down at random times, then won't power back on until being unplugged the plugged back in. Is there a diagnostic tool that anyone could recommend that logs activity...
  7. AncientTiger

    Detecting when windows is logged off or shut down

    THAT DID THE TRICK WONDERFULLY!!!!!!!!! Working like a charm now, fully tested and good to go [medal] [medal] [medal] [medal] [medal] Thanks a ton Strongm! ------------------------------------ [yinyang] Over 35 years of programming, and still learning every day! [yinyang]
  8. AncientTiger

    Detecting when windows is logged off or shut down

    Thanks Strongm, I will give it a try when I get back to work tomorrow! This evening it's a fine cigar and a smattering of scotch for this old cat. And you mentioned not having VB6 on your Win10 machine...I recently stumbled upon this article about installing our beloved editor in the new OS,in...
  9. AncientTiger

    Detecting when windows is logged off or shut down

    Strongm, your code example worked like a charm in Win10!!! Thank you! Well.... hold on... after experimentation I learn that even though it appears to be working, there's problems... I set up a test script to monitor the function every 5 seconds to see if the screen was locked or not, write a...
  10. AncientTiger

    Detecting when windows is logged off or shut down

    Good suggestion, however the program minimizes to the taskbar onLoad and stays out of the users way. I really wanted it to be as unobtrusive as possible. So, it would rarely, if ever, get a mouseover event. Again, good thought tho! Strongm, your code example worked like a charm in Win10...
  11. AncientTiger

    Detecting when windows is logged off or shut down

    It's a sign in/out program to help operators know when folks are in their office and out. If they leave their desk, they either log off/restart or lock their screens. My program is good at catching the Unload event and logging the person as OUT, but if they lock their screens, then there IS no...
  12. AncientTiger

    Detecting when windows is logged off or shut down

    Ok, I found a snippet of code that works in Windows 7 when the screen is locked..... but it won't work in Windows 10. Any suggestions? Option Explicit Public Const DESKTOP_CREATEMENU = &H4& Public Const DESKTOP_CREATEWINDOW = &H2& Public Const...
  13. AncientTiger

    Detecting when windows is logged off or shut down

    Thanks for the reply Strongm! Sorry, I didn't see this until just now. The unload event was perfect... now one more good one... IS there a way to detect when users lock their session? As opposed to logging off or restarting/shutting down, we have some that just lock their screens, so my program...
  14. AncientTiger

    Detecting when windows is logged off or shut down

    thread222-1243704 Could someone give me a code example of this? Needing my exe to log when a user logged off / shut windows down at XX date/time, but not sure how to code the event trigger.... Thanks :) ------------------------------------ [yinyang] Over 35 years of programming, and still...
  15. AncientTiger

    Working with Access databases on network drive with "shaky" connection issues

    Oh, I agree dgillz..... however, I have NO control over our networking, so I'm trying to find a way for my software to compensate. I suspect there's traps and catches that I could be using in the code that would make my program a little more dependable in a bad environment...
  16. AncientTiger

    Working with Access databases on network drive with "shaky" connection issues

    Ok, first of all, I'm a self-taught programmer, so if I'm asking questions that make some of you go "DUH!", please forgive an old man. Evidently I know some, but just not enough to overcome some issues, and am hoping y'all can help. Here's the situation. I've got a simple logging application...
  17. AncientTiger

    err.description and erl no longer giving values

    DISREGARD THIS ISSUE! Found what was happening, and it was just an old programmer having cranial flatulence. My error trap was calling a separate sub that did a screen capture. I had recently also added a bug catcher in THAT sub, so one On Error was cancelling the values captured by the source...
  18. AncientTiger

    err.description and erl no longer giving values

    I've NEVER encountered this issue before in all the years that I've been programming VB6, but all of a sudden, all my error handlers are giving up nadda information on error reporting. Typically, Err.Description provides just that, the descriptive text of the error encountered. Erl returns the...
  19. AncientTiger

    Needing help with spellchecking a textbox

    Strongm, you are mah hero (insert southern accent and a big smacker!) That worked like a charm. I tweaked the code using your suggestions, and was even able to get the Word dialog spellcheck to pop up, while the word window minimized ;) 'Create a new instance of word Application Set...
  20. AncientTiger

    Needing help with spellchecking a textbox

    Just to clarify, this project is a Visual Studios 6 project, not a Word VBA script, so yes, I have to create a word object to copy text to to invoke the word spellcheck function. Unless there's another method for spellchecking textbox contents, I'm stuck with utilizing a word.application...

Part and Inventory Search

Back
Top