Search results for query: *

I have created dynamic links to open excel files within a directory. Everything works fine but as well as opening up the excel spreadsheet into the browser as planned a seperate excel window appears which I don't want. How do I prevent this happening?

Does anyone know how to make this SQL Server qry run in Access? SELECT Destination, CallType, ContractName, ICNumber, SUM(Calls) AS SumOfCalls, SUM(Minutes) AS SumOfMinutes, SUM(DollarCharge) as SumOfDollarCharge, SUM(DollarCharge)/SUM(Minutes) AS DollarCPM FROM DATA GROUP BY Destination...

I currently have the code: Function WriteLineToFile(filename) Set AFileStream = FSO.OpenTextFile(DATA_PATH & filename, 8) AFileStream.WriteLine filename End Function It writes the filename that it is passed to the correct file (which is a .dat file) ok. The problem is that it appends it on...

I have the following code to write a filename (which is passed from elsewhere) to the top line (I guess by making a new line) of a dat file leaving the rest of its contents untouched. This code puts the filename there but seems just to be making a new file as the contents of the original file...

The follwing code copies a file from one location to another. What I need to do is once copied over to rename it as another program is looking to pick up this file but must only be able to when it is fully copied over and not partially so. Therefore once its been copied over I need to perform...

Any help here would be much appreciated. Thanks.

How do I do this?

is this poss and how do i do it?

Need to be able to allow the user to choose a whole folder and load it's contents (many txt files) all at once into the database.

I know this has something to do with GetNextPathName. Need to allow the user to select & load multiple files into a database via the application's File (menu) --> Open. Has anyone done anything similar before?