+ Reply to Thread
Results 1 to 3 of 3

Search Record in User Form not finding records that are numeric

  1. #1
    Registered User
    Join Date
    02-02-2021
    Location
    Oklahoma City, OK
    MS-Off Ver
    365
    Posts
    2

    Search Record in User Form not finding records that are numeric

    I have completed a advanced data entry user form that stores data to a worksheet. The user form has a search record feature that will find records by row which can be selected and edited. Two of the columns (Agent ID) and (Submitted On) will find and return numeric matches however the other columns are showing no record when a numeric search is conducted. The rows will find the alpa records if searched but not the numeric records

    I need the search feature to find numeric records in the other column’s

    Any suggestions would be greatly appreciated. Workbook attached.

    No Record.JPG

    Record Found.JPG
    Attached Files Attached Files

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Search Record in User Form not finding records that are numeric

    Do you want to filter with wildcards on some columns and filter for exact values on others?

    You appear to be doing the latter for 'Agent ID', so why not do it for other columns?
    If posting code please use code tags, see here.

  3. #3
    Registered User
    Join Date
    02-02-2021
    Location
    Oklahoma City, OK
    MS-Off Ver
    365
    Posts
    2

    Re: Search Record in User Form not finding records that are numeric

    Ok, that was a simple fix. Thanks Norie

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Finding how many child records for a given parent record
    By mq1973 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-03-2017, 11:53 AM
  2. [SOLVED] Search and Update Records in User Form changing dates to US Format in Spreadsheet
    By JTResearch in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-20-2013, 06:48 AM
  3. User Search Form update Records using Invoice Number
    By z-eighty2 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-16-2013, 04:31 PM
  4. Search for/Edit Records with a User Form
    By LONeill13 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-13-2013, 03:24 PM
  5. [SOLVED] User Form to execute search and return all values to the user form for editing
    By allwrighty in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-11-2013, 10:40 PM
  6. Userform - search database for matching records, find next if more than one record
    By beaterfred in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-02-2012, 11:56 AM
  7. To show total records in use form ( Record 7 of 10)
    By ebin charles in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-20-2010, 06:21 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1