Search results

  1. 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?
  2. 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...
  3. 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...
  4. W

    Global variables

    Hi everyone, i try to use global variables, but when i want to set a value into those variables, and print it out with MsgBox, these variables stay empty?? I declare the variable in a module like this: Global GLB_taal As String in the first form that give a user a language choice i open the...
  5. W

    List of years with totals of hours

    Hi I have a continious form with textfields as records. Its about total course hours that are calculated. There is a field in the records that holds and calculates the hourse that one have done and another field that holds the max hours they may follow for one year. Every record has h...
  6. W

    Hide a button when a record is found in the database

    Hi everyone, I want to show/hide a button on my form. The button is for entering a new record in the table of the database. Now when i Load the form, i want to check if there are already records in the table for a specific lanID. When there are no records, the butten has to be displayed. When...
  7. W

    Checking if a date falls between two dates?

    Hi everyone, i want to check if a date falls between the first date of a year and the last date of a year. The goal is to go through a table in the database that contains dates in a column. There are for example several dates in the year 2014 and there are dates in the year 2015. What i...
  8. W

    Sum all fields in a tables column and put the sum result into a variable

    Hi everyone, i would like to sum all the column fields in a tables column where an id is the same as the id in that table. I know you can use the SUM function in the select statement of your query. But how can i set this sum result into a variable, so i can use it for calculation further on...
  9. W

    Clickable search list on a form

    Hi everyone, is it possible to make a form where you have two textboxes to search a table and show the search results in a list under the textboxes? Alsow making the list items clickable? Kind regards Wim
Back
Top Bottom