Search results

  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 :(
  16. W

    Checking the last record in a loop over a Recordset

    That doesn't solve the problem :(. When he throws the error he points to this line: hours_followed = DSum("uren", "dbo_Lan_opleiding", "Id_landmeter ='" & landmeterID & "' and Year(datumopleiding) = " & yearr & "") When you loop through the years and in the table there are years 2015, 2016...
  17. W

    Checking the last record in a loop over a Recordset

    Yes indeed i have problems with null values. But how do i implement the NZ function?
  18. W

    Checking the last record in a loop over a Recordset

    So if i use rs.Movelast, i can check with the year? Saying if (year = rs.Movelast) then ...
  19. W

    Checking the last record in a loop over a Recordset

    Hi, when you loop over a recordset with Do While Not rs.EOF. How can you check what is the last record and whats in it? I need to know this because i have an invalid use of null when i loop over a recordset to get every year to calculate hours per year. When the error occurs he points out...
  20. W

    Global variables

    Maybe i can ask a simpler question? Can you use global variables in and between forms? Or Is the declaring and initializing of global variables in a module compulsory? You then create functions in the module, where you initialize the variables, that you call in the Load function of the Forms?
Back
Top Bottom