User Profile

Collapse

Profile Sidebar

Collapse
Brendan Wolf
Brendan Wolf
Last Activity: Dec 13 '10, 09:08 PM
Joined: Oct 29 '10
Location: Hartford, CT
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Brendan Wolf
    replied to How to validate Textbox Value using Table Values?
    in Access
    Hey guys, I am still stuck on this...I would appreciate any help. If you need more detail let me know.
    See more | Go to post

      Leave a comment:

    • Brendan Wolf
      started a topic How to validate Textbox Value using Table Values?
      in Access

      How to validate Textbox Value using Table Values?

      Good Morning,

      I would like to validate a value entered in a textbox to make sure it matches one of the values in a table. The approach I took is a dlookup, but I can only get it to work for one of the values (the first one)

      Here is my code

      Code:
      If Me.AFOs.Value <> DLookup("AFO", "AFO_LOOKUP", "Office = '" & Me.Approver_Office.Value & "'") Then Me.AFOs.enabled
      ...
      See more | Go to post
      • Brendan Wolf
        started a topic How to Filter Multiple SharePoint Lists with Form Web Part?
        in Java

        How to Filter Multiple SharePoint Lists with Form Web Part?

        Hey Guys,

        I am not sure if there are too many SharePoint experts on here, but I figured I would ask and I would really appreciate any help.

        If there a way using a form web part to have one criteria filter multiple lists on the same screen.

        Attached is a screenshot of what I am working with.

        Here is the code I have to filter one list:

        Code:
        <br> 

</br>
        ...
        See more | Go to post
        • Brendan Wolf
          replied to VBA DLookup with multiple criteria not functioning
          in Access
          Thank you so much!

          Awesome Awesome! Thank you gnawoncents! It worked like a charm. I will of course have restrictions in place so there is not null combination.

          Have a great weekend!
          See more | Go to post

            Leave a comment:

          • Brendan Wolf
            started a topic VBA DLookup with multiple criteria not functioning
            in Access

            VBA DLookup with multiple criteria not functioning

            Happy Halloween all,

            I have been struggling at work with a DLookup using multiple criteria. I would like a text box to display the results of a DLookup based on the values selected in three comboboxes and the table that runs them all. Here is my code:

            Code:
             

Private Sub Subverbs_GotFocus()
'When the Subverbs gets focus it looks up proper subverbs from Authority_Lookup table
Me.Subverbs = DLookup("[Subverbs]",
            ...
            See more | Go to post
            No activity results to display
            Show More
            Working...