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