Search results for query: *

That was it! Thanks Denny; you've been a big help!

I just installed SQL Server 2005 Standard Edition but cannot find SQL Server Management Studio in my windows list of programs. Is SQL Server Management Studio suppose to install with SQL Server 2005 Standard Edition? If not, should I just obtain it from the MS site?

Thnak you. I am good now. Your small assistance has made a big difference. Thanks again,, dalex

Thanks Remou...I am now very close to where I want to be. My only challenge now is that the file exports as a csv; I need it to export tab delimited. I think I need to control this via the Specification name box, however I am not sure as the specification box gives me an ambiguous list of drop...

How do I build a macro that exports a Microsoft Access query to a tab delimited .txt file?

nomadicalloy, Could you expand on your response and provide a little more info as to how this syntax will resolve my issue? What does this syntax do? Thank you, Dalex

Hello, I seek SQL syntax that would help me achieve the following: If current month = Aug, then get data for all previous months,(i.e Jul, Jun, May, etc...) from the ACTUALS table. Else pull data for the months from the PLAN table (i.e Aug, Sep, Oct, etc...) Please let me know if I can...

Hello, Might someone know what the error code 0x9400 signifies? I received this error code because a process failed in Microsoft Task Scheduler. I've searched the web extensively and connat find good documentation on what error codes signify for Microsoft Task Scheduler. Thanks, Dalex

Hello, I run a script each evening which opens an access 2003 database that automatically runs some queries. Although I've set the security level to Low, I get with two prompts: One prompt asks if I want to block unsae expressions...I want this to go away. The other prompt is a security...

Thank you for sharing your knowledge! dalex

Right now the code sits in 'This Workbook' with the 'General' option selected. Should I copy this into a module, and then put the Application.Run command within the 'General' page? Maybe I should read up on the difference between Workbook and General...

Thanks...I learned the way you suggested and it was easy...it worked. Now I have a copy of the file...excellant thank you! To complete this, could you help me with code that will execute the macro when the file is opened? Dalex

Hello, I have a file called Main.xls. I would like to learn of some code that, when opened, will save a file called "Days.csv" to "Days (month, day, year).xls". In simpler words, my objective is to obtain a code that will take Days.csv and copy it as a new file with the same name but add a...

Correction: My ultimate goal is when auditmaster is opened, it makes a copy of a file called weekly.csv, runs a macro called 'compare', and finally save it as weekly.xls(date and time) Thanks, Dalex

Hi, I've searched the forum and found similiar questions, but all seemed much more complexed than what I need: I want a solution that, each time a file called auditmaster.xls is opened, runs a macro called 'compare', and then saves as a new file and adds the date and time to the name. Please...

Hi there! I have one report, containing only subreports, and depending of one paramether in any moment some of them should be shown. Every subreport is suppressed. The problem is when I try to export this report to rtf format from my code - the final report is blank. I am using CR 7.0 and VC++...