UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Thumbs.db File Annoyance, Access 2010    
 
   
SemiAuto40
post Apr 16 2018, 02:18 PM
Post#1



Posts: 617
Joined: 3-April 12
From: L.A. (lower Alabama)


I have some VBA code that I found and I am just trying to get a list of all files (well almost all files) in a certain folder. Problem is a thumbs.db file and thumbs.db folder have appeared and are screwing up my list. I have tried some to set the file attribute of thumbs files so that I could delete it. Any suggestions?

Thanks.
Go to the top of the page
 
Doug Steele
post Apr 16 2018, 02:44 PM
Post#2


UtterAccess VIP
Posts: 21,811
Joined: 8-January 07
From: St. Catharines, ON (Canada)


What's the code you're using? It shouldn't be that difficult to check when the current file is thumbs.db and ignore it.

--------------------
Doug Steele, Microsoft Access MVP (2000-2018)
http://www.accessmvp.com/DJSteele/AccessIndex.html
Co-author: Access Solutions: Tips, Tricks, and Secrets from Microsoft Access MVPs, published by Wiley
Co-author: Effective SQL: 61 Specific Ways to Write Better SQL, published by Addison-Wesley Professional
Technical Editor: Access 2010 Bible, Access 2013 Bible, Access 2016 Bible, all published by Wiley
Technical Editor: SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL, 4th Edition, published by Addison-Wesley Professional
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    17th July 2018 - 04:49 AM