Search results for query: *

I have a form with some searchfields ... When i fill in a criterion i want to see the info about it ... f.e. < 'john' > then see : John, 20, Male ... when i click on the button in Form_Search ... i want the results in a DataGrid in Form_Results .... i don't know how to work with...

the solution :D This is the final version of my code en it works perfectly ;) 'Insert in View Clienten myDatabase.setQuery("INSERT INTO Clienten (Naam, Voornaam, Tussenvoegsel, Voorletter, Geslacht, Geboortejaar," & _ "Straatnaam, Huisnummer, Toevoegsel, Postcode, Woonplaats)" & _ "VALUES('"...

solution yeah ... i extracted the clientID created by the DB when inserting the first query with Select ... and then inserted it with the 2nd insert ... thanx for the help all of u :)

:cool: Hi folks ... Can someone help me with this one ??? 'Insert in Tabel Clienten myDatabase.setQuery("INSERT INTO Clienten (Naam,Voornaam,Tussenvoegsel,Voorletter,Geslacht,Geboortejaar," & _ "Straatnaam,Huisnummer,Toevoegsel,Postcode,Woonplaats)" & _ "VALUES('" & TxtBoxNaam1.Text & "','"...

solution Thanx all of u for the help .... I did it like this : Public Function Required() As Boolean For Each Ctrl As Control In NAW.Controls If ctrl.Name.Equals("TxtBox1") = False And ctrl.name.Equals("TxtBox2") = False Then If TypeOf Ctrl Is TextBox Then If Ctrl.Text.Equals(String.Empty)...

I've done that ... it's now working, but i have 1 problem and that's I have a textbox 2 actually which aren't required .... how can i exclude them from the loop ?? Public Function Required() As Boolean For Each Ctrl As Control In NAW.Controls If TypeOf Ctrl Is TextBox Then If...

I must say you're funny man :D ... the code for the function is : Public Sub Required() ForEach Ctrl As Control In NAW.Controls IfTypeOf Ctrl Is TextBox OrTypeOf Ctrl Is ComboBox Then If Ctrl.Text.Equals(String.Empty) Then MsgBox("U missed a spot", MsgBoxStyle.OKOnly, "Cleaning") EndIf EndIf...

1. by the way .. i wanted to ask something but couldn't find a name for the thread so i post it here ... I have a textbox and each time i fill in 1 letter the prog has to put a dot behind it .. ( for the letters of the name ) f.e. E.A.R. 2. and how to set the letters to Capital .. so if i...

Hi, the loop checks the controls and after that when i click ( 1 x for every empty control ) the OK button in the msgbox the next panel opens but that is not suppose to happen ... if there's an empty control after clicking ok on the msgbox the field has to be filled in before the next panel is...

thanx vis ;) I'll try it like that ...

I have a couple textboxes and comboboxes in my form and a button to go to another panel in the form ( with the data entered )... and want to check if al my controls are filled in ... ( both the textbox and the combobox ) so if i click the button all the controls have to be filled in before...

Kulrom appreciate your help ... I'll check the ascii table for capital letters Thanx ;)

:eek: how can i make it possible to first fill in some letters f.e. 4 and after that f.e. 4 numbers ... :o

Hi, Thanx for the help, i tried the suggestion of New-B and it works for me :) Thanx all of U :D

I have a couple of textboxes an a couple of comboboxes ... what i want to do is ... i want to check wether the textboxes are filled in correct ( ssome are only text and some are only numbers ) how can i check that there are no numbers in the text and in the other case no letters in the text...

i had seen the property:rolleyes: , but that wasn't the answer ...:mad: and if i was good enough :cool: i wouldn't ask you would i ...:eek: and Craig thanks for the answer that was what i was looking for

I have several panels ( 3 ) on a form . Let me put it like this .. I got Form 'a' .. when i click on a button on form 'a' ... form 'b' ( with 3 panels ) panel 1 has to show up ... :confused:

can't nobody help me ... ?

simple calculator Well it should not be so difficult ... U can create 3 textboxes, 2 for the input and 1 for the output... ( in designmode) create a function which reads from the input textboxes and calculates ( add-on or else ) the two inputs.... And then displays the answer via the 3rd...

U can make a function in order to make your code object oriented ... in a sub you will create the code for your application and dim the variables, buttons etc... and in the function there will be what the buttons will do ... so like the functionality ... in this manner u should also be...