Recent content by Kamayo Ako

Is it possible also sir in a single Result form (report form) if i will change the Purchase Order Number it will update also with the particular Purchase Order Line items.

Thank you so much sir.

How a good day to all. I need your favor. How to lookup Items which belong to Particular Purchase Order and fill to particular report form. Thank you so much.

Maybe this will help

If found this from Mr. Alessandro Grimaldi answer with someone asking same concern of yours sir. Maybe this is not specific solutions but this helps me to avoid saving record without clicking save button and closing form without saving entries. Private isOK As Boolean Private Sub...

I will do that sir. Thank you so much.

Have a good day to all I have to Tables - Sale Order Table - Production Order Table What is the best way to generate production order as per Sales Order line. As per image below shows we have 3 lines in Sales Order, when i click generate it will add to the Production Order Table...

Yes, I will do that. Thank you so much

Thank you sir.

I used below query and works fine sir. TRANSFORM Sum(ForecastHistory.ForecastQty) AS SumOfForecastQty SELECT ForecastHistory.Description FROM ForecastHistory WHERE (((Year([ForecastDate]))=Year(Date()))) GROUP BY ForecastHistory.Description PIVOT Format([ForecastDate],"mmmm") In...

Thank you so much sir. i will do it.

thank you so much sir.

Have a good day to all. I have the following query to order by month but still not sort accordingly TRANSFORM Sum(ForecastHistory.ForecastQty) AS SumOfForecastQty SELECT ForecastHistory.Description FROM ForecastHistory GROUP BY ForecastHistory.Description ORDER BY Format([ForecastDate],"mmmm -...

Actually naka shared siya sir. Halimbawa PC-1 ang ginamit ko i can view and open... pero pag ibang computer hindi niya mabuksan yung attachment na inattached ng PC-1.

I just want to ask again your favor on how to resolve the issue on attachment. 1. If database is standalone, attachment is now issue. 2. The problem is. When i split the database. - I put the backend on PC - 1 - PC-1 user can attached and open the file attached. 3. I put...