Search results

  1. Safari

    Making + plus sign in report

    Dear All Is any way to make group with + sign like excel? For Example: Customers + When I click on + it's appear all customers name Thanks in advance
  2. Safari

    Label Caption In Data Sheet

    I HAVE DATASHEET AS SUBFORM .. I WANT TO CHANGE LABEL CAPTION ON OPEN EVENT I USED THIS CODE : ME.LABEL1.CAPTION="iTEM NAME" BUT NOT WORKING WHATS THE PROBLEM ? THANKS
  3. Safari

    Solved change any code color to red

    when i am trying to write vba code its automatically change font color to red and not accepted to complete the code also refuse to get any text property like : me. not open the properties combo box . how can i solve it
  4. Safari

    tree view control

    hi all i have a treeview control on my form ( office 2010 32 bit ) with windows 10 32 bit and it working well on my laptop but ... when i try to open the same form on anther PC which have also ( office 2010 32 bit ) but with windows 7 32 bit , the treeview control not appear completely ...
  5. Safari

    ALLOCATE QUANTITY

    HI ALL IF YOU PLEASE I WANT YOUR HELP TO COMPELET MY QUERY I WANT TO ALLOCATE THE QUANTITYOUT FILED ON QUANTITYIN , I UNDERSTAND THE IDEA BUT ITS HARD FOR ME .. FOE EXAMPLE: ID Transactiondate Itemcode itemname QuantityIn QuantityOut AllocateQuantity 1 01/01/2000...
  6. Safari

    Solved FIFO STOCK

    HOW CAN I MAKE FIFO STOCK IN MY CURRENT DB WSING QUERIES ? I HAVE ALL DATA IN ONE FILED AND I WANT TO GET STOCK COST LIKE : ITEM A 25 UNIT 10 WITH 10 $ 10WITH 11 $ 5 WITH 15 $ IF I SOLD 21 UNIT THE ACCESS CALCULATE ( 10*10 + 10*11 + 1*15 ) HOW CAN I DO IT ? THANKS
  7. 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
  8. 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
  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

    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
  12. 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
  13. 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 =...
  14. 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
  15. Safari

    Problem with append query..it doesn't work

    Hi All , I need your help My problem is that the data is repeated every time the query runs I want to run the append query without duplicate data and append only the new records, not the old and new ones. Attached is the database for help and modification Query name: Appendfrom Table to...
  16. Safari

    Conditional format

    Hi All How to make textbox ( bound ) enabled by conditional format with anther unbound textbox? I made expression by if statement but its not working..
  17. Safari

    Event on 'unbound' textbox

    Hi All I want to use temporary nemric value in unbound textbox, but i cant seem to run any code on an unbound textbox. Like : If nemric value is greater than 1 Make X textbox is enabled I tried to make it with many events like after update but nothing happened. Can anyone help me Thanks in...
  18. Safari

    TEXTBOX CHANGE VALUE

    Dear All PLEASE HELP I WANT IF TEXTBOX NAMED " TEXT175" CHANGE VALUE IN FORM INVOICEHEAD IT WILL CHANGE THE PROPERTY OF ANTHER TEXTBOX FOR EXAMPLE: IF TEXT175 VALUE >0 THE TEXTBOX NAMED " DISTAX " ENABLE TRUE AND IF TEXT175 <=0 THE DISTAX ENABLE FALSE THANKS
  19. Safari

    Append one record " Salesinvoiceappend "

    HI ALL MY QUERY NAMED " Salesinvoiceappend " IS NOT WORKING AT ALL AND I DONT KNOW WHY ? CAN ANY ONE CHECK IT AND MAKE IT RUN I WANT :- IF THE TABLE TBLGL NOT CONTAINS " INVOICEID " AND NOT CONTAINS "GOODID" THEN RUN QUERY AND APPEND THE RECORD . THANKS
  20. Safari

    Solved set the default value by user

    Please help with the attached data base : I want When i press the default button in invoicehead form The value in text box named ( costcentern ) and combo box ( costcenterid ) is become as a default value for them in the current invoice And still for all the following invoices too when i...
Top Bottom