Search results

I misspelled it. :).

Indeed i fixed the name of the variable. Now he doesn't give an error, just the value i want to set into the variable isn't set into the variable when i click the button.

I have set Option Explicit in all the modules and form code. But no errors when i use the application. The value isn't put into the global variable.

Hi thanks for answering. It seems that the error is that i have to, in my Button where i want to set a value in the variable, declare the variable again?

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...

To bound the form to a table you need to set the RecordSource to a query that you first make with the query design. When your recordsource is set, you can select for each Textbox the source wich will be the names of the columns in your table. Wim

If you want all these fields to store in the same table, then you can insert them with the ac.. options in the DoCmd statement. https://msdn.microsoft.com/en-us/library/office/ff192694.aspx You have to first bound your fields to the table :) Wim

Hi Mahendra, are you sure that the types of data in the textboxes and these in your table are the same? You can use also plain variables to query an insert or update to your table. The variables you fill as follow: Dim variable As Type TextBox.SetFocus variable = TextBox.Text Afther that you...

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...

If i set rs.EOF before rs.MoveLast it won't work. Either with only rs.EOF it won't work :(

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...

Hi pr2, I will try it this afternoon. Thanks ;) Wim

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...

I've sorted it out! It was a matter of qoutes. So this Thread is Solved! Thanks a lot Minty.:D Regards Wim

Hi Minty, the Id parameter in my code is a String. I have the following code: uren_gevolgd_db = DSum("uren", "dbo_Lan_opleiding", "Id_landmeter =" ' & landmeterId & ' ) He gives all the time the error that landmeterId gives an error. Wim

Aha that's nice. Didn't knew that you could set a sort of where clause into that code :D I will try it out. Thanks

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...

Yes I am looking at the video on Youtube and i think that's what I want. I wil just have to search for a way to make a textbox clickable :D. Your links are already very helpfull. Thanks a lot for that ;) Regards Wim

Hi jdraw, The reason why there are two textboxes is that they have to search the landmeters on both the LandmeterId and there name. The goal is to search a Landmeter on LandmeterId or on his/her name so they apear in a list under the search textboxes and the items in that list has to be...

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