Recent content by voxy

  1. V

    Solved Set Date in Form Field

    thanks for your input. I'll make it more detail, I want to make about Payment's Due date so the due date will be the date you submitted the invoice (in my case the name of the field is "Tgl Tukar Faktur") plus TOP and my payment's only at the 10th, 20th and 30th every month and in the...
  2. V

    Solved Set Date in Form Field

    Halo Friends, I need help to solve my problem How to set datevalue in field my condition is like this if I click the command button then the "jatuh tempo" Field value will be "Tgl Tukar Faktur" + "TOP" and after the Adding date, i want to set the datevalue to if the date is between 31 to...
  3. V

    Solved how to grouping data based on the value of checkbox

    thanks arnelgp my problem has been solved
  4. V

    Solved how to grouping data based on the value of checkbox

    Halo Friends, I want to make a report based on the Value of checkbox and the sample of my data is on my attachment (Sampel) and the report that I wish to show is like the pic (Sampel2) please give me some advice thanks before
  5. V

    Fixing Calculation in Query

    thank you Pat, my Problem has been solved. thanks guys
  6. V

    Fixing Calculation in Query

    Halo Everyone, Please Help me about this MisCalculation in my Query. the sum of the sisastok should Be Zero
  7. V

    Fixing Calculation in Query

  8. V

    Access Error

    Halo, I Just installed microsoft office 2019 when I want to start making new database in Microsoft access this message occured. please give me some advises how to solve the problem
  9. V

    Solved vba code for finding skip number

    ok, the example of my question is like this I have a database such as: 0001, 0002, 0003, 0004, 0005, 0006, 0007 and so on and then I delete the no 0005 so the result after I delete the 0005, my database should be like this: 0001, 0002, 0003, 0004, 0006, 0007 and if I want to add a new...
  10. V

    Solved vba code for finding skip number

    No, it isn't an autonumber
  11. V

    Solved vba code for finding skip number

    halo, is there any way to find a skip number and then fill new data to the skip number example: my data 1 2 3 5 6 8 so if I want to make a new data, it will fill with number 4 which is skip in my database thanks before
  12. V

    Hello from Indonesia

    Hi Adam,actually Indonesia is a tropical country, so we don't have any dangerous typhoon :)
  13. V

    How to make sequential number combine with string

    yes, my database is like this: TableID contains ID, Name, Dept, Nick example : ID Name Dept Nick 1 Denny Purchasing DN 2 Victor Purchasing VC 3 Anton Purchasing AN so If Denny use a Purchase Order Form and press add new record, the value of the PO number would be ...
  14. V

    Hello from Indonesia

    Hi I am about a year experience in VBA programmer. I'm From Indonesia, and looking forward to get more experiences especially in microsoft access Frans
  15. V

    How to make sequential number combine with string

    Halo, I have a question about how to make an auto sequential number combine with string. example : SLS/19/AA/00001 SLS/19/AA/00002 SLS/19/AA/00003 and so on and the condition are : SLS is default word 19 is the year AA is the nick for the user 00001 is the number thanks before
Top Bottom