Search results

  1. Safari

    SEARCH WITH ( YES OR NO ) DATA TYPE

    HI ALL HOW CAN I MAKE SEARCH QUERY FOR 2 FILDES ( YES OR NO ) I WANT WHEN I CHOOSE 1 OF THEN GET THE RESULT FOR 1 WHEN I CHOOSE ONE THE 2 FILDES TOGETHER I GET NEW RESULT FOR BOTH I TRIED BUT NOT WORKING PLEASE HELP
  2. Safari

    Using multiple Combo-boxes in Access as query criteria

    very good if you please .. whats the code if i have yes or no filed ?
  3. Safari

    Using multiple Combo-boxes in Access as query criteria

    HI ALL How To Use Multiple Combo-boxes in Access as query criteria Like My Attaced DB i want if choose date from 1 combobox the query is run and if i choose data from 2 combobox the query is run too ( with 2 conditions ) At All i want to run query if i use 1 combobox data or 2 combobox together
  4. Safari

    repeat code with each field ms access

    thank you very much
  5. Safari

    repeat code with each field ms access

    thanks
  6. Safari

    repeat code with each field ms access

    if no 1 is more than 300 the gray with red line is unlock .. its ok when i move to the no 2 the 2nd record .. filed it is not apply the code and only work with no 1
  7. Safari

    repeat code with each field ms access

    ok .. wait pls
  8. Safari

    repeat code with each field ms access

    is it possible to make it with : do while ?
  9. Safari

    repeat code with each field ms access

    hi all i want to know how to repeat code with each field in column for example when i use if it only apply for the 1st record only i want to apply it for all records ex : if me.cash = 100 then msgbox"good" end if how to repeat this code in each filed in recod thanks
  10. Safari

    Solved divide one payment with many invoices

    Dear All i want to know how to divide one payment with 3 invoices for example : my customer have 4 invoices : 1st invoice on 1-1-2022 with total 1000 $ 2nd invoice on 15-1-2022 with total 2000 $ 3rd invoice on 1-2-2022 with total 100 $ so all total invoices amount is 3100 S then the...
  11. Safari

    Solved How to Create a Running Total Sum Query in Microsoft Access

    IF YOU PLEASE CAN YOU SEND ME THE DB WITH EDIT TO CHECK THE CODES BECAUSE I WANT TO SEE IT HOW IS IT WORKING
  12. Safari

    Solved How to Create a Running Total Sum Query in Microsoft Access

    its not clear for me still need some help
  13. Safari

    Solved How to Create a Running Total Sum Query in Microsoft Access

    Hi All I Want to Create a Running Balance as Total Sum in Ms Access Query I Tried Many Times But Not Working can any one help me and edit the query " Aging" in my attached DB Query name : Aging i want new column named NetBalance showing me the running balance for each record in the query
  14. Safari

    Solved COMBOBOX search as you type

    HI ALL HOW CAN I DO SEARCH INSIDE COMBOBOX WITH ANY PART LETTER FOR EX: BALL WHEN I PRESS A OR L COMBOBOX REUSLT IS BALL AND RECODRD IT IN FIELD I ATTACHED THE DB FOR HELP FORM NAME : INVHEAD COMBOBOX NAME : ITEM NAME THANKS
  15. Safari

    CLOSING ACCOUNTING PERIOD

    i sent my tobic in english ..
  16. Safari

    CLOSING ACCOUNTING PERIOD

    HI ALL HOW CAN I DO :- IF SALES INVOICE DATE BETWEEN DATE 1 AND DATE 2 SALES INVOICE CANT SAVE OR ADD CLOSING FORM NAMED: tarheel INVOICE CHECKBOX NAMED : Check4 SALES INVOICE NAMED : invoicehead TABLE FOR CHECKBOXES NAMED : closingperiod UPDATE QUERY NAMED : cashintr IF CHECKBOX VALUE =...
  17. Safari

    Solved select .. where

    VERY GOOD
  18. Safari

    Solved select .. where

    HI ALL , PLEASE I WANT TO MAKE QUERY USING VBA CODE FORM NAME : STORES COMBOBOX : STORE COMMAND : COMMAND3 WHEN I PRESS COMMAND3 .. SELECT STOREID CODE FROM COMBOBOX THEN RESULT IN QUERY DEBEND ON COMBOBOX NUMBER PLEASE HELP
  19. Safari

    Problem with append query..it doesn't work

    you are a great man thanks
Back
Top Bottom