Search results

Hi all, Can someone pls fine tune my program so that the balance of the paper can be shaded. Pls refer to the attachment for better understanding. Thks.

Dear Sir/Madam, I would very much appreciate if you can spare me some tips to draw grid in form. Just a simple tip so that I can carry on the rest. I want to have a form to allow me to input 2 figures (length & width) so that a gris can b plotted. For example, a big sheet of paper size is length...

Dear All, Ok,now I get the total when "qty in/out" is keyed in the form. What if I have multiple ins and outs to be keyed in. For example:- at first 10 "in" then 5 "in" then 4 "out"? The answer for total will be like qty:11*price per pc. Right? Or you can suggest any methods as long as I can get...

Dear dcx693, I have an error "Data type mismatch in critiria expression" Regards, Sean

Dear All, Based on the expression in query field,what if the statement is false, and i want it to return to "wrong" instead of "0"? IIF([Authorized]=1 And [DayID] In (1,3,4), 100, IIF([Authorized]=1 And [DayID] In (2,5), 200, 0)) Thanks Sean

Dear Wayne, Thanks for solving my problem partially. No doubt that I can get the total when "qty in/out" is keyed in. What if I have multiple ins and outs to be keyed in. For example:- at first 10 "in" then 5 "in" then 4 "out"? The answer for total will be like qty:11*price per pc. Right? Or any...

sorry,forgot to attach file. here it is.

Dear guys, Thanks for your feedback. Actually,you can refer to my attachment for easy understanding on my problem. My concern is how do i get total price from the in/out inventory? I guess it is clear now. Or you can suggest any methods as long as I can get the total in the form as well as in...

Dear all, I need to know if mulitple calculation can be made in one text box under form? Something like excel:- sum((10+20)-5). Thanks in advance. Regards, Sean

Dear WayneRyan, You r so helpful, I really owe u so much, let me try it. Regard, Sean

Dear WayneRyan, Thanks for your prompt feedback. The thing is that I have 100 staffs. Each of them has 2 different shirts & 2 different pants. And all these items have different barcodes & they are scanned randomly. How many tables should I create? Thanks. Regard, Sean

:confused: Hi all,I would be very appreciative if someone could help me. Basically,I want to search information after all items have been randomly scanned by barcode scanner. For example,each of my staff has 4 items namely:- A:shirt1, B-pant1, C-shirt2, D-pant2. All items have their own...