That is not a bad idea, then I can pass the needed extensions through a loop based on the on/off field for the extenion. That would also make it VERY easy to add more extensions as I develop the software.
Nico, AWESOME suggestion, I had not thought of that.
Extension definition table it is, then loop through the valid record for the filldirtotable function.
THANKS!
CJ
Airtech
Last Activity: Jan 11 '09, 06:21 PM
Joined: Apr 21 '07
Location:
-
What I am trying to decide is how to feed the multiple file specifications to the function.
On one hand, I can build a list of extensions and parse them out into an array and loop through the array. This benefits users of the program in they would directly choose the file types.
Alternatively, I could ignore the filespec, and use the procedure as written and cappture all files, then discard (which I already have a routine...Leave a comment:
-
Filespec for searching files and directories
I am using the AllenBrowne code of "filldirlisttot able" to provide some functions for a media library manager I am building in access 2003.
I have four checkboxes which if all four are not turned on, give a list of extensions that should be search for. However, when I do it that way, I get no results.
The code works great. Only one issue, I cannot find anywhere on the net any notes about using the filespec option.... -
Don,
OK, I am adding to this one, because what this solution resolved, lead to another issue. I suspect you will probably have a fast answer.
I am using the AllenBrowne code of "filldirlisttot able"
The code works great. Only one issue, I cannot find anywhere on the net any notes about using the filespec option.
By default it uses *.*, and I can make it work by specifying only one extension,...Leave a comment:
-
I will actually have to use the other one, because the default is to scan all files.
But you are right, and either way should be perfectly functional.Leave a comment:
-
I seem to have found a pretty effective workaround. What seems to be happening is that the check on chkKaraoke isn't taking, and the logic was having trouble with the fact that it was Null, so I added the following code for this and seem to have a workaround, that stops generating errors, you just don't get the check mark,.
If IsNull(chkKarao ke) Then
GoTo MediaString_Exi t
End If
While not ideal, if this...Leave a comment:
-
Thank you for sending this, I see where I got the intention of your original suggestion built with a couple mistakes. I still get the error on chkKaraoke, but I think I can put in some handling.
This looks like it will work great.
THANKS.!!!!! I appreciate your help.
CJLeave a comment:
-
I had to tweak the first one, to try and get the formatting right, but that doesn't seem to to the trick either.Leave a comment:
-
I see what this is trying to achieve and it is working but only partially.
I get lots of errors on the fourth check box about being null, and it doesn't quite work if the audio option gets turned off.
I have the code below:
...Code:Public Sub MediaString() If chkAudio Then If ScanExt <> "" Then ScanExt = ScanExt & "*.mp3, *.wma" ElseLeave a comment:
-
Evaluating result of a variable from multiple checkboxes
I have a routine that searches a directory structure for files. Right now the file pattern is simply *.* and when it is finished, I have a cleanup routine that strips out the file extensions that I don't want (*.m3u, and files which the routine will flag as 'unknown')
What I would like to do is to populate a variable with the acceptable file extensions based on the users choice.
For example, I setup four checkboxes,... -
Also, this may not be quite as clean as it should or will be in the end, but the core functionality is what I am trying to do.
I suspect from your answer, you may have a better idea of how to handle this.Leave a comment:
-
OK, here is the code I have so far, this lists the tables that are linked into a collection each is referenced by an index, and the code which will extract the table name, and its current link from that indexed entry.
Then what I do is run a check to see if the referenced file exists.
This is where I start to run into trouble. If the file exists, then I would simply keep going through the collection until I came to a table which had...Leave a comment:
-
Linked tables in MS Access 2003
I am building a media management tool and starting it in Access 2003.
I have various linked tables, and have sufficient code to loop through my list of linked tables to verify that the data file specified in the link is available in the specified path.
I am trying to finish this portion of my code to handle the table(s) whose links are broken because the specified file no longer exists.
Can someone suggest how... -
Executing VBScripts from VBA in Access 2002/2003
I am developing a database in Access 2002/2003 for use in Configuration Management. The application has reach the point where users of my application need to execute scripts in various formats.
I know that I can use the Call Shell command to execute programs and batch files, but I cannot seem to find how I can execute a pre-existing vbscript. The VBScript that I am trying to use initially ping a list of machines from a file called...
No activity results to display
Leave a comment: