i need help

[jervin via AccessMonster.com]

I had 2 tables:

table1: table2
stockno qtyonhand qty_sales customer stockno

i want to create a form(sales form) that will issue to a customer. A form
that will check/verify if the qtyonhand on table1 is available and capable of
issuing the no of qty to a customer. If not it will prompt me to say
"qtyonhand not sufficient" or If the qtyonhand is available it will then go
ahead and process a sales. The qtyonhand on table1 will then be subtracted by
the qty_sales from table2.

appreciate for your help...

 

[Klatuu]

I am assuming you will have a command button that when clicked will check the
quantity and, if sufficient, will produce the report. What you do not say is
what is on your form. For that, I will assume that the form is based on
table 2. In the Click event of the command button:

Dim varChkQty as Variant
varChkQty = DLookUp("[qtyonhand]","table1","[stockno] = '" &
Me.txtQtySales & "'"
If IsNull(varChkQty) Then
MsgBox "No Quantity On Hand Found for " & Me.txtStockNo
ElseIf varChkQty < Me.txtQtySales Then
MsgBox "Insufficient Quantity to Fill This Order"
Else
'Do your stuff here
End If

 

[jervin via AccessMonster.com]

thank you sir..i will work on this one..

I am assuming you will have a command button that when clicked will check the
quantity and, if sufficient, will produce the report. What you do not say is
what is on your form. For that, I will assume that the form is based on
table 2. In the Click event of the command button:

Dim varChkQty as Variant
varChkQty = DLookUp("[qtyonhand]","table1","[stockno] = '" &
Me.txtQtySales & "'"
If IsNull(varChkQty) Then
MsgBox "No Quantity On Hand Found for " & Me.txtStockNo
ElseIf varChkQty < Me.txtQtySales Then
MsgBox "Insufficient Quantity to Fill This Order"
Else
'Do your stuff here
End If

I had 2 tables:

[quoted text clipped - 9 lines]

appreciate for your help...

 

[jervin via AccessMonster.com]

Sir, Actually i havent create a form yet i really dont how to start with. i
had my table1 complete data of items it has a field name sotckno,qtyonhand,
description,partno,serialno etc..My table2 is actually no data yet, it has
field name customer,customerid,stockno,description,qty_issue,recvdate etc..
this will be the table for all the customer that i will be issuing the item.

Now, i want to create a form that will ask me to enter the stockno or a
partno and will then verify into my table1 if the stockNo is available or not.
if the item is vailable it will show the detail information and i could be
able to issue it to the customer..The qtyonhand from table1 will then be
subtracted from the qty that i issued to customer.

Pls note also that i will be issuing more then one(1) item to the customer.

pardon me for my grammar..thank you again..

thank you sir..i will work on this one..

I am assuming you will have a command button that when clicked will check the
quantity and, if sufficient, will produce the report. What you do not say is

[quoted text clipped - 17 lines]

 

[Klatuu]

Good Luck, jervin, We are happy to help.

Sir, Actually i havent create a form yet i really dont how to start with. i
had my table1 complete data of items it has a field name sotckno,qtyonhand,
description,partno,serialno etc..My table2 is actually no data yet, it has
field name customer,customerid,stockno,description,qty_issue,recvdate etc..
this will be the table for all the customer that i will be issuing the item.

Now, i want to create a form that will ask me to enter the stockno or a
partno and will then verify into my table1 if the stockNo is available or not.
if the item is vailable it will show the detail information and i could be
able to issue it to the customer..The qtyonhand from table1 will then be
subtracted from the qty that i issued to customer.

Pls note also that i will be issuing more then one(1) item to the customer.

pardon me for my grammar..thank you again..

thank you sir..i will work on this one..

I am assuming you will have a command button that when clicked will check the
quantity and, if sufficient, will produce the report. What you do not say is

[quoted text clipped - 17 lines]

appreciate for your help...