Recent content by scallebe

#arnelgp, I can imagine that… :o No problem, I am grateful for what you have done already. I added the "Exit sub" and it works fine. I just wanted to know if my solution is the right way. Please let me know when you have the time... Thanks again Greetz Pascal :cool:

Good morning arnelgp, Thanks for reply :) I figgered out the changes you did… :p One thing didn't work yet : When the "msgBox" apears (to save the record or not), I click to No and the "WarningForm" opens again (and that should not happen) so I added the following code in this part (your...

#arnelgp, Thanks for reply. It's not working yet like it supose to… :( I'm gonna do my best to explane… :rolleyes: What happens in the orignal version : I fill in the different fields in the "Verlofaanvraag" Form. After input I click NEXT. the "msgBox" apears to save the record or not...

#JHB, I still have the same error, even with the database I posted. Even after Compact & repair... See photo… #arnelgp, Your solution is working… Can you please tell me what you changed? If I compere your code with the original I send as example, I can not see immediately the difference …...

#JHB, #arnelgp Thanks for reply. #arnelgp : I have the same result with your solution. I mannaged to reduce my DB with the form in question. Fill in the green fields, click next and click then "NO". The message will apear. I hope the example works… :o Thanks a lot Greetz Pascal :cool:

JHB, Thanks. I already try that. I'm having the same message and my Form doesn't clear. :(

JHB, Thanks for reply But I don't know what you mean…:(

Good morning Specialists, After input my form fields I click a button to create a mail. Works fine. Before the "email code" starts, the user has the possibility to save the record and continue or not and cancel. Private Sub Form_BeforeUpdate(Cancel As Integer) Dim strMsg As String Dim...

ok, sorry about that...:( The 2 formula's of Isladogs worked fine... Working with a query was also a good method #arnelgp And AllanBrown's solutions : Works fine too… #CJ LONDON Thanks a lot... Greetz Pascal :cool:

Thank you all for reply. I tested all your solutions…:):) #Pat Hartman, That was something I didn't know, It explanes a lot in my other DB's … :rolleyes: See you all next time. Greetz Pascal :cool:

Good morning everybody, I have in my report some calculated fields and I want to calculate the sum of these fields in my pagefooter. From the calulated fields I need the integer part of the result. The formule for I use is e.g. Fieldname : "Fifty" =Int([payOut]/50) and it works fine. e.g...

#CJ LONDON, #isladogs Thanks for reply, Once my DB is ready, I'm gonna use a longer password. Now I use a short one because it's easyer as long as I'm in the design mode of the DB. I used both advices…. Here's the final code : Private Sub btSeePW_Click() If Me.btSeePW.Caption = "Show...

Good morning specialists, I find a code on the web to show or hide the password in my Loginform. Private Sub lbl_Click() If Me.lbl.Caption = "Show Password" Then Me.UserPassword.InputMask = True Me.lbl.Caption = "Hide Password" UserPassword.SetFocus Else Me.UserPassword.InputMask = "Password"...

arnelgp, Thanks… I am a little jealous of what you all realize as if it is nothing … I also want to delve more into VBA, but time is not on my side at the moment... Thanks again :):) Greetz Pascal :cool:

Good afternoon arnelgp, In #6 you set a code to clean-up my PDF-folder. Works perfect:):) I have a second pdf folder to clean-up the same way... in following path : CurrentProject.Path & "\Brieven Retour - Lettres retour - PDF" How can I add the second folder into the code and do the...