Search results

  1. A

    Trouble Exporting Sorted Data from Access Form with Subforms to Excel

    Hello everyone, I'm encountering an issue when exporting data from a Microsoft Access form, which includes subforms, to an Excel file. Specifically, when I attempt to sort the data in the Access form (either ascending or descending) before exporting, the exported Excel file ends up containing...
  2. A

    Solved Can Grow and Shrink in continuous subform fileds automatically extend or shrink vertically based on the content.

    Hello everyone Can Grow and Shrink in continuous subform fields automatically extend or shrink vertically based on the content.
  3. A

    How i make remember password in form login on my pc only !

    Hello evreyone, How do I prevent other users in internal network To use my username and password if I saved the username and password in the tabel login as remember My UserName have full accsess , i dont need others user to see it . Note :- Database was shared internally in internal network...
  4. A

    Solved why when i change button icon or image in database : erorr message after that The expression may not result in the name of a macro,

    Hello evrey one When i add or Change buttons .icon or images in my databas i see below erorr after it : *The expression may not result in the name of a macro, the name of a user-defined function, or [Event Procedure] *There may have been an error evaluating the function, event, or macro* Note ...
  5. 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
  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

    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...
  8. 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 ...
  9. A

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

    Hi every one want the Autonumber field in the main form to be populated even when you add data in the subform first and have the ability to save the main form without losing the entered data in the subform. I have a main form called "TBLinv" (parent), and I have multiple subforms...
  10. A

    calcculte Total selling based on format filed curancey

    How i mange it please to calcculte Total selling based on format filed curancey (sellamountindivual+sellamountindivualgroup) * (usd or syp or eur ) if filed SellAmount format = AED then SumSF = =Sum([SellAmountIndividual])+Sum([SellAmountGroup]) if filed SellAmount format = USD then SumSF =...
  11. A

    Advice its good idea or not

    Hello everyone i have Entery Form have 02 others supform (multiple item forms) its good idea or not ?
  12. A

    Erorr in code Convert Text

    Hello , I have Form to convert , Example to convert : 05JAN ARNCDG (D) 10JAN CDGARN (I) 06JAN DXBBEY (Q) 04APR BEYDXB (Q) 19JAN BEYRUH (K) Example Result : STOCKHOLM-PARIS-STOCKHOLM DATED ON 05JAN-10JAN DUBAI-BEIRUT-DUBAI DATED ON 06JAN -04APR BEIRUT-RIYADH DATED 19JAN i...
  13. A

    Add Options Without Pending in search form

    Hi Evreyone Some records still pending not finished yet , I Need code or want to add Options (Without Pending& with Pending ) in Search form Becuse Thank you
  14. A

    Solved Sometimes the contents of the form disappear

    Hi evreyone , why Sometimes the contents of the form disappear and needs to restart the database to fix evrey time !
Top Bottom