Search results

Dang :banghead: I cant get this. can you help me put it together? please?:D I got this fields. Doc_Name, Pat _Name, Case, Date, my forms name is "Search_F"

on my search button I got this for one criteria , DoCmd.ApplyFilter , "[Doctor_Name] Like ""*"" & [Forms]![Search_F]![Txt1] & ""*""" I want to search by Folder_Name Date Room Birth date. I have tried "or" after ""*""" but doesn't work,, Help please.

Hey budy thank you very much, It did fix my problem, I posted another problem that I am having can you please help me. I want the donor addres to appear on top of my report and I also looking to generate a letter with the amount. donor name address .. some like that.. thank you buddy. God bless..

Somehow I am having issues linking contributor address to my report, How can I link it from the contact information to appear on it>? like the photo that I will attach. also I would like to print out a letter saying the amount and the donor name address.. is that possible? can anyone join me on...

I downloaded the Pre-Loaded CHaritable contribution Database that comes on access. somehow when I create a Report instead show the amount on US$ it shows me sets of ####. Is there anything I can do to fix that >? does someone has a similar database that would like to share? can someone please...

Hey buddy , are you still arround?

Exelent my friend I definitely try this and I let you know... have a good day.

Hi guys. How can I do to program my database to autobackup with a button or when exit ? I hate to go to file, save as, backup database. I would like something nice like automatic :) please help :banghead:

Hello I have a Form that I use to enter my cases. I want to know on an field if no number is added there to show me a msg with error? I did check required field on table but would like something more professional. Field name is "OFF_IF" Thanks

Does that can be added anywhere in my code??

Yes something like that my Friend, that can read who is in from my usertable.

Hello FellowsL: I Have a log in form with multiple users, I had crated a simple welcome msg on the msgbox. But Im not satisfied with it. I want to see something better on the msgbox like, Welcome+the user that is login in at that time... can someone help me please.... Thank you in advance my...

Hey buddy I need your help... I have a log in form.. wich reads wich user is in the form. and I want to see in the msgbox "welcome " & wich ever user is logging in? do you get me?

Hey buddy thank you very much for your help.. I definitely try it out.

Hello World: I have a unbound search box w a search button. The purpose of this form is to run from a query that I have and from there I need to enter the date that the work was done Like Kind of a LOG OUT form. but I need help with the programming and if you guys have any advice on wich...

Hey Buddy thanks for your time on replying.. I did exactly what you told me.. Add a button for search ID and Date and another button for Other entries.. That seems to be working fine.. I just wanted to eliminate two buttons, I wanted to have only one.. but for the time being I think Two is fine..

[ID] = IIf(IsNumeric([forms]![SearchF]![txt1]),[forms]![SearchF]![txt1],Null) OR [CustName] Like "*" & [forms]![SearchF]![txt1] & "*" plus DeliveryDate Plus EntryDate Plus like one more criteria that I would like to search.. I have thousands of records That's why I would like to set all these...

what I don't understand is how to get around the limit on the were condition. it's just 255 characters limit, and to search ID, CustName, EntryDate, Deliveried Date, it exedes the limit on there....????

Thanks to Everyone who had help me God bless you all...

I have a button that's were that code that You gave me is in. I have an Unbound text box and a Search button next to it.. If you don't mind you think you can Help me out on this? by the way, thanks for the help finding out Iif fuction it worked up good.. I went to the office and coded it...