Recent content by hubelea

  1. H

    Query to return specific text if any record in a field matches specific text

    I've got it everyone. Took a few separate queries and then joined them. Thanks for your help!
  2. H

    Query to return specific text if any record in a field matches specific text

    OK, that seems to move me in the right direction - brings me the list of states where at least one UPC is approved. Now how do I get it bring back "Not Approved" so that I wind up with the entire list of states?
  3. H

    Query to return specific text if any record in a field matches specific text

    Sorry, thought giving you the tables with the fields would work. Here's the first query to bring together info from the product table and the JnctnStateUPC table Here are the results of that query: Note that in AK there are some items approved and some not allowed. Here are the results...
  4. H

    Query to return specific text if any record in a field matches specific text

    My database tracks products - the product table includes descriptors like UPC, Category, Brand, Description, Size, and also tracks whether a specific product is approved at State level. The approval status is maintained within the JnctnStateUPC table at the SUUPC level in the RecentStatus...
  5. H

    Solved Code to batch copy files from one folder to another

    I moved the destination folder to a different location, updated the code, and it worked. Thanks everyone for your help!
  6. H

    Solved Code to batch copy files from one folder to another

    Same version of Office, but now Windows 10 instead of 8. Compiling the database returns no errors.
  7. H

    Solved Code to batch copy files from one folder to another

    I changed to your exact suggestion (copied/pasted) and received compile/syntax error.
  8. H

    Solved Code to batch copy files from one folder to another

    It could have something to do with folder permission - our IT policies have this new computer locked up tight. But I'm not sure what to check.....
  9. H

    Solved Code to batch copy files from one folder to another

    Yes, absolutely, there are a list of files and all of them are the exact file location. I right clicked on the file, copied the file location, and pasted it into the PDFLocation field. I took out the error handling code and just got the runtime error 76, which allowed me to see the issue...
  10. H

    Solved Code to batch copy files from one folder to another

    Wish that helped, but no luck. Thanks for trying!
  11. H

    Solved Code to batch copy files from one folder to another

  12. H

    Solved Code to batch copy files from one folder to another

    Is it possible that the new computer's antivirus program is blocking the path?
  13. H

    Solved Code to batch copy files from one folder to another

    Thanks to a lot of help from this forum over the years I have a form with a button that copies files listed on the form from one folder to another on my computer. Was working perfectly until I got a new computer. I made absolutely sure that the file locations for the files I need to copy...
  14. H

    List files to table and include date modified

    I wound up going through all of my files and removing the apostrophes. Needed to be done anyway. Jiri - the code you provided did the trick, it was my file naming errors that slowed me down. THANK YOU SO MUCH for all of your help!
  15. H

    List files to table and include date modified

    Made that change. It is still stopping at errors, and it still seems to be files or folders with apostrophe's.
See more
Top Bottom