Search results

Solutions: To find the Quantity on Hand from tables / queries control on MainForm. MainFormName: Adjustment SubFormName: AdjustmentSub QueryName: TransactionsExtended =IIf(IsNull([AdjustmentSub].[Form]![ItemsFK]),Null,DSum("[Stock_In_Out]","TransactionsExtended","[ItemPK]=" &...

Yeah Sure,,, Why not....

====get solved by myself=============

======get solved by myself===============

after putting option explicit back again error going on the following. Cancel = True

Thanks Kamayo ...

kindly suggest why the filter is not showing results properly.

My question in simple terms is, DSum quantity on hand from transactions extended query where item id is equal to item id in sub form, Up to this part it's working, now adding 2nd condition, and trandate in transactions extended query is less than or equal to trandate on main form. When i...

The control is on the main form trandate.

In the Main form i have got the result it's working but in sub form it's generating error.

I am giving reference in the conrol source and it is an unbound field in subform.

Its actually a shortdate in the table. May be there is a conrol reference issue with the main form or something else.

kindly correct the formula for the reference of date in sub form. =IIf(IsNull([AdjustmentSub].[Form]![ItemsFK]),Null,DSum("[Stock_In_Out]","TransactionsExtended","[ItemPK]=" & [AdjustmentSub].[Form]![ItemsFK] & "And [TranDate]<= #" & [Forms]![Adjustment].[Form]![TranDate] & "#")) HeadFormName...

thanks Pat...

=====got the solution by myself===============

Formula correction required: =IIf(IsNull([AdjustmentSub].[Form]![ItemsFK]),Null,DSum("[Stock_In_Out]","TransactionsExtended","[ItemPK]=" & [AdjustmentSub].[Form]![ItemsFK])) upto this step it is working, i want to give date reference...

=====Got Solution by myself=======

Kindly suggest for the followng as per the attached samples a. I have made adjustment form. I don't want to see the Qtyonhand and PhysicalQtyAdj columns after saving the record. b. These should have to be available at the time of adjustment of new record.

Hi CJ, how are you... You are right, the timestamp is most important factor in recording the transactions. In any organisation, once the stock take finished and closed after the confirmation from puchase department, it is not allowed to adjust at the back date and even some software have...

Both scenarios are correct, i will try both of them to improve my skills