User Profile

Collapse

Profile Sidebar

Collapse
mlgmlg
mlgmlg
Last Activity: Nov 5 '13, 01:54 AM
Joined: Aug 9 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • mlgmlg
    replied to Help to modify a macro where condition in Access 2010
    in Access
    Yes, this is the actual macro statment:
    Code:
    ="[task Num]=" & "'" & [task Num] & "'"
    I was try to modify the original macro to add the statement to filter the contractor data as well, but I am having no luck with adding the AND to the end. Ugh! :-(
    See more | Go to post
    Last edited by zmbd; Nov 6 '13, 07:52 PM. Reason: [Z{Please use the [CODE/] button to format posted code/html/sql/formated text - Please read the FAQ}]

      Leave a comment:

    • mlgmlg
      replied to Help to modify a macro where condition in Access 2010
      in Access
      Hi Rabbit,

      This is the form I am trying to display.

      When a user clicks on a button, it will display the Rev Form by Task Num. We are trying to see what the next rev num to use for a particular contractor. The macro code works fine to display the associate task numbers, but I would like to do one more filter and that is to filter by contractor. So, the end results should display like Sample 2.
      Code:
      Sample
      ...
      See more | Go to post
      Last edited by zmbd; Nov 4 '13, 01:30 AM. Reason: [z{added code tags around the formatted text}]

        Leave a comment:

      • mlgmlg
        replied to Help to modify a macro where condition in Access 2010
        in Access
        Hi Rabbit, thank you so much for your response.

        I tried appending the "AND", but it is not working. Not sure if I am appending it correctly.

        Code:
        ="[Task Num]=" & [Task Num] & " AND Contractor = '" & Contractor & "'"
        :-(
        See more | Go to post
        Last edited by zmbd; Nov 4 '13, 01:29 AM. Reason: [z{added the code tags}]

          Leave a comment:

        • mlgmlg
          started a topic Help to modify a macro where condition in Access 2010
          in Access

          Help to modify a macro where condition in Access 2010

          Hello,

          I desperately need help to modify a where condition that was created when I added a button to open a form and find specific data by to display.

          The form currently opens and displays a form filtered by the task num (where condition below).

          Code:
          ="[task Num]=" & "'" & [task Num] & "'"
          This works great. When I click on the button, a form (Contractors)...
          See more | Go to post
          • mlgmlg
            started a topic Adding additional Conditions to Conditional Formatting
            in Access

            Adding additional Conditions to Conditional Formatting

            Hello,

            I have a text box (on a Single Form) that I use to color code milestones based on a value. I use the “Conditional Formatting” tool to format four of the conditions, which works great! Unfortunately, I need an additional two conditions for a total of six.

            I believe the additional two conditions must be created by using code to accomplish what I need, but I do not have a whole lot of knowledge in coding. ...
            See more | Go to post
            • mlgmlg
              started a topic How do you enable a list based on a selected value?
              in Access

              How do you enable a list based on a selected value?

              Hello,

              I would like to know if someone can help me with my issue. I have an input form and I would like to select data from a combo box based on an item in another combo box. For example, I have a combo box called “cboWO” that has a list of work order numbers. I would like the second combo box “cboEquipment” to enable when a user selects a particular work order number.

              So, if a user selects work order number...
              See more | Go to post
              No activity results to display
              Show More
              Working...