Search results

I got a runtime error 2185 you can't reference a property or method for a control unless the control has the focus. upon debug: goes straight to this line If CDate(AuthDateEntered.Text) < CDate(ReferDate.Text) Then But I was able to solve the issue, user @xavier.batlle gave me a tip, set the...

SIR.. Hats Off to you IT WORKED.. Just the way I wanted it, this is pure genius, thank you so much, I set the focus first to ReferDate, followed with the ADE, it works.. PROBLEM SOLVED.. :) :)

SIR.. Hats Off to you IT WORKED.. Just the way I wanted it, this is pure genius, thank you so much, I set the focus first to ReferDate, followed with the ADE, it works.. PROBLEM SOLVED.. :) :)

I just did, but using the lost focus, which is what I need. I have to force the user to update that even before they continue, the code works, but at the very last second once the code do the END SUB the pointer moves to the next field.

I found some of those suggestions on other threads about a similar issue to mine in this forums.

Thanks I had already tested before the code as you kindly proposed, the problem is that the code is executed once either you try to close the form or move to a different record, then yes it works. My issue is that I have to FORCE the user to correct the date before they continue, I have some...

Sorry I've tried making the file to barebones and still got the file is too large error, [Even zipped] I don't want to put a link to the file, since I got into troubles in the forum last time. I'm out of Ideas, I know many of you will simply find my error in just 10 seconds, I honestly envy all...

I didn't try the form, I've been always thinking that I need to trap the property itself since I thought the form will do something else, let me try this first and see if it works, I will create a copy to try.. Complete Ignore I comment out the whole block of my original code and left yours...

Did you have the event property contain [Event Procedure]? I do really hope yes.. Are you able to post a sample db? No, the forum sort of block me even with a DB containing only the bare table I use and the form, seems like even zipping the file is way too big, and I fully understand the...

Already did, if you see the code I sent I did already, it was worst, the code never executed it just went right by.. 'Private Sub AuthDateEntered_BeforeUpdate(Cancel As Integer) hence the reason I sent the code, I have no idea what to do, as well @tvanstiphout check the code, that was my first...

Hello ALL I have gone through several threads about this issue, and still I can't get it right.. I have a form that requires if the user enter today's date or any other date in ReferDate then the next field "AuthDateEntered" must be > to ReferDate and move to a field XXXX I tried this...

I have finalized the form and I want to thank: @Pat Hartman @gemma-the-husky @Gasman @GPGeorge and very special mention to @mike60smart whom gave me the final touch to my success in the form, if anyone is interested I am posting the link to this specific part of the Database already finalized...

Boom ... I learned something new again.. Thank you so much.. Maurice.

If you don't mind a last question... I would like to do the following: After the user clicks on the save button, the last line to move the focus to a control on SF2, I have been experimenting with the following code: Me.Parent.SF2.Form.FieldName1.SetFocus but for some reason, I have followed...

You have a great treasure in your website, I am sure I am going to use soon one of your example codes.

You are right !! I converted the button from Macro to VBA, then added the extra code I needed for my buttons to work the way I wanted them to work, I did not see that those likes are not even going to be executed since I am no longer working with a macro. I already got rid of them. Thanks for...

YES my friend, you are 100% absolutely right, weird part is that in the first part of the code Enable=false it worked, so a mystery there, once I changed it to Enabled ... poof ... worked like a charm, no problems whatsoever. I also learned a better way to code by using " Me.Parent" instead...

IT WORKED!!! and I found my error as well thanks to you and @pbaldy is ENABLED not enable :):):) thanks for your kind help. I was also wondering about the me.dirty code just was not sure, now I am. Thanks a million.

Hello Gurus: I have the following form, that contains 2 sub forms [CONTINUOUS FORMS BOTH], When MainForm is opened SF1 is opened with AllowAdditions = False and SF2 with AllowAdditions = True when the user clicks the ADD button I perform the following code: Me.AllowAdditions = True...

Believe it or not, very soon I will be able to post the final solution, not the way I thought but close enough, I am on vacation now, but as soon as I am back I will do it al let everyone know. I am very thankful to everyone, for their suggestions, and I understand your thoughts, but unless you...