Search results for query: *

That's given me some food for thought! Thanks!

Hi All, Is there anyway of monitoring disk activity in a particular folder? Basically, I have a folder and I want to be able to record the file name of every file that is written to this folder or modified within the folder, in real time. Can this be done in VB? TIA :)

LOL!! :D And nope, the file doesnt exist in the working directory! :o That's gonna make me chuckle all day now.... :)

Aha! Thanks GMMastros, I have only just started using the FSO, so had no idea you could do that! :) But PCLewis - I am now REALLY confused as to what Dir$() is doing! If I replace the incorrect file name with some other random text (ie - blahblah.mp3) it works correctly even tho its basically...

OK... so I got it working by comparing the Dir$() result to the original text line (if its valid it will return the file name without the full path, so its different to the line of text but if it is a non existant file it returns the string again so the comparison is true and jumps to the else...

lol, yes I suppose that would be useful...Here it is: Dim Trackname As String Dim fso, TextStream As Object Set fso = CreateObject("Scripting.FileSystemObject") Set TextStream = fso.OpenTextFile("c:\nowplaying.m3u") Trackname = TextStream.readline If Dir$(Trackname) <> ""...

Hi All, Am trying to check if a file exists using Dir$(filenamehere) and this works fine when I pass a filename to it by typign it in manually or even via a variable. However, if I read the filename from a text file using Textstream.Readline, it ALWAYS says the file exists, even when it...

BigTimmin, I hadnt thought of that! hehe that makes my simple app even more simple! :) Thanks!

Genius! Works a treat, thanks Hypetia. :)

Hi All, I am writing a very simple app that will shut my laptop down when the power is unplugged. I am using the Sysinfo Active X control v6 to monitor the status every 10 secs via a timer, but I want the laptop to enter Hibernate instead of shutdown (shell"shutdown -s") but can't seem to find...

Thanks Guys! Much aprreciated! :)

bjd4jc - thats exactly the sort of thing I want to avoid! :) - in this instance, curfile is created by the app, but as it just pulls up a filename, that file name could contain all sorts of nasties!

Like this? CommandText = "SELECT * FROM library WHERE URL = ''" & curfile & "'';" That doesnt seem to work either...

Hi All, I am trying to write some info to an Access Db, it all works fine until the data it's adding contains a ' (single apostrophe!). It then bombs out because now the command line is fragmented. I know in perl (and other languages I believe) you can use place holders to get around this...

Thankyou Bjd4Jc! you have solved it... I am going to stand in the corner with the dunce hat on! :$ The URL field was too short in the DB, I had assumed Access would allow it to be 255 (as that's the maximum), but completely forgot I had to actually define that value myself! doh! Thanks again! :)

Yes you are quite right Bjd4jc, it is the line: rstRecordSet!URL = curfile That is giving the error!

Hi all, I am a n00bi3 VB6 programmer and have written (and/or borrowed!) the following code, it runs fine for the first 12 records it writes to the DB, but after that I get an error saying: Run-Time error '-2147217887 (80040e21)': Multiple-step operation genreated errors. Check each status...