Search results

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..

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...

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:

Hai, friends there. Did anybody know that Access97 have radio button? If have can u people please teach me how??