Search results

it sounds like you are missing your hidden textbox on the form. It needs to have TransactionID as it's controlsource and it needs to be named TransactionID. The #Name means it's not finding the name you specified.

put a hidden textbox on your 24462 form and give it a controlsource of TransactionID. Then you line will look like this. =DSum("[DepositAmount]","24462","[TransactionID] = " & Forms!24462!TransactionID & " AND TranactionDate > #" & DateAdd("d",-30,Date()) & "#")

=Me.Name & " (" & Me.idnumber & ")" try this... also make sure that Name and idnumber are actual fieldnames in the recordset of your report

create an unbound text box on the report. in design view click into the text box and type this (replacing field names with your own of course). =[Name] & " (" & [idnumber] & ")" make sure you have that = sign in there.

it is based off of a query, I even went so far as to create the sql at runtime and try to set the report's recordsource to the sql but to no avail. Any other ideas?

check out this URL http://infoframeworks.com/BW/SAP_BW_3rd_Party_Access_ETL_Tools.htm

i've never attempted what you are trying to do, but the only logical way i could see to do it would would be to iterate through an ADO recordset object and assign each index of the array to the recordset as fields...open the report in design view and assign the recordset object to the report...

i didn't look at your database, but a simple DSum function should do the trick. I believe you can put this straight into a text box's control source. =DSum("[fldTransAmount]", "tblTransactions", "[CustomerID] = <customerid> AND TransDate > #" & DateAdd("d", -30, Date()) & "#") i tried to make...

explain SAP please and I may be able to help.

Has anyone seen a report come up blank the first time it loads? Basically I have a delivery ticket report with subreports on it that show line items. The subreports get their data just fine, but the Header section of the report doesn't show any data in it. I can close the report and re-open it...

Create a form called frm GetQuery put a text box on it called txtQueryName. Then create a button and just put a caption that says show table. Now create a module and put this function or one debugged in it... Public Function OpenMyQuery(strQuery as string) Docmd.OpenQuery...

you should read the docs on how to create a where clause... when you open the report you can add in a where clause in vb docmd.openreport "ReportName", acViewPreview, , "CustomerID = " & Forms!MyForm!CustomerID this will limit your one big report with all customers down to one customer id

IIf(IsNull([forms]![SEARCH]![SECTION]),"[Located in].[SECTION]=’*’" ,"[located in].[SECTION]=[forms]![SEARCH]![SECTION]") try this one

ValveResult: IIf(797 In (SELECT tblOptestTable.TestResultID FROM tblOpTestTable WHERE tblOpTestTable.WorkorderID = [WorkorderID]),"Failed","Passed") This is a field in a query... i'm using grouping for the unique WorkorderID then i'm trying to get whether any one of the test results for this...