Search results

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...

Thank you sir

Maraming salamat ng sobra sir

Na try ko siya sir gumagana siya pero pagnaka split database siya yung frontend lang yung na backup. Kahit yung backend lang sana. Shortcut lang ang ma save sir need mo pa convert to local table.

Function RunSub() BackUp End Function Sub BackUp() Dim dTime As Date On Error Resume Next dTime = InputBox("Create a backup at", , Time + TimeValue("00:00:05")) If err.Number <> 0 Then Exit Sub Do Until Time = dTime DoEvents Loop MsgBox "Time to create a...

I have button to backup the database with local table it working fine with the standalone. However if i split the database and do same process click backup button but now i have some issue, It backup only the frontend table which shortcut instead of suppose local table or backend. Thank you...