Recent content by ihaveaproblem

Philote, I am interested in you problem as I also have a a similar query but in windows server 2003. It doesn;t seen to run when the server is "logged off" do you have any idea of why this happens? I have looked at implementing the solution you found but I don't know wher the option...

This question relates to Windows 2003 server - but i cannot find a forum for it. I have tested it and it appears to me that it doesn't. Does anybody have any suggestions on how I could get this to work. Or reccomend any decent 3rd party freeware I could download to run the tasks required.

I have generated an app which does some overnight processing. As part of this I am writing some specific results and any errors to a couple of log files. Trouble is these are writing to the bottom of the file as default. Does anybody know how I would write these simple messages to the top of...

Thanks again. I had managed to work that one out but i'm now stuck on the opposite problem to which I cannot work out the solution. The problem is sometimes a record has been deleted, so once the code hits this all the corresponding rows are out of sync and therefore flagged as different. I...

Hookbob, Thanks for that..it works a treat! The only thing I need to work out now is how I determine if new records are added to the latest csv extract and add these to the diffs file as well. I should be able to sus this out, but if you have any ideas let me know. Thanks again

I need to compare 2 large(ish) csv files which change on a daily basis. Once I have compared them, if there is a difference in ANY field I need to write the WHOLE of the correspondin record to another file. The data contains approximately 1000 records and each records contains over 50 fields...

Does anybody know how to get a list of liles into an array using the DIR$ command. It needs to also read a varying number of subdirectoires which change on a ad hoc basis.

I have a series of documents which include an address as part of the main body. However these documents are stored on servers in a number of regional offices. Does anybody know how I could create a Macro/some VBA code to identify where each user is based and insert the correct address. Ideas...

Form a scheduled NT Task i am calling a access database, which inturn then calles a a batch file using the Shell command to connect to a ftp server and transfer a file. When I run this from access it workes fine, however when I run the scheduled task it hangs when trying to open the ftp server...

I am getting a errormessage saying: "ActiveX component cannot create object" When I try to execute the following statement. Set crApp = GetObject(, "Crystal.CRPE.Application") This was working fine up untill recently. As far as I am aware the required DLL is registered...

Is it possible to FTP a file to an external IP address by using code in VBA?

I need to create some code in VBA to automatically kick off another function twice daily. Can this be done in VBA as I connot find the timer object I have used in VB^ in the past? Any ideas anyone?

When I try to export a Crystal Report Via VB6 i eventally receive a message which states "Cannot open SQl Server" I have created a connection to SQL Server and the connection is open. Do i need to explicity specify somwhere in the code a connection between Crystal reports and SQl...

Can anybody help! I am trying to call a Crystal report and export it from access(as i don't have VB6). I have managed to conncect to the report but when I run the export command it asks me to save the file but then says "server not yet started" the crystal report access a SQLServer...