Search results

A few questions. Is it possible through a query in the subform property to reference two different tables without issue? The reason i ask is once i do this none of the items in my subform show when the subform is called up. Maybe the problem is how i have the relationship setup. I have...

dang it, thanks.. i was looking and looking and.... well i guess i have no excuse.. thanks for opening my eyes.

its on sheet one and the formulas reference sheet 2.. you can see the formula setup on sheet two is fine.. but sheet one in the prm area ..well i must be missing soething

i guess i didnt write that right. what i ment is im still looking at one table of data. but if the formula exists on another sheet different from that where you have to reference the data table by sheet!xxxx then the forumla does not work.

where is the difference in the formulas you copied? "I think you have a problem in your formula consruct as well, if I understand your intention right =SUMPRODUCT(--(Sheet1!C2:C1000="prm")*(Sheet2!F2:F1000="3")) should read =SUMPRODUCT(--(Sheet2!C2:C1000="prm")*(Sheet2!F2:F1000="3")) "" I...

ok i can get this to work =SUMPRODUCT(--(C2:C1000="CRM")*(F2:F1000="4")) on the second page.. perfectly.. as soon as i try to put the formula on the first page i get 0's =SUMPRODUCT(--(Sheet1!C2:C1000="prm")*(Sheet2!F2:F1000="3")) is there an issue with the second formula

also, if that can be accomplished is there a way to have two date cells within the front excel sheet populate the criteria on the query? Right now i just hit refresh and input two dates and it populates the second tab.

i have tried {=COUNT(IF(C2:C700="crm",IF(F2:F700=3,"")))} {=IF(C2:C700="crm",COUNTIF(F2:F700,"3"),"")} =SUM((C2:C700="prm")*(F2:F700=3)) i have been unable to get dcount to work

that makes sense to me but let me break it down. I am just trying to do a count of the items where it equals crm and 1 then its a crm new and goes on the first tab. So it has to do the whole column and each formula i would assume would be slightly different based on the criteria.

As i am not a vba pro I am trying to do this within excel as a formula. You can see the summar sheet up front and the data is on the second tab. I am trying to pull from the line of business ex crm prw and transaction type. where transaction type 1 =new 2 = renewal etc. on the second tab i...

you will like this.. i have a friend that is on another access board that has helped me big time.. i sent him a copy of the db and he had no issues.. upon sending it back and relinking it now works for me.. i have no clue if this is an access fluke or do to the fact he might be using 07...

yes all tables are linked to the tblMainHeader

nm, I am lost as i didnt think that item would be required on the main form as the if statements reference the transaction type and subform

i guess i can understand that but if that was the case it would have never worked to begin with. what i noticed is that scrolling through the policy numbers will not scroll the sub forms but the transaction type number and lob should pull the subform. I thought it would be an issue with the if...

I have attached a copy of the db. You can scroll through the items and even search within the policy field and note that only one policy number pulls the subform info up which is confusing me as to why the rest arent. The policy number is 1092467. If you look at the tables the data is there...

GO Figure the old SELECT tblPRMNew.*, tblMainHeader.EnteredbyMGI FROM tblMainHeader LEFT JOIN tblPRMNew ON tblMainHeader.MainHeaderID = tblPRMNew.MainHeaderID; the new (that works) SELECT [tblCNRCancellation].[CNRCancellationID], [tblCNRCancellation].[MainHeaderID]...

ok i just tried copying a field and changing the record source. I got the #name? listing within the box and then i did a select query for the form. Wow it saves and still opens but still with the #name? sign. Is access hard coded once you use the wizard to that one table? it seems as if the...

i tried to search this but wasnt sure on the phrase to search by. My issue is I have about 20 individual forms each which are unique to a table and those tables unique to one parent table. I have created a main form which pulls the universal items from the main parent tbl and matches based...

so looking at the mdb i uploaded it is overkill to have the form coding pull from the module? I guess everything should be listed within the form? Still new to this and going off of other items ive seen just to give you my point of view. I did not know the find/next commands could be as...

I checked the name under the form properties.. im out of guesses Option Compare Database Function GotoFirstRecord() On Error GoTo Err_cmdGotoFirstRecord_Click DoCmd.GoToRecord , , acFirst Exit_cmdGotoFirstRecord_Click: Exit Function Err_cmdGotoFirstRecord_Click: MsgBox...