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 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: mharroff
  • Content: Threads
  • Order by date
  1. mharroff

    SSRS 2005 export to Excel

    I am using SSRS 2005 and have written a report that has groupings that are set to toggle based on clicking a field. When the report is rendered by SSRS the grouping is working as expected. When I try and export the report to Excel and open it I do not have any of the grouping toggles available...
  2. mharroff

    SQL2K Log Shipping between 2 Domains

    I have a W2k3SBS server (server1) and a W2kSBS server (server2) both running SQL2k. I need to set up log shipping between these servers. I have tried setting up log shipping per MrDenny's FAQ. However, since these are both SBS I can not have them in the same domain and I can not save the...
  3. mharroff

    Insert Array into Database Table

    I am writing a script that runs a report on a mainframe and then does screen scrapes to collect data for inputting into an Access database. Currently I am able to get the data from the screen scrapes into an array which I then write to my database one record at a time. This is much to slow...
  4. mharroff

    Error 3061 - To Few Parameters

    HELP! Whenever I try to run the code below I keep getting Error 3061 - To Few Parameters when it gets to the set rst line. I have checked the Access Help and it appears that it should work. Dim strSQL As String Dim db As Database Dim rst As Recordset Set db = CurrentDb strSQL =...
  5. mharroff

    Trouble with time

    I need to add then display time as hour and minutes but seem to be having trouble when the sum of the 2 times exceeds 24 hours.
  6. mharroff

    Excel Spreadsheet SaveAs

    I have a need to use Access to open a spreadsheet and then make 1 small change to the spreadsheet and save it as another file name. The filename that I save to is ALWAYS the same. However, everytime I save it I am prompted whether to overwrite the existing file. As this is ALWAYS a yes answer...
  7. mharroff

    Using Access to create excel charts

    I am using Access to create and print charts in Excel. I need to add a trendline to the chart but can't seem to get it to work. Any help would be appreciated.

Part and Inventory Search

Back
Top