Problem with TXT Only - Zip Unzip Files in Microsoft Access, Part 2


	Back to Zip Unzip Files 2 Comments List

Upload Images @Reply Bookmark Link Email

Problem with TXT Only

Sandra Truax

13 months ago

Last post for a while, I promise.

Hoping someone can tell me what the heck I'm doing wrong. I am trying to extract one file like Richard demostrated in the Extended cut of Zip Unzip Files 2 at 11:56, and I get the status that it's done, but nothing is in the folder. I have verified the name of the zip file, and the name of the file inside the zip file, but no luck.

This is what I'm using:
UnzipSpecificFiles "D:\Computer Learning Zone\1012.zip", "D:\TempFolder", "01.mp4"

To further clarify, when I use Richard's database, and Zip works, Unzip creates the folder and unzips the file like it is supposed to, BUT when I hit TXT Only, it creates the folder, status shows done, but folder is empty. This is using the original database with NO changes to the code.

	Richard Rost @Reply 12 months ago
Hmmm..... what if you try just ".mp4" instead of the whole filename? Case sensitive? (Shouldn't be, but you never know). Spaces in the path? (Shouldn't be, but it's worth a try).

	Sandra Truax OP @Reply 12 months ago
Richard, I unzipped your download, moved the DB folder to my D:\ (D:\DB), and TXT Only still doesn't work. It makes the folder, but does not extract the file. Both the Zip and Unzip work. I even uninstalled 2019 and got a 365 subscription. Still doesn't work.

	Richard Rost @Reply 12 months ago
Well, that's weird. Ok. Add some MsgBox's at each line and check your variable values.

	Sandra Truax OP @Reply 12 months ago
Here is my MsgBox results ODestFolder = TXTOnly oSourceZip = MyZip FileType = .txt oItem = Null/blank/nothing

	Sandra Truax OP @Reply 12 months ago
I even update PowerShell to the newest version 7.4 and it still won't work.

	Richard Rost @Reply 12 months ago
How about oItem.Name

	Sandra Truax OP @Reply 12 months ago
MsgBox oItem.Name gave me Kirk, Picard, Sample

	Sandra Truax OP @Reply 12 months ago
Thank you once again, Richard. I had my file extensions turned off in Windows File Explore . It's working now! Woo hoo! Time to get back to work now. I 've spent nearly three days of doing nothing else but try to get this to work, first on my own, the because of one silly setting in File Explore.

	Richard Rost @Reply 12 months ago
Yeah, I was going to say I can only see the file name in your Source zip file. Got to have those extensions working.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Zip Unzip Files 2.