Recent content by Shananarocks

  1. Shananarocks

    Yes. You can filter a multivalue field in VBA using the IN() operator function

    I was just doing my own database and found that I can actually filter multivalue field using the IN() operator. Basically I was filtering a multivalue field named "Workyears" So the filter is: rs.Filter = "[Workyears.value] IN" & "(" & wy & ")" (since I gather that .value will string the result...
  2. Shananarocks

    Solved Createcontrol cannot create Label or Textbox at Header Section !!!

    Excellent solution arnelgp !!! Why didn't I see this "acCmdFormHdrFtr" when I was scrolling the docmd.runcommand Anyway, I also came up with another solution which is to create a form with the header "evoked" and use it as a template in the Set frm = CreateForm(, "MyForm") where "MyForm" is a...
  3. Shananarocks

    Solved Createcontrol cannot create Label or Textbox at Header Section !!!

    Good Afternoon, I am using a subroutine to create a new form and also a label at the "Header" section. The routine below works only if I use the default to create the label control in the Details section. However, it will shows an error if I try to add the label control to the "Header" section...
  4. Shananarocks

    Solved Form does not display total value

    Hi, you can only use sum([TXTAMT]) in a report format assuming the TXTAMT points to a data control source. For a "Form" format, you can use DSUM function which should be as follows: TXTTOTAL= DSUM("[TXTAMT]", "tbl_Name or Qry_Name") ' Note that invert comma positions. Also no criteria...
Top Bottom