Search results

  1. G

    Deleting directories and subdirectories in VBA

    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...
  2. G

    Copying Files, Creating directories in Access

    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?
  3. G

    Mute Button

    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.
  4. G

    How to write a txt file based on table info?

    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
  5. G

    Variant = Null = not working right!!!

    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'...
  6. G

    Free Jukebox for helpers!!! -Question set #2

    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...
  7. G

    Shell function not working! :(

    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)
  8. G

    Free JUKEBOX to those who can help me!

    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...
Back
Top Bottom