Search results

Other Issue: On open my subform is on disabled condition as under If Forms!frmTransactionsMain!lblTransfer.Visible = True Then Me.frmTransactionsSub.Enabled = False End if but after validating the data before update event tab is not moving to sub form but it's moving on 2nd record of...

Thanks Pat,

My code is working on command button but how i will implement on before update event, kindly suggest

I will try I have tried this, this works but as you get notification of blank fields it freezes the form and records, and even after filling again the required fields it does not unfreezes the form fields.

Thanks @jdraw, i have removed () now no error but the form is not showing any response on blank fields. Kindly suggest. @NauticalGent , this is beyond my scope, may be this would work, thanks

I have applied validation rule on before update event but I am getting compile error kindly check and suggest please. I have added the code and screenshot. Private Sub Form_BeforeUpdate(Cancel As Integer) If Forms!frmTransactionsMain!lblReceipt.Visible = True Then If CheckForEmpty...

Thanks a lot CJ, It has worked a lot and now no need of union query and its related queries.

Thanks @MajP and @theDBguy, Got the solution from the link which the Maj has shared, thanks

Sorry, I didn't get the idea, kindly tell me how to do....

I have made a query from Crosstab Query to make the "Stock Summary Balance" but if one of the column Heading balance is not available then it shows error message becuase of null stock otherwise the query is working with balances. Error Message: The Microsoft office database engine does not...

Where ????

Thanks Pat, I have solved through UNION and CROSSTAB query.

Thanks Pat, yes transactions table is splitted into two because we are receiving more than one item on a single invoice and transferring more than 10 or 20 items on a single transfer note. tblTransactionsMain and tblTransactions. My database is designed in the scenario as per the attached...

Thanks Jack for the response. I have explained the requirement of the query. I have made query of stock summary as per the following requirements. 1. Opening Stock: closing stock upto the end of the last month would be the opening stock of current month. 2. Purchases: Current month purchases...

Kindly suggest the solution of repeating items in qryStockSummary. I have attached the database file. Thanks

I give a salute to @CJ_London and @Pat Hartman to drive me into a new direction of database and form making and pushed me to make a single form for all of my inventory project. I was a lit bit nervous at that time and at the end I have got success to finalise in that way. Still some points...

Thanks Pat and Tony for the sharing of this knowledgeable and informative video. You both have deeply cleared that what the access is doing at the back end on behalf of us if we are doing something wrong. And cleared so many points which i was wandering around. Thanks a lot.

Actually I am busy in management tasks in office today so I will let you know tomorrow, Thanks

Thanks Uncle Gizmo, Thanks Pat,

Thanks, it's simple and easy to implement but as you know I am a learner if I want to implement like that way then what is the solution.