Search results

My mistake… :D This is the working code : DoCmd.OpenReport "AlleDossiers", acViewPreview, , "NN =" & Me.NN & " And DatumTA =#" & Format(CDate([DatumTA]), "mm/dd/yyyy") & "#" There is no reference to the combobox anymore with this code … correct? Greetz Pascal

#arnelgp and #isladogs, The combination of your suggestions did it... Finally :rolleyes: This is my final working code : DoCmd.OpenReport "AlleDossiers", acViewPreview, , "NN =" & Me.NN & " And DatumTA =#" & Format(CDate([DatumTA]), "mm/dd/yyyy") & "#" '=#" & Me.cboDatumTA.Column(0) & "#"...

hi, Thanks for reply... :) #arnelgp : your code didn't work… :o #isladogs : I followed your recommendations, renamed my fields and removed the spaces. I left NN like it was because I had no problem there. My date is in Column 0 so de column number is not needed (I think) this is my code ...

Hi specialists, I want to open a repport with 2 conditions. part of the code : DoCmd.OpenReport "Alle Dossiers", acViewPreview, , "[NN] =" & NN And "[Datum TA] =#" & [Datum TA] & "#" Only with the "NN" condition, no problem. [Datum TA] is a combobox to filter my form based on the date in...

Hi everybody, I don't know what happend with post #12. I clicked submit reply and then something strange happend and brought me back to the loginform. Back to the thread I couldn't find my reply so I started again… :confused: After Pat Hartman's reply I started thinking and came up with the...

arnelgp, FormPP doesn't have to open after Login. After Login a Switchboard Items Form opens. FormPP is just one of the forms in my DB. Also The Login & Password Form is not connected to a table, so the input is not saved. I can not put your solution in the Login Form If that's what you mean...

arnelgp, Thanks for reply. The form doesn't have to open after Login. After Login, the Switboard forms open. FormPP is just one of many… I think your solution is not an option here... :o forgive me if I'm wrong... isladogs, Also thanks for reply. I got this one so far : Function...

arnelgp, Thanks for your reply. The form can be used after a login. it's connected on a table 'TabelPP'. It's one of the many forms in my db and opens by a switchboard. Greetz Pascal

Hi everybody, thank you so much for your reply... Tera's code doesn't work :( pbaldy : the way you open the form also doesn't work :( These codes works seperetly perfect: Shows all records : Private Sub Form_load(Cancel As Integer) DoCmd.OpenForm "FormPP", acNormal DoCmd.GoToRecord , ...

isladogs, Thanks for your reply. I have some basic in vba and I tried this but it didn't work :confused: Private Sub Form_open() If Me.OpenArgs() = "Admin" Then DoCmd.OpenForm "FormPP", acNormal Else DoCmd.OpenForm "FormPP", , , "Tarifeerder = GetWinUser()" DoCmd.GoToRecord , , acNewRec...

Good evening (for me it is here in Belgium) developers :) I would like to open a form in 2 ways : as a User or as a Admin. I have a table with all the users where the Usertype field has a possible selection User or Admin. (from another table) When the Usertype is "User" the form should go...