Recent content by Wild Horse

Please go back to oroginal configution. I found that you will update the ORDER BALANCE when you update the payment only, but not when you update the order. I think you have to recalculate the order balance wheever you update either payment or order. good luck

Jempie, How about if you set the POPUP property of your another form that you want to open from main menu to YES. It can keep your main form to maximize size while you open another form as pop up form. :cool:

I think the problem is the product description data. is it true that the program was not working well when the product name contain the character such as #, ", &, ', etc. ?

Since you are trying to open the same form 3 time with different criteria, i assumed that you need 3 criteria to open the form. with the logical relation ship AND, OR, etc, it is easier to do. by the way, is it possible to search the data by product code, because i believe that the product code...

in your Double_click procedure, I found that you open the same form 3 times with 3 different criterias. I do not know why you need to do it. To open a form with criteria, why don't you try the code structure below : criteria = criteria1 OR/AND criteria2 OR/AND criteria3 OR/AND ...

behind the close button in first form, change the code to Forms![frmFullSizeForm]![Label5] = Format([Text0], "00") Forms![frmFullSizeForm]![Label6] = Format([Text2], "00") and in Form_timer() procedure of second form, change the code to [Label5] = Format([Label5] - 1...

try the attachement

I have a report that work with one record at anytime. But I want to alternate the record source base the status of checkbox on a form where I open the report. If the check box is checked, then the report.recordsource = table1 else the report.recordsource = table2. Is it possible ? Please help...

Using me.newrecord OR newrecord must be OK. Perhaps the problem is not "newRecord" function. Please check. 1. What is the status of check boxes when the record is existing record ? There 2 possibility . a. do nothing, hold the existing status. It mean your code OK. b. set to certain status. It...

It is not worked as what I want. only the textbox that contain longer text will be grow, but the rest are not. with this setting, when we set the border of all text to solid line, the report will be so ugly. other ideas? thanks AH

I have problem to make all textbox in report can grow if one of them has the text longer then others. Anyone has an idea ? Thanks AH

You can try to put Me!ComboBoxRequery.Requery on On Close Event of another form that you open to update your data.