Search results

Agreed on being flexible. I only have one query and different reports based on criteria. I just solved it with you suggestions. It took me long to get your point of not having "=" sign. and that was the issue. LOL. [GDate]Between[Forms]![Copy Of FrmGDayAlphaReport]![TxtGDFrom] And...

I am open to VBA, but don't' know much (same with macro though). Until now Macro seemed to be working for me so took that route. Thanks

I have Report form which runs report per criteria entered. If it is based on single txtbox or cbobox, then I do not have a problem, but when it is multiple boxes then it doesn't produce the results I want. I.e. I want to get a report between two different dates, I tried below Macros but it only...

I would like to highlight the row on the report based on the value of one field. Is it possible? I have a report which shows Voided records among other transactions. I would like to show voided entries in different color. Please see attached report. Please let me know if it could be done and...

They way it is reconciled, I couldn't have Void as Status. But this would have been an option for me if formula from boerbende didn't work.

Thank you boerbende. I would never have figured out.

Hi everyone, This might be very simple but I quite don't get the result I want. I have a report built on the query which has Emp name, guest name,amount and void check box. I didn't wanted to have record deleted so i designed a check box for void transactions which shows up on the report and...

That worked like a charm buddy. Thank you very much. Now the trouble is with the printing 3 copies of the form on one paper. We have single three part paper(different color each) which user tears and puts it together to sign and distribute. So i want the form to print in all three portion of...

I think that is the problem that form is losing focus thus the error. I couldn't attached the original so I create another which reproduce the behavior. Please check it out. Thank you

Hello, I have a "Submit" button on the form and in the event "On Click" I enter marcos as RunCommands to SaveRecord, SelectRecord, PrintSelection and RecordsGotoNew. Now it runs first three commands successfully but when RecordsGotoNew comes, it is giving me an error "The Command...

Thanks Bob. It did work. My intention was to use it in a form that wasn't link to the same table, so I was keep selecting different option in wizard, but I build sub form that will be attached to this one and it works great. Thanks for your help.

But that will give me drop down list, and we have 1000+ customers and adding. Would it let users to enter few numbers to narrow down?

Hi All, I have a table with guest FN, LN and Acc#. I build the form to do the search, but it seems to be updating 1st records every time search is performed. The way I wanted to work is when employee enters the Acc# and hits enter, it will show FN and LN in the box. My form is bound to the...