Search results

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

I got loan of a 5,000 with monthly interest of 6%. I will pay it for 3 months in a semi monthly basis, thus my monthly installment is 983.33 I did not use PMT in computation, simply just [5000 x 0.06 x 3] + 5000 / 6 I try to apply in the attached sample but i failed to do. thank you.

thank you sir for the response.

What is the best way to extract appropriation as per percentage distribution. 1. Distribution Percentage can be changeable 2. Particulars/Services can be change or have an additional - example i need to add Represenstation Expenses 5% 3. Maximum 100% Total...