I found an old subject that shows how to delete files and folders. However, it only shows how to delete folders if you know the name. How can I delete all folders (in a certain location) and their subfolders, without knowing the names? Basically I need to automate clearing out a certain folder...
Well a user previously gave me the code to copy files using access. Now I need to delete files and create folders using access. If I could find the commands in either Access help or one of my two extremely thick access books it would not be a problem!
Anyone know where I can find these commands?
Is it possible to have volume control from an access form? All I want to do is have a button that can enable/disable the sound on the computer. More or less, a mute button.
I need to be able to write a text file based on data from a table/query. So for instance if I have 3 table entries, I need to write something like this:
Table Entries:
45
12453
332
Text file to write:
[some header info]
C:\softjuke\files\45.mp3
C:\softjuke\files\12453.mp3
C:\softjuke\files\332.mp3
I used the following code to look for a dulicate entry in a table vs a field on a form. Everything seems to work ok, BUT I'm trying to use and IF THEN statement based on the value of a variant, and it doesn't work at all! If the variant = null then the intSkip = 2. If the variant = 'something'...
OK just so there's no confusion this jukebox i'm referring to will be an access database, not real hardware.
For those who have been helping, thanks ALOT
Now I have a couple new problems. I've never had to do tasks quite like these so I'm not really sure what direction I should go in. If you...
OK so can anyone tell me what's wrong with this code? When I run it I get an 'invalid call or procedure' error.
Dim strSong As String
Dim RetVal
strSong = "C:\softjuke\files\28.mp3"
RetVal = Shell(strSong, 1)
OK just so there's no confusion this jukebox i'm referring to will be an access database, not real hardware.
My project: I own almost 800 CD's. I'm writing a database, that will have these CD's embedded into the tables. Once the music is placed into the database, there will be a type of...