Search results

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.

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

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

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

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.

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

I have i combox which row source : SELECT tblMpf.MpfID, tblMpf.Particulars FROM tblMpf ORDER BY tblMpf.MpfID; - Is it possible that when i select one item the following all items in the list will add to the record automatically ( 1 - 20 ) Thank you so in advance for the support. Kamayo Ako

I have a report with report header and page header. On this case i want to display only page header starting on Page 2 and so on. Thank you so much in advance Kamayo Ako

Have a goodday to all!!! I just want to ask your assistance again on how to extract the remaining years, months and days before compulsory retirement date. Attached the sample database for the concern transaction. Thank you so much in advance.....

tblInventory - Filtered by section ADMINISTRATIVE SECTION Trans Date ItemID Description...

Attached is my sample excel file. Currently as per file i've attached: showing " Twenty Four Pesos Only And Ten /100" I need to show like this " Twenty-four and 10/100 pesos" Thank you so much for your support.

Have a good day to all Master. 1. I have textbox which autofill after selecting the image from E:\Residents Images\My Pic.jpg = No Issue with this process and i used below code to browse the images: Private Sub Browse_Click() Dim F As Object Dim strfile As String Dim strFolder As String...

Is it possible to dedicate one table (tblArchive) and all deleted records from any transaction will save there. Thank you for any possible way on how to achieve. I try append and delete query but i need to make to all transaction tables since fields are not identical.

Have a good day to all!!! I just want to ask your favor on how to hide/unhide item in the combo box as per user login. Combo Box item List 1. Remove Stock - This will show only for user - A 2. Manufactured Parts - This will show only for user - A 3. Move to Warehouse - This will...

I Just want to say thank you for accepting me here masters.. Im Newbie here.