Search results
-
M
search description txtbox not showing all items
i have a product table & a transaction table, in the query i need the Transactions with the Description Critiria to show. -
M
search description txtbox not showing all items
SELECT tblInventoryTransaction.ProductCode, Sum(tblInventoryTransaction.ActualQty) AS SumOfActualQty, tblTransactionType.TransactionType, tblInventoryTransaction.Ref_no, tblInventoryTransaction.DateofTransaction, tblInventoryTransaction.ProductCode, tblInventoryTransaction.Qty... -
M
search description txtbox not showing all items
can you help with rewrite the code as i have done in Query Design not familiear with SQL Codes -
M
search description txtbox not showing all items
SELECT tblInventoryTransaction.ProductCode, Sum(tblInventoryTransaction.ActualQty) AS SumOfActualQty, tblTransactionType.TransactionType, tblInventoryTransaction.Ref_no, tblInventoryTransaction.DateofTransaction, tblInventoryTransaction.ProductCode, tblInventoryTransaction.Qty... -
M
create inventory in Access
worked ([Forms]![frmMain]![TransactiontypeID]=1 And [Qty]>0) Or [Forms]![frmMain]![TransactiontypeID]>1 And [Qty]<=[Form]![txtTotalQuantityinStock] -
M
create inventory in Access
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... -
M
Display Account balance on Main form from sub form transactions
as required uploading the DB. -
M
Display Account balance on Main form from sub form transactions
used on Text213 to show the value of Sub Form. =[Forms]![frmMain]![tblInventoryTransactionSubForm].[Form]![txtTotalQuantityinStock] sometime it appeared on clicking on the Product some times its not showing the result, giving only errors. -
M
Display Account balance on Main form from sub form transactions
=[Forms]![frmMain]![tblInventoryTransactionSubForm].[Form]![txtTotalQuantityinStock] it worked added in event & data too. thanks but after changing the head its giving #Error. -
M
create inventory in Access
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. -
M
Display Account balance on Main form from sub form transactions
not worked with me. getting error. -
M
create inventory in Access
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. -
M
create inventory in Access
yes, have did some what, but still need more to do. -
M
if Qty Value is zero or less than
where to write the code, in Report opening button or in a module -
M
if Qty Value is zero or less than
is there a way to do if Qty Value is zero or less than, the row from the report should be deleted or hide. -
M
ms access sub from value to main form
i want to make a validation rule on Sub form value should be reflecting on main form if the value goes below 0, it will give popup on entering the values for the same. i hope m clear to understand my query, if not please let me know. thanks.