Search results

The same thing I have written that if anyone of the conditions will not met then it will pop up message. But mike said, this statement is all wrong. I want codes for the said conditions.

Who has told you this is all wrong, It's up to you at which place you want to make limitionations or validations, For the end user easiness, Many modern software are working like this. So, I will move on this way.

I am applying validation rules on form close/go to previous record on main form and subform. The requirements are as under; 1. If the user just enters the information on the main form and wants to save record or wants to exit then show a message, "You cannot record a blank transaction". 2...

I haven't tried that way, I was trying to solve through VBA coding because I have only one form to receive inventory, transfer of inventory, etc with six transactions types. And every transaction type have a link on dashboard with different scenarios but basically at the backend only one...

solved by myself,

A good sense of humour :mad:

Yes right,

Every thing is working normally. There is no error. I want to make after update event on items in subform in transfer case as the form is only one for data entry with all three cases. How i will get that in transfer case.

I am making warehouse inventory project. **(Currently the image is not available.)** So, explaining without image. Main Form Name: frmTransactionsMain Sub Form Namr: frmTransactions Sub Sub Form Fields: Items, Quantity, PackingSize, QOH (DSum value coming from query) I am using the...

My form is opening with three select case conditions, "Receipt, Transfer and Adjustment". At the time of transfer, If the stock balance of any item is null then the quantity field should have to be disabled for data entry and should have to show a message. These fields are available on the...

Saving of record with Main and Sub Form: I want to save record with save button on main form but after finishing data entry on Main and Sub Form. Kindly suggest possible solutions.

.Recordsource = "Select * from tblTransactionsMain where TranTypeFK <=2" Thanks MajP, It has fulfilled my requirement thanks

I have three conditions in OpenArgs Case: Receipt, Transfer and Adjustment. I want to see only those records as per the OpenArgs Case but it's showing all records of other cases. The database file is attached herewith for your info.

how to make a filter on a form as per select the case OpenArgs, In simple terms I want to see only those records which are related to "Receipt" and so on. on the other hand, i want to stick in the same stack as under Select Case Me.OpenArgs Case "Receipt" With Me...

In a month, I have learnt a lot through this forum and still learning. The people in this forum: some are very cooperative, some are moody, and some have very odd moods. Any how, In short, you could resolve your issues in a shorter period of time through professionals experts suggestions and...

thanks Minty

I am working on openArgs. I have three conditions Receipt, Transfer and Adjustment. As per the lable visibility the combo should have to show only those warehouses which i have required. Your precious hints are required please.

QOH is a dsum function from query TransactionsExtended =IIf(IsNull([TransactionPK]),Null,DSum("[Stock_In_Out]","TransactionsExtended","[ItemPK]=" & [ItemsFK] & "And [TranDate]<= #" & Format([Forms]![Adjustment]![TranDate],"mm-dd-yyyy") & "#")) On PhysicalQtyAdj field, after update event for...

how to hold quantity on hand to be updated until record saved but it's changing as quantity difference shows adjustment of stock. I have attached the screenshots.

Kindly suggest hints as CJ mentioned in the 2nd paragraph, I am making through Dashboard Receipt, transfer and adjustment links on dasshboard will open the same form but with conditions of visibility. Just pass the hints,