Search results

Could you please provide an example using these vars? var_file = "c:/file/anotherfile/test.wav" 'then can you give me an example to parse it Thanks!!

Hi! I have a string right now: c:/test/anotherfolder/hello.wav and I want to parse it to "hello.wav", and cut off the rest. I tried using fso, and just decided to settle on just parsing the file name, to hello.wav. What code should I use to make it cut everything before the last "/" out , and...

Thanks! The only problem now, is that I have a file path already in my database: c:/file/file.mp3 which I want to change to c:/testfile/file.mp3 How can I parse the file name out of the statement above? Like, from a string, called dir_file( which is = to c:/file/file.mp3) to file.mp3? Thanks!

No, actually I was thinking of something like this: http://www.imagehosting.com/out.php/i834473_ACC2000UIForms1.JPG

Hi! So this is the code I'm using to copy a file: Dim fs As Object Dim oldPath As String, newPath As String oldPath = "C:\" 'Folder file is located in newPath = "C:\test" 'Folder to copy file to Set fs = CreateObject("Scripting.FileSystemObject") fs.CopyFile oldPath & "\" & "test.mp3", newPath...

Awesome! That works on most of my fields, except, I have one field which is numeric, and it doesn't work, and I have one field, which is a check box, which brings up a dialog asking me to enter a parameter or something. How can I use the sort for check boxes? Thanks.

I'm trying to find out the statistics of my dabase: # of total items # of unique items from 4 different criterias When I put that into the queries, using the count function, it works well for 1-2, and then if I add in more into the query, it gives ridiculously high numbers for the counts, and...

How can you make a form without any window around it? It seems to be really cool.

Awesome! This works well. The only thing is though that null values come up to the top. Also, it'd be cool if an small arrow, pointing up, or down, will sort by it, you know like in many databases. do you know how to do that? Thanks.

Could you please give me an example of it? I have an autoprimary key, and I'd like to find a record based on the primary key.

I have a form right now, which is connected to a database table. How can I make it move to a specific record, for example, record #1? Thanks.

Sorry...I couldn't find that code. Could you tell me where I can find that? I searched the entire project for it. EDIT: sorry again! I fixed it. Thanks for the awesome code.

Hi! I have a form right now, which links to a table with 1000 or so records. I currently have a search page, and the search works well, by using an access filter. I'm wondering how I can sort. Is there a command for it? How can I use it? Thanks.

What's the best way to put a picture as a background of a form? I'm tried by doing it in form properties, but the picture is smaller than the actual size. When I import it through the toolbar, it goes over all of my controls. Is there any "arrange button"? Also, how can you have a form be...

How do I undisable the 2nd tab? I'm kinda having trouble with that.

Thanks. Is there any way I can mod it? Like are there any picture files for it? Where can I change the colors? Thanks.

Oh. ok. Thanks! Are there any other visual styles for the tabs? do you have other examples?

Oh. Ok. So, to clarify, it would work like this, tbl1: 1 | title1 2 | title2 3 | title3 4 | title4 tbl2: 1| c:\file1 2| c:\file2 3| c:\file3 3| c:\file32 4| c:\file4 4| c:\file42 4| c:\file43

But, this still has the old tabs underneath it. Is there anyway to hide the old tabs? Thanks.

Thanks for the overwhelming response! To clarify: so I have a couple of records: 1 | title1 | c:\file1 2 | title2 | c:\file2 3 | title3 | c:\file3 ; c:\file32 4 | title4 | c:\file4; c:\file42; c:\file43 BUT, titles will have UNIQUE files. So, files will be used ONLY once, but each title can...