Recent content by puffdog

Hi there,i have two field in my query ,there are field Total, Min i wan to print a report when field Total <= field Min, how i create a report like this?Could somebody tell me? Thanks all..

thanks you all.. Thanks.

thanks,but... Thanks for reply.could you pls tell me how to do that search in access?I really have no idea to do it cos i just learn access. You said that there got some detail with code examples,so may you please give me that code? Thanks a lots.

Hello,i have a system that allow a lot of transaction of issue and receive item in a store.How can i do a security on my access system that allow me to keep track to the user of the system. for etc. Danny login the system at 10am,then he do a mistake. Now i need my system to let me know that...

How to show a field value in form?i want to show a value of a field in a form but from different table. i try to read it from build event but when i preview it,it will show #Name? in my text box. Can someone help me to solve this? Example: Form 1 is create from table 1 then i want insert a...

how to print report by daily,weekly or monthly? i need to print a report that allow me to choose print it daily,weekly or monthly. like monday i have 20 record then tuesday have 30 record,how can i do it? and at my form i have a combo box with value = Apple, Orange and Banana. Can i print a...

I face some problem in showing a value in a field. I have 4 table, a query and a from. My query have a QoH that which will calculate my quantity. Then i create a form for a table . the form have 2 field that content PartNo and Qty. Then i create a new field to show the QoH from my query but...

Access is quite new to me,but now i hope i can start learn it. I am creating a DB that need to keep track of my Quantity of hand(QoH). I need a query that calculates the QoH. My DB have two transaction type,one is receive (add QoH) and one is Issue Out (Minus QoH). Then each transaction have...

Hello friend, Can i do this with combo box? I have table with field Type, I create a combo box with 4 selection, when i select 1st selection in my table,type will show value = 1. Can this be possible?

i need to find the latest value from a table so that i can count on it. For example, Table A have Field QuantityOnHand(QoH) and it show 10. Table B have field name issue Qty. Then how can i do a program to minus QoH to 8 when i key in 2 in field Isue Qty? I hear that recordset can do it,but i'm...

Thanks Wayne, Actually i'm not familiar with access, can u please tell me how to do it at query to calculate the total price and display on a form or report. So as you mean for the thing like TotalPrice we should not put it in my data table,is it? Thanks, Puff

Sorry Ok,i'll post it in the same place..thanks for your help.:)

Thanks for reply.. ok let me explain it more detail.. i have a table that have a field name price and Quantity then i have a field name TotalPrice. so can you please tell me how or where can i do a coding to show the calculation result in the field TotalPrice?? like Price Qty Total...

How to do a sum in table?? for example,column A hv value 3,4 then how we let column B will sum the total of column A to show value 7 in Column B? A B 3 3 4 7 Thanks for telling me...

Pls... may anybody please tell me how to do a calculation in a table field? like column A =5 , column B = 5. then how to let column C will do a calculation to make it show 10? A B C 5 5 10 Thanks for telling me...:confused: