User Profile

Collapse

Profile Sidebar

Collapse
zztuf
zztuf
Last Activity: Oct 25 '21, 08:10 PM
Joined: Dec 15 '15
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • zztuf
    replied to Open a form to search for a record using a command button which prompts input box
    in Access
    Code:
    Dim strTag As String
    strTag = InputBox("TAG Name?")
        Me.Filter = strTag
        Me.FilterOn = True
    DoCmd.OpenForm "InstrumentsForm", acNormal, , "TAG = '" & strTag & "'"
    Now I just have to find out, when I type only a part of the tag, I have no results. I have to type de hole TAG exactly.

    But other than that, It works like a charm....
    See more | Go to post

      Leave a comment:

    • zztuf
      started a topic Open a form to search for a record using a command button which prompts input box
      in Access

      Open a form to search for a record using a command button which prompts input box

      I have a main form called 'Main'
      I have a table called 'Instruments' (one of those rows is called TAG, contains strings)
      and I have a form to display all the records of Instruments table.

      I'm trying to do the following:

      Have a button on Main form.
      When click on it, display an input box to search for instruments TAG.
      and opens the form Instrumentsform with all records of Instruments that have in their...
      See more | Go to post
      No activity results to display
      Show More
      Working...