Search results

  1. 1

    cbo field with ID from 1ste cbo

    ??? In my options is the setup competibel with 2007-2013. When I wan't to save it to 2002-2003 he say's that some formules not competible??
  2. 1

    cbo field with ID from 1ste cbo

    It is the frm [frmLeerling] http://www.allezkidz.nl/DPadmin_test.rar
  3. 1

    cbo field with ID from 1ste cbo

    I have found the problem, But how to cancel it. It's not like i sayd above. Because when i close my frm [frmLeerling] and open The first choice i make in the first combo is OK. SUPER. But when I want to resider my choise and choose a knew seoson, the second combo is'nt getting teh new information.
  4. 1

    cbo field with ID from 1ste cbo

    Hello Cronk, Just like I type above.. I all ready discovered this mistake.. because I was reading the hole thing twice again. And it seams to be working almost .. the fist combo is perfect the second combo is the following wrong To test the thing ones againg I made a new season in...
  5. 1

    cbo field with ID from 1ste cbo

    Them, I think the 30gr. celcius here is boiling my brains. I have read the hole thing again, and i found out that I must put the code SELECT clubCode FROM tblClubs WHERE [SeizoenID]=Forms!frmLeerling![cboSeizoen_Inschrijven] ORDER BY ClubCode; in the rowsource of the second combo. So away...
  6. 1

    cbo field with ID from 1ste cbo

    The first combo is OK now... I can switch between them. But the second combo is empty and when I'am in the form and I go to the next combo where the clubs must apere the VBA displays the red line and the word ClubCode is Blue... When I rightclick on it and go to the proporties. I can't see...
  7. 1

    cbo field with ID from 1ste cbo

    Here is a Printsreen, When I put in the Code now it's inmediatly RED??? http://www.allezkidz.nl/cbo_Printscreen_And_Code.jpg The Code Option Compare Database Const strVelden = "LLID; LLNummer; Voornaam; Achternaam; Geboortedatum; Woonplaats; Email" Private Sub...
  8. 1

    cbo field with ID from 1ste cbo

    same result?????
  9. 1

    cbo field with ID from 1ste cbo

    When I select now a season in the first combo he says can't find object ME. In the 2nd combo the first season displays the right clubs the second season is the same as the first. That's not OK??
  10. 1

    cbo field with ID from 1ste cbo

    Hello Cronk, I'am lost.. Sorry but someting is wrong with my head, I have made some mistakes. Damn.... SELECT ClubCode FROM tblClubs WHERE [SeizoenID]=Forms!frmLeerling![cboSeizoen_inschrijven] ORDER BY ClubCode I have made some changes because I give you the wrong names... This is how...
  11. 1

    cbo field with ID from 1ste cbo

    I have a cbo that must display "all" the clubs from the tabel [tblClubs] that are availeble in the selectect season in the first cbo. The work flow is; choose a season (this is in [cboSeizoen_inschrijven]) That have the value of all my seasons. Than in the next cbo [cboClubs_Inschrijven] we...
  12. 1

    on click set vallue to field

    I wan't the fuction only for the choosed record, not the hole database. The frm is a student contact form, wirh a picture, the standard format foto is my logo. The mening of the trashbin button is set the current picture on the standaard picture @Mihail, CAn you help me with a solution??
  13. 1

    on click set vallue to field

    Hello people, I need a code to clean mij txt field for the picture path. So a button on my frm must write the vallue \\BEGINNERSGELUK\dpsAdmin\Foto\0.jpg when I click on it. the field he need to write it in is in [tblLeerling] en the field name is [Fotopad] I hope someone understand my...
  14. 1

    unlock diffrent fields on my form, when check Couple is on

    Hello Dale, I'am trying to make somting of it, but i don't come far.. Can you (or someone else) help me a little bit further??
  15. 1

    autofill domain name

    Oké, I was ready I thought, but in mij form I have two email fields the other one is for the Partner. Must I now paste the hole code again in the VBA with the field names from the other field?? The Above is solved!! Amn I Like Access 2013...:D
  16. 1

    autofill domain name

    Thanks for the tip, With some help of Google and a dutch template i have made this code for the cbo and it works fine... Private Sub cboEmailDomein_NotInList(NewData As String, Response As Integer) If MsgBox("Deze soort bestaat niet." & vbLf & vbLf & "Toevoegen?", vbYesNo, "Onbekend") =...
  17. 1

    unlock diffrent fields on my form, when check Couple is on

    Hello people, On mij registration form I have the option to fill in the name and day of birth, email and GSM number of the partner off the main contact. But to keep the form nice and clear, I only wan't to make the fields acceseble when the checkbox from [couple] is checkt OK. I hope some...
  18. 1

    autofill domain name

    Hy There, It work's olmost fine. But when I put in a new domain, that isn't in the tabel yet, how can I make shure That he will save it in the list.
  19. 1

    autofill domain name

    Helle people, A new dutch man, with terribel englisch.... I have a form for my customers where i also fill in the email adresses, know i don't wan't to fill in the hole email adres each time. I have seen a acces database before that gives a list when you typed the @ sign in the email...
Back
Top Bottom