WOuld somebody please help? I am really stuck at this point... thks!

Wow... you are the best... it works perfectly...

Thanks!

Hi Dave Balsillie,

Thanks for the reply!

What I am try to do is to conditionally format the numbers in my report. I can easily do IIF(ReportItems!textbox100.value <0, "RED","GREEN") in the...

Is there a general way to reference to a textbox without name it? For example, I want to check to see if value of a textbox is positive or nagative,...

Thanks JeffB,

The two tables, s and p, both have historical and future data but contain two sets of different data, linked by date and accountid columns, and I FULL JOIN them because...

Jeet... Thanks for the info... I can't use cmdshell though.

Ally MacKenzie,

How do you call a batch file without using cmdshell?  Please educate me on this.  This is the exact problem...

Jeff, thanks man.... It workssss...

Hey Phillcart... thanks man!

Mark,

Good catch! I should have it as <=7 instead.

Thanks!

Johnronwan,

Nope... that is not what I want. My DTS package will run every Saturday, but on the first SAT it will do a little bit different. I want to identify...

Jonathan Stokes,

I don't know why when I use dtsrun /S servername /U username /P password /N packagename, I got an error like : "DTSRun:  Cannot create COM Server to load...

I really got a headache. 

What I am trying to do is to open an excel file automatically, so the macro in this excel file can do some stuff for...

Do you think if the server where I run my query has problem with .bat files?

I once got error with ACCESS DENIED, but one time yesterday, I re-tested it again...

how do you write a .bat file to run Excel executable? Please help!

Thanks!

What is DBO?

I have no clue on how my windows account set up because I did not set it up.

mang... this problem is killing me!