Search results

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.

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

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

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.

Ok - we just upgraded from office xp to office 2003. One user opened access and tried to use a form with a pop up calendar on it but when they clicked on the combo box tied to the calendar a run time error 2683 "there is no object in this control" comes. I think it is the active x control but...

I have a form with a Date field. That date field is defaulted to = Date(). That works fine. Also there are a series of User Initial and dates boxes next to several question. So basically after a step has been completed the user enter's their Initials and the date is automatically filled in...

Here is some sample data ProductLineTransAmountTransDateCustomerNameGL$10.0020080715DATSB$15.0020080715DATSA$20.0020080715DATSH$25.0020080715DAOTH$30.0020080715DA Here is a copy of my statement - 22: IIf([ProductLine]="GL" Or "MGL" Or "SBL",[TransAmount],0) Now here is the result...

I have a list box that on a double click populates a subform. But to help prevent duplicate data I would like to have a message box open based on query results. If there is already a record in the table with a matching RMA and Part_ID I want a message box to open and ask the user if they...

Ok this one has me puzzled. I split my database to try out it and see how it works. I have a form where the user enters an RMA number then clicks a cmd btn which runs a query. The query runs fine. However the results get displayed like they are a form in datasheet view. It has the record...

I've got a subform (frm_Edit) in datasheet view. The record source is a table. The main form (frm_RMA) has a combo box whose row source is - SELECT tbl_RMA_Inspection.RMA_ID FROM tbl_RMA_Inspection GROUP BY tbl_RMA_Inspection.RMA_ID; I need the user to be able to choose an RMA number from...

Is it possbile to click a btn to run a query then follow a hyperlink? On my form is a part #. Each part has a drawing associated with it. The drawing file is located on a server. The location of the drawing is stored in the part table. My form's control source is QA_tbl. I have a query set...

Ok - I'm stumped. I've been assigned a task of having a query export to excel. Not a problem but the button has to on a form someone before me created. There are 2 btns on the form. The first one (Preview) opens the report. The second one I created (Command7). Command7 runs a macro that...

I have 2 forms setup. The user enters a part ID and date range then clicks a button to display the results in a listbox. From there I would like the user to double click the record they are looking for and then have the other form open so they can edit the record. I can get the second form to...

I have a linked customer address table in my DB. In this table I have thousands of customer names that start with an *. I * was used in the past to distinguish between ship to and regular addresses. The * is no longer used and is causing problems with searches. What a surprise, I know. I'm...

I'm running an update query and I get this error - Function Sequence Error. (#0) I have an excel spreadsheet that I imported into a table. I am trying to update the part table with date from the spreadsheet. The part id is unique and thats how the tables are joined. I only need to update 5...