Recent content by jbphoenix

Go it, with some help from http://www.tek-tips.com/viewthread.cfm?qid=1546142&page=1 Select Convert(VarChar(8), DateAdd(Month, 1 + DateDiff(Month, 0, GetDate()), -1), 112)

I've created an ssis package that does some importing and manipulation. I need to put the last day of the month in my date field. The process is run once a month and no matter when it's run I need to put in the last day of the month. The queries below will give me the last day of the month...

I'm trying to run a dts package from an access form. Here is the code I have but i'm getting an error. Dim dtsPackage As New DTS.Package dtsPackage.LoadFromStorageFile "C:\POS.dtsx", "" dtsPackage.Execute Run-Time error -2147220220 (80040504) The Specified file is not a Package Storage File.

I would like to be able to export data from a query to a specific cell on an excel sheet. I know how to get the data the sheet but can I send it to a specific cell. Here is the code I have to export the data. I would like it to go to cell C10. DoCmd.TransferSpreadsheet acExport, ...

Is it possible to export query results to different excel files. I have several queries that need to go to 5 different excel files. The results of each query need to be on each excel sheet. Currently I'm using the transferspreadsheet command but that way I have to call the query each time.

In sql server mgmt studio, I have a login called z-DM (my general user). I'm not sure what part of the permissions I need to look at. The default db is master. Do I need to change anything in the Server Roles section? Currently I have public and dbcreator checked. Those should allow me to...

I have built a report using a stored proc as the data source. The report has been deployed and I can run it from the reporting services site. I have admin rights. But if I logout and login as a general user I get the following error. "An error has occurred during report processing. Cannot...

I need to join these 2 queries and I can't seem to get it to work select [Part Number], [Invt GLG], (Sum(TEST.CYUsage)*-1) as 'CY', (sum(TEST.LYUsage)*-1) as 'LY' from (Select [Part Number], [Trans Dt], [Invt GLG], case when year([Trans Dt]) = '2008' then [Qty] Else 0 End 'CYUsage', case...

Paul, I tried your suggestion and I still get the same error. I know subqueries are possible. I thought this would be an easy report to try in Reporting Services but apparently I was incorrect. I appreciate everyone's suggestions. They always help get the wheels movin.

I tried switching them to End Case but then I just get "Incorrect syntax near the keywork 'case'." If I run only this part - (SELECT [Part Number], [Invt GLG], Qty, [Trans Dt], 'PYUsage'= case When Year([Trans Dt]) = '2007' Then [Qty] Else '0' End, 'CYUsage'= case When Year([Trans...

Here is my select statement, I'm using sql server 2005. When I run it, I get Incorrect syntax near ')' on line 17 - (the last line). I new to SQL and trying to create a report in reporting services. I'm used to using MS Access. Basically, like in Access, when you can choose a query to the...

Well - I got it to work but I'm not sure why it worked. Here's what I did - I right clicked the image - choose Change To Image and I was able to delete it and paste a different image.

I have a report that was created in XP. We have recently upgraded to 2003. On the report I have an image that was pasted on (unbound object). I want to delete it and put on a different image. However I can't - I get " The OLE server isn't registered. To register the OLE server, reinstall...

Is it possible to pass a date from a form in access to excel? The date on the form is caluculate and I would like to be able to send it to excel.

That worked perfectly - Thanks so much.