Recent content by M-RaH

  1. M

    DataGrid

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

    INSERT,SELECT,INSERT into DB

    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('"...
  3. M

    INSERT,SELECT,INSERT into DB

    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 :)
  4. M

    INSERT,SELECT,INSERT into DB

    :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 & "','"...
  5. M

    Loop through form

    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)...
  6. M

    Loop through form

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

    Loop through form

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

    required field

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

    Loop through form

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

    Loop through form

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

    Loop through form

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

    required field

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

    required field

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

    required field

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

    required field

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