Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: JimStrand
  • Content: Threads
  • Order by date
  1. JimStrand

    Trying to Use Form Control as Variable in Report Control Source

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

    Expression Limit on Sum IIf In Method ? Used in Report Calculation

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

    Using Report Header (Form control) as Variable in Report Expression

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

    Crosstab query - returning 1 record per week instead of 1 record

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

    DoCmd.SendObject (dynamic strObjectName naming syntax)

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

    DoCmd.SendObject Compile Error - Sub Or function Not Defined

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

    Method For Multiple Background Colors on Header of Report with Labels and Text Boxes Visible

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

    Modify VBA routine to pass Form combo box value into Tbl created by event procedure

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

    Convert FirstName LastName to LastName,FirstName using MID,FIND, LEN Function

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

    Excel Function LastName,(Space)First Name

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

    Using qdf.SQL method in Access 2007: receiving Run Time error 3141

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

    Update Numeric field to Text in Make Table Qry

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

Part and Inventory Search

Back
Top