Search results

  1. A

    Solved log off users at certain time

    i have Simple Live chat between users as messages pop Running with timer = 1000 is only 1 seconds. now 😞 should be better to changed to 30 seconds or delete it from the system , Thank you for your advice . i appreciate it @The_Doc_Man
  2. A

    I need a professional to review the database

    @June7 & @The_Doc_Man Thanks for your advice! I've made the changes you suggested to my database. Your help means a lot 👏 i updated it as below
  3. A

    I need a professional to review the database

    Hello everyone, I'm looking for help . I need a professional to review the database (codes and the relationships) to ensure it's reliable to avoid future issues. I'm not a professional I'm willing to pay a small fee if it's allowed her . Thank you
  4. A

    Need idea or way to To build Commission Report 35 % from profit

    Thank you for your advices . @Pat Hartman
  5. A

    Need idea or way to To build Commission Report 35 % from profit

    i try before to added two new calculated fields: SumOfSellingPriceAED and SumOfPurchaseAmountAED. These fields calculate the total selling price and total purchase amount converted to AED using the aedX IF IT USD USE USDX , IF IT SYP USE SYPX , IF IT EUR USE EURX SELECT DISTINCT...
  6. A

    Need idea or way to To build Commission Report 35 % from profit

    Hello Need idea or way to To build Commission Report 35 % from the profit (TOTAL Selling - TOTAL Bills ) * 35 % if invoice is Commission (checkbox) true its multi Currency , Based Currency =AED , Exchange rate is diffrent from invoices to other
  7. A

    Create a union query

    Thank you Mr. Pat Hartman for it , I am learning about it now , and I have already fixed some of it .
  8. A

    Create a union query

    tblBill = table of bills = equal = purcheses from our ( suplliers ) to show how much total bill unpaid for each suppliers
  9. A

    Create a union query

    Bill TABLES names = tblBillT & tblBillH
  10. A

    Create a union query

    i will try to make it in one
  11. A

    Create a union query

    Yes Mr mike , A Customer on a specific Date will Order a number of Items (Tickets ) on on other specific Date will Order a number of Hotels . , i make it seprate in tables ticket & hotel cuz diffrent in some fields
  12. A

    Create a union query

    can you explain more or one example please
  13. A

    Create a union query

    T short name for Tickets , H for Hotels Thank you for your replay T = Tickets & H =Hotel , its 2 different department
  14. A

    Create a union query

    Hi i try for long time To create a union query to make filter by (Customer name or Customer id ) Customer Name data : same source table ( tblcustomers ) want if i SEARCH BY Customer name To show recordes form (tblinvT& tblinvH ) , maybe error in relations to create it 1st screenshot...
  15. A

    Solved how i connect 1st description with first selling price , 2nd description with 2nd selling without dublicated

    i fix it by added a new filed ( row) number and connected together .Thank you for your help @CJ_London (y)
  16. A

    Solved how i connect 1st description with first selling price , 2nd description with 2nd selling without dublicated

    Hello , i tray to make invoice print from main form . how i connect 1st description with first selling price , 2nd description with 2nd selling without dublicated note : its always matched (descriptions number = selling price numbers ) example 6 description = 6 selling prices sql ...
  17. A

    i want the autonumber field in the main form to be automatically populated even when you add data in the subform first

    Thank you @ebs17 , its work now
  18. A

    i want the autonumber field in the main form to be automatically populated even when you add data in the subform first

    its good idea , work perfect , Thank you Mr. @Pat Hartman
  19. A

    i want the autonumber field in the main form to be automatically populated even when you add data in the subform first

    Hello Mr.Mike @mike60smart I hope you're well. Thank you for your advice , i appreciate it
  20. A

    i want the autonumber field in the main form to be automatically populated even when you add data in the subform first

    @The_Doc_Man Thank you for your clarifications
Back
Top Bottom