How to manage Access at run time

[AMIT HCL]

I am trying to create a Sales application for my self use.

Description: My work is picking orders from customers.

Problem 1 : Now an order may contain single item or multiple items. So is
there any way to manage at run time like if I fill No of ITEMS =5 then 5
times only i have to fill the details (Type, Specifications, Unit Price, and
Warranty). This will reduce the form size also.

Problem 2: In Access table how to get the "Balance Amount" field auto filled
from “Order valueâ€& “Advance Payment “ field .

Problem 3 : How to create customised Auto No ? Like "AKS/HCL/GKP/1423" ,
"AKS/HCL/GKP/1424" .. So on .

Please help me . I am a very bigginer in this field .

Thanks .

 

[bhicks11 via AccessMonster.com]

Hi Amit,

Problem 1 - I think it would require more detail info to answer.

Problem 2 - Use a query that calculates the vale of [Order Value] & [Advance
Payment]. I would not make a field but calculate it whenever you want to see
it.

Problem 3 - Again, calculate this in a query. "AKS/HCL/GKP/1423" plus the
value of an autonumber field.

Bonnie

http://www.dataplus-svc.com