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!

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

Recent content by ghost2

  1. ghost2

    Deleting Rows in Excel File and the Exporting results again?

    Thanks alot Jamie. I will try that. Thanks.
  2. ghost2

    Deleting Rows in Excel File and the Exporting results again?

    Good question but the users want to use Access where I am creating some easy to use selection forms where I am then I want to pass the parameters into the query. I could use a crosstab query instead of excel but I feel the users will have more control over the excel file if I output to excel...
  3. ghost2

    Deleting Rows in Excel File and the Exporting results again?

    I know I can run a macro and specification to export results from a query to an excel file. Is there a way to purge the existing records in the sheet and then export the results? I have a pivot table that is set to refresh on open so I can't just delete the file I need to actually have the...
  4. ghost2

    How can I update field that is time to get rid of 1/1/1900?

    That still attaches the date to it.
  5. ghost2

    How can I update field that is time to get rid of 1/1/1900?

    I have some time fields that I have to run a quick update to just get rid of the 1/1/1900 before the time to just the time? Any ideas all. Thanks
  6. ghost2

    Date Quesion getting AVG by Week. Help.

    Thanks guys so much. TJRTech is there a way to work around it?
  7. ghost2

    Date Quesion getting AVG by Week. Help.

    Hello all. I have a query where I am getting a total QTY by month/year. I need to now break it up into weeks. Is this possible? Thanks all. Here is the functions I am using for year and month. Year([DateShipped]) AS [Year], Month([DateShipped]) AS [Month]
  8. ghost2

    Running Command Line call from stored procedure?

    Here it is resent with the actual bat I think I took another example: for /f "delims=: tokens=2" %%I in ('ipconfig /all^|find /I "DNS Servers"') do call :SETDNS %%I @echo DNS server is %DNS_SRV% goto :DONE :SETDNS if NOT {%1}=={} ( set DNS_SRV=%1 @goto :EOF ) ELSE goto :EOF :DONE c: cd...
  9. ghost2

    Running Command Line call from stored procedure?

    Can I pass a parameter that way though with just calling the bat file?
  10. ghost2

    Running Command Line call from stored procedure?

    I do need a parameter in the msg piece like in my first posting.
  11. ghost2

    Exec Command Stored Procedure

    How do you surround a single quote in an exec command to get it to stay as a single quote and not close the string?
  12. ghost2

    Running Command Line call from stored procedure?

    Jay if I have a bat file, how can I get that bat file code into my procedure? For example here is the bat file code which has some single quotes in it. How can I run this code within a stored procedure? Thanks so much for your help. Then I will pass how you showed the variable. for /f...
  13. ghost2

    Running Command Line call from stored procedure?

    Hello all. I have a batch file that I want to call based on criteria in a stored procedure. How do I within an IF statement switch to the command shell and run command shell lines? Also is there a way to pass into one of the command shell lines a variable? I have a program that auto emails...
  14. ghost2

    Install Issue Tried Installing and it failed. Help

    It never completed though and under Add/Remove programs I do not see anything for Visual Studio or VB6?
  15. ghost2

    SQL Syntax Question

    Thanks alot guys..:)

Part and Inventory Search

Back
Top