Search results

Ask some more about Nz(SumOfReceiveQty,0) To HJartman I have try by Adding =Nz(SumOfReceiveQty,0) in ControlSource property of "Frmstock" in "Sumofreceiveqty" text box. but is show error when open the form.. Could you please advise me little more

Ask some more about NZ function Dear Hartman Can you please guide me little more. How can I use this Nz function. I have try to put this function in Properties of "SumOfReceiveQty" text box. and this what i put in (i search from help and adapt with your command) Dim A as variant A = Nz(A, 0)...

How to use formular with the cell without value Hi hartman Now I can make the summary of "Receive" and "withdraw" for each product. In some row, there are both value for "receive" & "withdraw", so i can deduct "receive" & "withdraw". But in some row, there is only "Recieve" and no value for...

Thank you so much Thank you so much Hartman it works!!!!

Hi friend I need your help. I have made 2 query (named "QryReceivesum" & "QryWithdrawsum"). But query have the same common column called "ProductId". I want to combine 2 query to be just one. Currently I have mae one query named "QryStock". but the data from this qry is not correct. As you can...

Thank you ColinEssex Thank you so much Colin I have already check in your file and it work. Thank you for your great help.

Dear colin, please help Dear colin Sometime if i type the the date too quick, even it is correct date, it will show blank in the graph. I have try to paste the calendar (from active X) but I have no idea how to use it (it show on blank space in on th report). Can you please show me??

Hi friend Anyone can help me If I need to make the graph in report. (the report are made from the query and i set one field as the parameter value.) Now the parameter that I key in , normally is the date. Many time that I key in the correct date but it show nothing in the graph. So i...

If I have the field name as below: Oil quantity Accumulate Oil quantity Date Recordnumber I want to get value of "Accumulate oil quantity" of current record to be equal to sum of "Oil quantity" from first record till the current record: Let say after I input "oil quantity" in the record # 1...

Ask some more Dear Wayne Sorry Wayne, I could not understand the detail in the tread that you show me. I never do that long exopression before. Can you give me more explanation for easy and basic retriving data from query to exel. Let say: I have query name "physical" and I have field name...

Thank you friend Thank you so much friend Happy new year

Hi friend I already make a form and report. But i do not know how to make Form & Report open full page immediately after we click into the file. Thank you everyone to help me.

I try to export the data from "Form" to exel file. I need to key in the "Form" daily and then export in to "designed column (fix column)" in exel file daily also. How can I export to exel and do not make the data overwrite to lod data. Thank you for your great help.

Thank you so much trucktime Thank you for great help

Thank you Thank you so much "old softboss"

I am doing a form with my own navigation button I can make button to - add new record - go to last record - go to next record but I can not make "page number" show up - total page - current page Thank you for your help Happy new year to you all

Ask some more about "OVerflow" Dear Trucktime Thank you so much for your help. I have already try your command , it works. Then I copy your command in another access datebase. It show "Overflow". Do you have any idea , what should be the problem. Thank you for your help.

Ask some more about "OVerflow" Dear Trucktime Thank you so much for your help. I have already try your command , it works. Then I copy your command in another access datebase. It show "Overflow". Do you have any idea , what should be the problem. Thank you for your help.

Hi friend I am making easy database to collect water consumption If I have field as below RecordID Date Startmeter Todayusage Finalmeter If I want to set startmeter value to be equal to Finalmeter value of prevouis day How can I do it. Also If I enter the date in one field, and want to...