Search results

  1. mobarak ahmed

    help with salaries Database

    hi dears , i hope you are doing well i have two issues here 1- in "Salaries_Emp" and "Salaries_Temp" Form when i Payroll Period then select Dep_Code then ID and save the record by clicking button Save the Dep_Code combobox does not return to the last selection department so i have to select...
  2. mobarak ahmed

    Solved how to run "after update" event on text box according to set value to number via VBA

    Hello Dears, i have a form to record employee monthly Attending and leaving days and over time i have Combo box have employees names , on the combo box after update i set text box "days" value to "30" as that is the most default number in text box days i have some events after update it but...
  3. mobarak ahmed

    Solved How to use "NOT EXISTS" in MS Access?

    Dears , i hope you are doing well i use the form ' Salaries_Emp ' to record the attendance of employees to table ' Salaries_Emp ' i need when i chose the department from ' Combo_Dep ' show only Employee Name in ' Combo_Emp_Name ' that dose not recorded yet any help will be appreciated
  4. mobarak ahmed

    Get Unit Rate from Web site directly to MS Access

    Hi dears In form invoice i want to get US Dollar (Unit rate) in case the Project currency is USD from this site for example invoice to : AC Boilers EGYPT -- Project name : Cairo West E USD 10089-CP-105 / Electrical I&C Supply and Installation to be paste on "Currency Unit Rate" Text box * date...
  5. mobarak ahmed

    Make a Vertical Line the Same Height as a CanGrow/CanShrink Control

    hi Dears hope you are doing well i want to setup this tutorial tutorial Link on "rpDueStatment" Report , any help will be appreciated
  6. mobarak ahmed

    Make Break down to contract items in invoice form

    hi Friends , i have contract form which contain Contract_details subform every contract have his own details items in invoice form i have feild called invoice value it should be sum of "item_Value_Current" in contract_details table now i want When I choose project name , the items of this...
  7. mobarak ahmed

    make conditional total in report

    hi , I have a report named " ReportCustomerProject " it should show all projects in one page sort by 1- project type 2- customer name 3- project name and it should show the sup total of every project but now the total text box shows total of all projects under every project any help or advices !
  8. mobarak ahmed

    Make one row for every invoice and it’s payment

    I’m now try to mack clients management database for contracting company It Consists of two parts invoices and payments Every invoice have unique number To be considered that every payment should be against specific invoice and not necessary that the client send all invoice at one time let’s...
  9. mobarak ahmed

    how can i make auto journal entries in access

    I am now make small data base for client department, invoicing and payment all data exist when i enter the invoice or the payment so it will be nice if i can make query or report to make the journal for this invoice or payment i have the data base ready if any one want to give it a try
  10. mobarak ahmed

    Make Due Date

    hi Dears , I have Date of invoice and collection Days i want to make Due date and statue of collection "Due or Not Due " and remaining days for example:- Date of invoice is 6/6/2021 number of Collection Days "30" days =6/7/2021 Due Date will be date of invoice + 30 statue of collection will be...
Top Bottom