Recent content by timotai

I found the solution to my own problem. I hadn't set the Server path prior to the printername i.e. \\serverpath\printer. For some reason this didn't matter in a normal VB.net app but SSIS script task seems to want it.

Hi all I am attempting to create an SSIS package that uses data from SQL Server to automatically create letters. It all works fine except for when I try to change the active printer (oWord.ActivePrinter = Default_printer). At this point I get an error. I have used the same code in a VB.net...

Thanks that worked a treat!!

Hi All I have the following code to transfer objects to other access databases. I have created a form to provide the necessary information such as object type, name, destination to make it easy just to select the options and then transfer the selected database objects. DoCmd.TransferDatabase...

Yeah. If I just open the form it works fine. If there was any other code it would run when I open the database myself. Also if I put the code on a module on another access database it opens up fine. It just seems to be from vb. Its very frustrating.

Hi all This is really strange. I have the following code in an 'on click' sub to open up a form on an access database. But as soon as the database opens and loads the form it then shuts down. I can't see why and no other code is running and there are no macros on the database. If I open the...

Hi all This is strange and I can't see why it is happening, probably something stupid. I have a VB project that Ive just started trying to use in XP (build in NT4). Functions such as String$, Date, Left$, right$, space$, etc will not work. It just keeps giving complie errors. Does anyone know...

Hi all Does anyone know how to get a mailto to send of automatically, in other words not pop up for the user to amend and send. The reason I want to do this is because on our intranet we have a link that sends a mail to a mailbox and replies with another e-mail that has an attachment with a...

HI all I am using the following code to create a table: Set dbs = CurrentDb Set tdf = dbs.CreateTableDef(tabname) Set fld = tdf.CreateField("system", dbText, 30) tdf.Fields.Append fld Set fld = tdf.CreateField("Potential_Availability", dbText, 30) tdf.Fields.Append fld...

Don't worry, I found it

Thanks for the help, but i can't do that as the system is not up the same time every day. I have however got a solution to my problem by use of loops in code. I haven't put all the code in yet but have set up the loops and queries required. I am having a slight problem though. When I run the...

This is very complex and so Im not quite sure how to describe it properly so forgive me if its not understandable and please feel free to ask any questions. All comments and ideas are greatly appreciated. I am creating a database to capture outages on our computer systems. The way it works is...

Hi I have a database which creates a excel spreadsheet. I want to be able to format the colours of the spreadsheet cells fo rthe background and font. However the tricky bit is if there is data in a cell within a given range I want it to be one set of colours and where there is no data I want to...

I found a post with the following code: ActiveSheet.Copy ActiveWorkbook.SaveAs FileName:= _ "\\Resrstredega003\Groupsd2\GIPROJ\TSU\Support Services Weekly & Monthly Reports\WEEKLY_REPORTS\" & Directory & "\" & File & "\" & savename & ".xls" Saves it without the modules. Thanks so...

Im using excel 97. I am creating it by using the savecopyas method and then reopening the file to edit it. I have been trying and trying. One idea I have, but don't know if/how it is possible. I was thinking if I could export the worksheet and save it under the name I want there wouldn't be any...