Results 1 to 2 of 2
  1. #1
    BrucePerry is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Apr 2016
    Posts
    9

    Action Catalog

    Microsoft in there infinite wisdom added the action catalog for creating common macro actions; however they really don't spend the time to express how to use this function.
    Well on to my problem. I have two tables one with lets call it description data and one with numbers lets call it just numbers.
    I have a form with a search button and a text box. Then I have the fields for the Description data and the Numbers.
    This part of the form works fine and I can roll/scroll through the records one at a time and all the fields show correctly so everything is in sink.
    I would like to use the action catalog (so I can learn) to activate a click action on the search button to search for a specific number 'MS1095'.
    If I can do this I think I know how to call up a value from the text box when I'm ready.

    Thanks for your help.

    P.S.
    I want to populate the form with the record not just access the record in a table?

    Found this little bit of code that worked perfectly (didn't use the action catalog but it got me closer):
    Option Compare Database
    Private Sub FindCBT_Click()
    Dim sSearch As String
    'read the seach string from the form
    'note: NZ() ensures that nulls are converted to empty strings
    sSearch = Nz(Me.FindTextBox, "")
    'Check if the search string is empty or not and set the filter accordingly
    If sSearch = "" Then
    Me.Filter = ""
    Else
    Me.Filter = "[SearchFeild] LIKE '*" & sSearch & "*'"
    End If
    'turn on the forms filter
    Me.FilterOn = True
    End Sub

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    Code:
    If sSearch = "" Then
        Me.FilterON = FALSE
     Else
        Me.Filter = "[SearchFeild] LIKE '*" & sSearch & "*'"
       Me.FilterOn = True
    
     End If

Please reply to this thread with any new information or opinions.

Similar Threads

  1. System Catalog problems
    By raziel86 in forum Programming
    Replies: 2
    Last Post: 03-02-2016, 06:13 PM
  2. Word product catalog from Access 2007 data
    By todavy in forum Import/Export Data
    Replies: 3
    Last Post: 10-14-2015, 10:42 AM
  3. Replies: 1
    Last Post: 10-23-2014, 04:32 PM
  4. Catalog Design
    By manda in forum Database Design
    Replies: 3
    Last Post: 02-27-2013, 05:20 PM
  5. Catalog of Databases
    By sims.anderson2010 in forum Access
    Replies: 2
    Last Post: 12-21-2012, 08:04 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums