Search results for query: *

Thanks Ties. Have tried creating a crosstab from scratch with same results. Still waiting for feedback from Cognos. They had recommended the same approach in their initial email. Appreciate the suggestion. If any others come to mind, please let me know. Cheers.

We are using Cognos 8.2. Have built a list report based on a SQL query which returns desired rows and results with no duplicates. We then used the 'Pivot list to Crosstab' from the Structure menu to convert to crosstab. We configured the crosstab and it returns rows. However it returns...

Thanks for all responses. I agree looping for the sake of looping doesn't make much sense but that is protocol here. I believe the intention is for job to complete as soon as file is available. Then scheduling the package for the window and looping while check for existence. Actually used...

Hello, I am new to SSIS programming and am working on a project to check if a flat file exists on a file share between 5 and 6pm only. If not there, email failure status to be sent. If there, query flat file and output to another flat file and output to new folder. Then email success...

I have a simple survey form which I am trying to count 'Yes' responses to a series of 15 questions. I am not able to count across the row of data in the Responses table accurately. My formula looks as follows: Totalyes:[question1]*-1+[question2]*-1+[question3]*-1...

Yes I click on the Click button, and the projectID is the primary key for the main table, which all other forms are linked to as well. Its datatype is autonumber. And the 2nd form is available for editing (data entry).

I simply want to continue writing to that record. I have a large table and the records are rather large as well. Say I have general info being logged from the first form then I have a command button linking to another form which will contine writing to the record that I started with the...

Me.Recordset.FindFirst "[ProjectID] = " & Forms!frmnewgeninfo2!ProjectID & "" is in the On Load event of the form.

I appreciate the effort and I did everything exactly as you stated, but it is still not linking. I enter data into the main form then click on the click event to go to the next form and it writes to a totally new record. Thanks for your help

I am now getting an error that Access cannot find the 'Me' macro.

I simply want to link the forms so that the request type form(frmLogo) will continue writing to that record with the logo type, logo size and so forth without the projectID field being over-written. I forgot to mention that all of my forms are linked to the same table.

My Code for the command button: Dim frm As Form Set frm = Forms!frmLogo frm.Recordset.FindFirst "[ID]=" & Me!ID DoCmd.Close acForm, "frmnewgeninfo2" End Sub They are linking now but the second form(frmLogo) is trying to over-write the projectID that is auto-numbered in the first(frmnewgeninfo2).

Trying to pass my projectID field to my next form in sequence. But the following form seems to write a new record. I have it set up with a switchboard for mainly navigation purposes. The users will navigate through forms according to the request (logo, writing, event and such) On the main...