S
solar
Hi,
Can anybody please help to clear my problem..? as i need one GOOD SUPPORT
to give clear picture about this?
Our payment is centralised payment which is to be paid by us as we are
Corporate office. Hence,We need to have control in the system itself.
Before, I had done with text box with VBA Code. But, It is not fullfill my
all requirement.
I am not a New user. But, I never used Sub-Form.
My problem is...
1. In a form, i need to put to TWO subform wherein i need to include the
below fields with specified condition. (The query can be designed myself with
multiple table and can be linked with the help of relationship.) In a query,
the Field & condition are....
Main Form
1.Requisition date
2.Sent by (sent by whom)
3.Rich Text box
-which can contain 60 characters.
1st Sub-Form
1.Region
-It shall have Combo box which should display the list of Region)
2.Vendor
-It should display list of vendor selected in Region.
-And, When it selected, the City of the Vendor shall be shown in the Message
box.
3.Account No
4.Invoice No
-It should check duplicate invoice no which is combined Number of
Region,Vendor,Account.
-The selected vendor's invoice no character to be fetched from vendor
table which can be invisible. And,it should not allow to enter more than
invoice character which is specified.
-The message box should display for the duplicate Invoice No.
5.Invoice date
6.Submission date
7.Due Date
-The control for due date to be fetched from Vendor table where the due days
has been specified . And, The due date to be calculated automatically with
submission date based on the due days.
8.Invoice Amount
=============================================================
IInd Sub-Form
9.Deduction Amount
10.Deduction Remarks(text)
11.Payable Amount
-The calculation will be (Invoice Amount-Deduction Amount).
-The deduction will be mulitiple. So, The total amount should keep on
decrease in each deducation in the total amount.
Other instruction
1.Any field should NOT be empty for which the message can display.
2.Both forms should be feasible to enter MULTIPLE data. (ie., the multiple
region & multiple discount data can be enter.)
Here, my further Doubt is How to store it to the table?
-Whether based on "Update query" by using VBA code.
(or)
-Anyother way.
The Requisition table fields are...
-Req_date
-Req_Region_id
-Req_Vendor_id
-Req_Account_id
-Req_Inv_Number
-Req_Inv_Date
-Req_Inv_Amt
-Req_Payable_Amt
-Req_Deduction
-Req_Ded_Remarks
-Req_Due_date
-Req_Sent_id
-Req_Remarks
I believe it would be easier who use already many time.
Please suggest & give me the STEPS that i do.
Thanx in advance..
Solar.
Can anybody please help to clear my problem..? as i need one GOOD SUPPORT
to give clear picture about this?
Our payment is centralised payment which is to be paid by us as we are
Corporate office. Hence,We need to have control in the system itself.
Before, I had done with text box with VBA Code. But, It is not fullfill my
all requirement.
I am not a New user. But, I never used Sub-Form.
My problem is...
1. In a form, i need to put to TWO subform wherein i need to include the
below fields with specified condition. (The query can be designed myself with
multiple table and can be linked with the help of relationship.) In a query,
the Field & condition are....
Main Form
1.Requisition date
2.Sent by (sent by whom)
3.Rich Text box
-which can contain 60 characters.
1st Sub-Form
1.Region
-It shall have Combo box which should display the list of Region)
2.Vendor
-It should display list of vendor selected in Region.
-And, When it selected, the City of the Vendor shall be shown in the Message
box.
3.Account No
4.Invoice No
-It should check duplicate invoice no which is combined Number of
Region,Vendor,Account.
-The selected vendor's invoice no character to be fetched from vendor
table which can be invisible. And,it should not allow to enter more than
invoice character which is specified.
-The message box should display for the duplicate Invoice No.
5.Invoice date
6.Submission date
7.Due Date
-The control for due date to be fetched from Vendor table where the due days
has been specified . And, The due date to be calculated automatically with
submission date based on the due days.
8.Invoice Amount
=============================================================
IInd Sub-Form
9.Deduction Amount
10.Deduction Remarks(text)
11.Payable Amount
-The calculation will be (Invoice Amount-Deduction Amount).
-The deduction will be mulitiple. So, The total amount should keep on
decrease in each deducation in the total amount.
Other instruction
1.Any field should NOT be empty for which the message can display.
2.Both forms should be feasible to enter MULTIPLE data. (ie., the multiple
region & multiple discount data can be enter.)
Here, my further Doubt is How to store it to the table?
-Whether based on "Update query" by using VBA code.
(or)
-Anyother way.
The Requisition table fields are...
-Req_date
-Req_Region_id
-Req_Vendor_id
-Req_Account_id
-Req_Inv_Number
-Req_Inv_Date
-Req_Inv_Amt
-Req_Payable_Amt
-Req_Deduction
-Req_Ded_Remarks
-Req_Due_date
-Req_Sent_id
-Req_Remarks
I believe it would be easier who use already many time.
Please suggest & give me the STEPS that i do.
Thanx in advance..
Solar.