Search results

so if I put this in the condition of a macro [ID] = IIf(IsNumeric([forms]![SearchF]![txt1]),[forms]![SearchF]![txt1],Null) OR [CustName] Like "*" & [forms]![SearchF]![txt1] & "*" it should search for id or text correct? Also I noticed that my macro condition field is not long enough for much...

Hey buddy thanks for taking your time on helping me.. that's exactly what it shows about complexity .. can you guide me trough where I put that code? can I add it on the Macrobuilder?

THanks a lot for your help buddy really means much to me.. And yes we have a record for each work tiket we get. every single one is different so we entere the record and write the ID on the top of the tiket . and before we file it, we need to estate when the tiket was completed.. so to go back...

Thanks buddy that worked Flawless.... Any Idea why I cant use this...ID] = [Forms]![SearchF]![txt1] then use "Or "and a "Like " criteria in the same Apply Filter macro? ID] = [Forms]![SearchF]![txt1] or [CustName] Like "*"& [Forms]![SearchF]![txt1] & "*" I Tried this but seems that doesn't...

so If I need to pull ID from my query1 from SearchF? Id= SearchF!txt1? or [SearchF]![ID]![txt1] Just like that? becase with the like I have like this [ID]Like "*" & [Forms]![SearchF]![txt1] & "*" SearchF is the form that Im on and ID is the one that Acces automatically creates.:banghead:

Hello World: I'm currently having hard time trying to configure my form to do the search.. I have this .. On a form I have ID which is automatically generated. that's what I want to find as exact match.. If in ID 234 I have a Specific case, I want to Pull that one not LIKE numbers. thanks the...

Thanks a lot buddy! I definitely try it out... Blessings......

If I enter in my input form as customer "Napolitan Peter"and then later I enter a new order for that same customer. I wonder if there is a code for my customer name field to pull or show me the previous entered so I can click on it and autofill? exel does that....do I make sense? Thank you in...

It may sound little off topic but I know how to make a Form, Query, and Tables. I would like to get more info on Programming, I know is a long way to go but I'm new on this so any help or tutoring would be Very appreciated.. Greetings My Friends..... :banghead:

Buddy thanks A Lot for your help and advice. I definitively code it and see what happens.. God bless you and have a nice day...

Hey Buddy! Thank you very much for your help. I will definitively give it a try. God bless you and have a nice day....

Hello World: I been creating a database for My office that contains Hundreds of records every Month.. I have an outbound text box with a search button. But I want to set up a code that shows me the filtered record as I type the search text... Example if I type R to start showing all R's and...

Hello World