Search results for query: *

I'm trying to use a form Control in a Form which I pass to a report header. This is a variable used in the report. The Form Control is [Forms]![checkmax]![WeekNumber] The DataSource for the report is called [ModeMasterTbl] where [Week] is a field in the table that I want to use to summarize...

I'm using an expression in Report field which aggregates 13 departments. I added one dept at a time to make sure this method was working. When I added the 13th dept my calculation returns #error. =(Sum((IIf([ModeName] In ("Admin excl IT","IT","Police","Mobility","Core Support excl Fac...

I have a text Box on a report with following calculation. [26] represents Week 26 on a Union Qry of crosstab queries which is the data source for the report. =Sum((IIf([ModeName]="Bus Transportation",IIf([CYBudPY]="CY",(([26])),0),Null))) This works fine. In the Header of the Report I have...

I have a crosstab query which is returning a new record for each column header instead of 1 row per Mode.Name TRANSFORM Sum(WK_25_OT_Qry.SumOfEXPN_AMT) AS SumOfSumOfEXPN_AMT SELECT Mode.ModeName FROM CalendarPayroll_TY INNER JOIN ((WK_25_OT_Qry INNER JOIN SOF_Dept_Roll_Up_Tbl ON...

I am trying to combine a variable defined with my strObjectName to customize the report name which will be sent to many differnt recipients: DoCmd.SendObject acSendReport, strObjectName, strOutputFormat, strEVPFEmail, "", "", "May Scorecard", _ "Attached is your May 2017 Scorecard. Please call...

When running a program with this output statement: DoCmd.SendObject acSendReport, "strObjectName", "PDF Format (*.pdf)", rs("strEVPOEmail"), "", "", "May Scorecard", "Attached is your May 2017 Scorecard. Please call with any questions. Thank you.", False I receive a compile error: Sub or...

Is there a method I can use for alternating shading on the background of a report header? I have 4 sections on a header with a Unbound text box, shading that and then send to background with the control boxes sitting on top. Is that possible in an Access report ? Thank you in advance for...

I have a form which allows the user to select a drop down filter for several roles in a company (think SVP, VP, ect.) After user clicks a the Combo box filter and selects a name within the values list, a VBA procedure is run that creates a [propertytbl] containing all properties and there...

I am using a combination of excel functions(MID, FIND, LEN) to convert cell A1 from FirstName LastName to LastName,FirstName. A1_______________________C1 FirstName LastName LastName,FirstName Formula in C1 =MID(A1&","&A1,FIND(" ",A1)+1,LEN(A1)) What I need is a space before the FirstName Any...

I have an excel function which converts cell A1 from First Last to Last,First. A1 C1 FirstName LastName LastName,FirstName Formula in C1 =MID(A1&","&A1,FIND(" ",A1)+1,LEN(A1)) What I need is a space before the FirstName Any suggestions for revising the function...

Using Access 2007 and trying to recycle a method I've used for several years in prvious versions of Access. After Updating a parameter on a main form I want to pass query logic into query named qdf and make table from the parameters in form. I am receiving Run Time error 3141: The select...

I have a make table query containing a 3 digit numeric field which I would like to update to text. How do I convert this to text in the Make Table Query? I've tried placing Format([numericField],000) in the property sheet of the field but this does not work. Any suggestions for handling this...