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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by kjv1611

  1. kjv1611

    Do we have a VBS version of listing files in a folder?

    I just happened to login and see this. I don't login like I used to. Anyhow, here are a few ideas to chase after, if you're still curious: * FileSystemObject - gives lots of things you can do. If nothing else, you can build a loop (with or without subfolder recursion) to loop through all files...
  2. kjv1611

    OneDrive - Clean Local Cache For A User Remotely

    I've never tried, but I'm at least thinking this may be able to be done through Group Policy. Here's a search I did along those lines: https://www.qwant.com/?q=onedrive+gpo+clean+cache&client=brz-brave&t=web And here's a discussion that may have a pretty decent method to tackle it...
  3. kjv1611

    Is it possible to record macros in Outlook?

    Oh how I wish Chat-GPT were right! Thanks for sharing, regardless. "But thanks be to God, which giveth us the victory through our Lord Jesus Christ." 1 Corinthians 15:57
  4. kjv1611

    Trust relationship issue

    One easy way that normally works that I've seen is to remove the PC from domain (at the PC), then re-add. Just make sure you have the local admin credentials documented somewhere first of course. "But thanks be to God, which giveth us the victory through our Lord Jesus Christ." 1 Corinthians 15:57
  5. kjv1611

    DoCmd.Close not working

    The tag formatting you added just adds confusion. To use that, you need to post the code inside your post, not save as an attachment, just info for future. I will say that line of code is inside three conditional statements. Have you tried stepping through the code and tracking the values of...
  6. kjv1611

    Calculating differences every two rows

    So I assume you're doing a comparison of month by month, year over year? So you want to see for January this year vs last year, Feb for this year vs last year, etc? As far as how to make it all work, here's an idea from another discussion...
  7. kjv1611

    Excel Help - Worksheets by UserID

    Assuming you mean you want the Windows User from a given row of your Access sheet to access those listed in the Worksheets column, I think the easiest way will be something like this: [ol 1] Loop through each row An array variable to hold the worksheet names value from each row. To fill it...
  8. kjv1611

    Boot From USB drive getting Error message "bootable device was not found"

    You have to choose between UEFI and BIOS modes for boot devices, including with Windows 10. Any Windows 10 USB by their media creator (I think) will now assume UEFI, whereas many Linux distros may very well use BIOS mode. So in the end, if you want to swap between, on many...
  9. kjv1611

    Laptop heating issues

    I got an AW gaming laptop, myself, almost a year ago, and I have had to think more about cooling for sure. It isn't absolute, but one thing that helps WAY MORE than you would ever expect is to elevate the back of your laptop at least somewhat above the front when it's in use, especially with...
  10. kjv1611

    Authentication failed. No client certificate was sent.

    What is the email provider? Most email providers now require a certain certificate/authorization that you have to configure, and I forget the name right now. I had to set it up for our office with Microsoft 365, for instance. "But thanks be to God, which giveth us the victory through our Lord...
  11. kjv1611

    Phone drops during long number entries

    Is it possible the system supports some sort of built-in coding for entered digits, and the user happens to enter that digit or set of digits during that long series of digits, and that happens to be connected to a disconnect/drop command? Sounds crazy, but the problem sounds pretty crazy. btw...
  12. kjv1611

    Zebra zt411 printer prints one label each minute from spooled file.

    Are you using wifi, same as the original poster? I honestly do not know the for sure answer here, but I know a couple of things: [ol 1] Zebra Label printers are built like tanks, and oftentimes never seem to die. However, they can be VERY VERY finnicky sometimes and can have seemingly the...
  13. kjv1611

    How to Assign Action to F1 Key

    You may can look at AutoHotkey or similar software if you mean to use it across your computer, regardless of program. However, while many programs are open, the application in focus will likely take over the F1 functionality since it's been used since that key existed, it seems, for "help" for...
  14. kjv1611

    Best password method with time factor

    I think you need to provide more detail to get a good answer. I'm just now seeing this for the first time, as I rarely check-in at TT anymore. That said, here are some thoughts: [ol 1] Split database design. You did not specify your database design, but your tables should be in a separate...
  15. kjv1611

    Windows 10 Camera

    Take a look at this where someone asked the same or similar question and found their own solution, posting back to the site: https://stackoverflow.com/questions/28036527/open-windows-8-1-camera-app-with-vba Dim MyFile As String Dim Cmd As String MyFile =...

Part and Inventory Search

Back
Top