create inventory in Access (1 Viewer)

[GinaWhipp]

Have you figured this out with the examples provided?

 

[mabino79]

Have you figured this out with the examples provided?

yes, have did some what, but still need more to do.

 

[mabino79]

seems reserved means booked, so as u suggested it should go to sales order, not sales, but the question is how is the reserved treated in store

1. Does it reduce the quantity in store?
2. The booked quantities must have a grace period for the buyer to pick up or make payment to confirm booking

yes it will reduce with No due date.

 

[GinaWhipp]

Okay good, just didn't want you thinking we forgot about you.

 

[mabino79]

new to the VB codes, so unable to make that.

want to get the Sub form total with specific product code selected in row on main form.

 

[rainbows]

Mabino79

can you post your database so we can see it?

 

[mabino79]

here is the db

 

[mike60smart]

Hi
I modified the Subform so that it is a Continuous Form View and the used =Sum([ActualQty]) in the Form Footer

Is this what you need?

 

[mabino79]

want on product basis not on Purchase (head) basis. if it has multiple product than it should show the current stock of the each product.

 

[mike60smart]

I have no idea what it is you want to see on the Form.

Can you upload an Excel or Word document showing exactly what you want to see on the Form??

 

[mabino79]

thanks for all above i have done all till

now i need to validate the value as

if the Main Form value = Purchase than
Sub form Qty should be more than 0, otherwise it will be less than the txtTotalQuantityinStock (which is a calculated query)

have created as below, but getting error, please help to rectify.

Thanks in Advance

IIf([TransactionType]="Purchase",[Forms]![tblInventoryTransactionSubForm]![Qty]>=0,[Forms]![tblInventoryTransactionSubForm]![Qty]<=[txtTotalQuantityinStock])

please suggest where i am going wrong.

 

[CarlettoFed]

Meanwhile in the attached file there is no query or control named txtTotalQuantityinStock, you should say where you entered the IIf (...) control statement they suggested.
Also remember that it is very important to correctly set the various Properties of the fields of the tables such as:

Required (essential so that a value must always be entered in a field)​

Allow zero length​

Indexed​

that you have never managed.

 

[mabino79]

eanwhile in the attached file there is no query or control named txtTotalQuantityinStock, you should say where you entered the IIf (...) control statement they suggested.

worked

([Forms]![frmMain]![TransactiontypeID]=1 And [Qty]>0) Or [Forms]![frmMain]![TransactiontypeID]>1 And [Qty]<=[Form]![txtTotalQuantityinStock]