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 strongm 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: *

  1. kalvis

    Package executes manually but not with agent job on SQL Server

    I initially executed the package locally from my own machine. But, after developing the package and exporting to SQL Server. I ran it directly from Management Studio on the server. I am going to go back and see which version of PDFSharp I used. Since I developed locally on my 32 bit machine I...
  2. kalvis

    Package executes manually but not with agent job on SQL Server

    Created and SSIS package in VS 2008. The package contains a script task with a reference to an assembly for PDFSharp. I ran a build on the script containing this assembly. After saving the package changes I ran a build on the project containing the package to create the manifest file for the...
  3. kalvis

    Selecting most recent date of joined table

    These blogs were extremely helpful Markos. I appreciate you giving the links. I would much rather learn the methods opposed to having it given to me. Not that it matters but I ended up going with the Windows Function - One Stage query. Now that I have a solution and can get my report out I will...
  4. kalvis

    Selecting most recent date of joined table

    I am using SQL Server 2005. I have two joined tables one for Accounts the other for Work Orders. For each Account there can be many Work Orders. A simple example of this data structure would be the following: Accounts Work Orders -------- ------------------- 100 100, 1/1/2009...
  5. kalvis

    Date Parameter for Previous Work Day (No Sat. or Sun)

    Both solutions you proposed worked perfectly. Thank you very much for your help!
  6. kalvis

    Date Parameter for Previous Work Day (No Sat. or Sun)

    I am using MS SSRS 2005. I created a report with two date parameters for From and To to filter for all records on a specific day (normally yesterday). The parameter Non-queried default values are currently set to DateFrom: =format(dateadd("d",-1,Now()),"M/d/yyyy") DateTo...
  7. kalvis

    Access Controling Excel

    Maranello, take a look at Thread 181-121256. Databaseguy addresses this issue in detail with some helpful links to Microsoft Knowledge Base. This will probably answer the questions you have about automating Excel. Good Luck!!!
  8. kalvis

    Is a Listbox rowsource the same syntax as ado recordset source

    I have a form with text boxes that a person can enter information in that is then used to search a table. When a "Load" command button is pushed a SQL statement is built using the info in the textboxes. This SQL statement is then used as the rowsource of a listbox. I have another...
  9. kalvis

    Access Violation-PLEASE help

    If anyone can help me out with this I would be eternally greatful. While I was off last friday someone doing data entry into our database control-alt-deleted to exit as the database hung. When she tried to re-enter she received the following message "MSACCESS.EXE has generated errors and...

Part and Inventory Search

Back
Top