Search results

  1. N

    Highlight Text in Field After Filter

    In other words, its as though the condittional formating is expecting a NUMBER as opposed to words
  2. N

    Highlight Text in Field After Filter

    Thank you!. Its almost perfect. However, I am having some difficulty in the EditFormattingRule popup. You see, I want to format cells whereever the FieldValue is LIKE the SearchFieldValue on the same form. For example, my txtSearchName has a value of Brian. The txtNameFields have values of...
  3. N

    Highlight Text in Field After Filter

    Hello. I have a search form that runs a filter based on a query. When I type a word to search and click a command button to run a requery, how do I get the the words that I searched to be highlighted in the fields below? I found this website: http://allenbrowne.com/AppSearchHighlight.html...
  4. N

    Cannot Use Record Selectors in Filtered Form

    Oh my God!! That worked! Thank you sooo soo mcuh
  5. N

    Cannot Use Record Selectors in Filtered Form

    Would this be because my CaseNum is a "short text " data type
  6. N

    Cannot Use Record Selectors in Filtered Form

    Thank you! I have entered the code correctly (I hope). But when I click on the btn, I receive "runtimeerror 3463- data type mismatch in criteria expression" When I press debug, It highlights: private sub cmdSearch_Click() Me.GoToCaseNumber Me.txtCaseNum end sub
  7. N

    Cannot Use Record Selectors in Filtered Form

    Thank you! The last question I have is about {{{ "CaseNumber = " & CaseNumber}}} CaseNumber here would refer to the field on my form called CaseNumber. Right? Also, I also have it named 'Case Number' (with a space). (I know I know, I shouldnt have spaces). None the less, how do I account for...
  8. N

    Cannot Use Record Selectors in Filtered Form

    Well, In: public sub GoToCaseNumber(CaseNumber as Long) with me.recordsetclone .findfirst "CaseNumber = " & CaseNumber if not .nomatch then me.bookmark = .bookmark end with end sub What does {{{ CaseNumber = “ & CaseNumber }}} refer to? And all...
  9. N

    Cannot Use Record Selectors in Filtered Form

    My the Macro actually opened the Form (frmEntry) that was already open. In other words, There is a button on FrmEntry that will open FrmEntry to a specific WHERE criteria. And I am nto clear on your explanation. Furthermore, isnt Me.Recordsetclone a "read only" thing? I need to be able to type...
  10. N

    Cannot Use Record Selectors in Filtered Form

    Thank you, but I am not looking to open a "second form." Often times, I will need to search to a sepecific case number, and then click the next-record-selector multiple times
  11. N

    Cannot Use Record Selectors in Filtered Form

    Hello. I have an entry form that has about 20000 entries each uniquely identified by a "CaseNumber". I made a search button on the entry form to quickly find certain Cases by inputing a case number. This search, done via the OpenForm Macro, takes me to the exact case number that I specifcy...
  12. N

    Copy and Pasting between frm and Subfrm

    I have been taken to that same link plenty of times, but I am still having difficulty. I have been told to utilize this: "Me!Subform1.Form!ControlName" However, what does "Me" refer to here? It should refer to [frmBusiness Information]. If thats the case, then would I replace "Subform1" with...
  13. N

    AWF - Christmas meal

    Im hungry now. But its awhile till xmas
  14. N

    Funny observation on the Advertisements

    Adblock is great:)
  15. N

    Hi from London, UK

    Glad to have you here. London is a beautiful place
  16. N

    Hello - YE

    Salaam Alykoom
  17. N

    Hello from Kiribati

    I have never heard of Kiribati before.
  18. N

    Hello from Michigan, USA & a big THANKS

    Welcome Colleen!
  19. N

    Hi from Thailand

    Welcome! I was in Bangkok last year!
  20. N

    Rulers to inch

    i had the same problem... you also may need to do this with Dates as well
Top Bottom