Recent content by wim1981

  1. W

    How to get system language in Access 2010 vba

    Hi, i've impelemented and tested the link from Trevor and it works fine :D. Thanks for the tip Wim
  2. W

    How to get system language in Access 2010 vba

    I want to know how i can retrieve the Windows System language in vba in Access 2010?
  3. W

    Filtering second table from the first in a form

    I want to filter all the records from the last 3 years. At te top of the list the present year
  4. W

    Filtering second table from the first in a form

    Hi arnelgp, i don't want to calculate the days or year between two dates. I want to display only the records for 3 years.
  5. W

    Filtering second table from the first in a form

    I ain't getting any data from my query when i integrate this. Here's my query SELECT dbo_Lan_opleiding.datumopleiding, dbo_Lan_opleiding.omschrijving, dbo_Lan_opleiding.uren FROM dbo_Lan_opleiding WHERE DateDiff("yyyy",dbo_Lan_opleiding.datumopleiding,Date())=3 ORDER BY...
  6. W

    Filtering second table from the first in a form

    Hi everyone, i have to make a form with two subforms with each a table with data. The first table has maximum 3 years.that are shown. The second table has to have all the records from those 3 years that are stored in the table. Every year in the first table has a result from several dates in...
  7. W

    Checking the last record in a loop over a Recordset

    And i then need to do this also with the other DCounts? That don't help.
  8. W

    Checking the last record in a loop over a Recordset

    This is the code Private Sub BtnNieuweOpleidingsuren_Click() DoCmd.RunCommand acCmdSaveRecord MsgBox "De gegevens zijn opgeslaan" Dim yearr As Integer Dim nextYear As Integer Dim landmeterID As String Dim SQL As String Dim SQL1 As String Dim rs As DAO.Recordset Dim rs1 As DAO.Recordset Dim i...
  9. W

    Checking the last record in a loop over a Recordset

    i tried the debug print and its get me 2 0 0 so 2 for 2015 and for further years 0
  10. W

    Checking the last record in a loop over a Recordset

    The differents is that now he puts the result in all the years after the year you inserted the hours so, if you insert hours for 2015 and the result for 2016 is 28. He defaultly sets the result for 2017 also at 28. It should be as before just 28 at the year 2016.
  11. W

    Checking the last record in a loop over a Recordset

    It works for the error, but then the calculation gets messed up.
  12. W

    Checking the last record in a loop over a Recordset

    Ive seen in the database that the hours column doesn't accept nulls. I could change that so it allows nulls. But maybe it is not best practice?
  13. W

    Checking the last record in a loop over a Recordset

    Aha i can check if hours_followed is Null of not? :)
  14. W

    Checking the last record in a loop over a Recordset

    The year from where he starts the calculation is good. It is the year afther the last year thats in the table he wants to calculate that gets the null error
  15. W

    Checking the last record in a loop over a Recordset

    its a runtime error "94" Invalid use of null When i have inserted the hours for 2015 and there are no hours for 2016, then he get's the error on year 2016. So value in debug mode is 2016 No i can't upload the db :(
See more
Back
Top Bottom