Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: dalex
  • Order by date
  1. dalex

    SQL Server 2005 - general install question

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

    SQL Server 2005 - general install question

    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?
  3. dalex

    How do I export a MA query to tab delimited .txt file?

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

    How do I export a MA query to tab delimited .txt file?

    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...
  5. dalex

    How do I export a MA query to tab delimited .txt file?

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

    sql stmt - load period data from either of two tables

    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
  7. dalex

    sql stmt - load period data from either of two tables

    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...
  8. dalex

    Scheduled Tasks - 0x9400 error code

    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
  9. dalex

    Disable Macro Security prompts in Access 2003

    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...
  10. dalex

    save as and add a timestamp

    Thank you for sharing your knowledge! dalex
  11. dalex

    save as and add a timestamp

    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...
  12. dalex

    save as and add a timestamp

    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
  13. dalex

    save as and add a timestamp

    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...
  14. dalex

    Run a macro each time an excel workbook is opened

    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
  15. dalex

    Run a macro each time an excel workbook is opened

    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...
  16. dalex

    Problem when exporting suppressed sub-reports

    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++...

Part and Inventory Search

Back
Top