Search results

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

arnelgp, I didn't work in the afterupdate event of the textbox. My LoginForm stays open but hidden after input password. For various reasons. In many cases I refer to certain data in that form... one of them is DienstID... So I put the code in the FormLogin load event and the other part in...

arnelgp, The code in post #13 is in all forms (for users) in the on open event to enable or disable the shortcutmenu in the forms. Now I want to use the print_menu & print_menu2 in the repports. I can't believe that's the intention to put the code in post #24 in the on open event of all forms...

Arnelgp, To enable or disable the shortcutmenu for all forms the code is placed in every on open event of the form. And only the forms who are available for users. Not in the Admin forms. So where do I place the code : Select Case [Forms]![FormLogin].[txtDienstID] Case 1, 2, 5, 8...

arnelgp, That's where I'm a little confused, Do I put in the Loginform or in a module?:confused:

arnelgp, So the first line of code (Tempvars.Add……etc.) I put in in my LoginForm? Because I don't know what you mean with public variable… (sorry):confused: Thanks again Greetz Pascal :cool: