All Access Experts please help me. I attach a access db file. please help me how to develop a db with
following requirments.
In
transaction form i needs following input validation
(1) when ACNo text field is null or filled with any number it checks existing data (Name field) from a
tbltransaction table. If match where ACNo is equal from Name field of tbltransaction then show the name
in txtName textbox. Otherwise txtName fields show Invalid Customer or my message and focus set to ACNo
textfield. Cursor not moved other text field without any valid data. Cursor moved when ACNo is not
nulled and input value is found existing data from tbltransaction.
(2) TransType, VoucherType text field is same as like as ACNo text field. TransType checks existing
data of tblTransType and VoucherType chechs existing data of tbl VoucherType.
(3) If VoucherType text fields is debit by cheque or debit by voucher then Debit text field is enable
and credit text field is disable. And If VoucherType is credit text field is enable and debit text field
is disable.
(4) VoucherNo text field is only checks if it is null or not. If not null not set focus VoucherNtext
field.
(5) Description text field is only checks if it is null or not. If not null not set focus of the field.
(6) IN txtbalance field i want to show balance of the acount number which is equal to ACNo text field.
(7) If VoucherType is debit then check input Debit text field amount. if Debit text field amount is < or
= Balance text field then transaction complete otherwise not.
(8) If VoucherType is credit then check input credit text field amount. if Credit text field amount is >
0 then transaction complete otherwise not.
(9) txtLastTransDate text field show the last transaction date from tbltransaction where Form ACNo is equal to tbltransaction ACNo .
Thats all. Thanks to all access talents.....
Here is my attachfile link:
http://rgho.st/7Rdd4XqcD