Search results

I'll work on yours and @Pat Hartman ideas, I do understand the prompt will be annoying, I just wish I knew 1/3 of 1/3 of what you guys know. I'll work on that on monday in the office. Thank you all.

100% Absolutely CORRECT, but you do not know my End Users, I've seen things that will scare the last hair in your head. But I found a solution and it works pretty good, with some minor changes, good old Richard Rost provide me another fresh idea: How To Stop Auto Record

thanks for the tip, honestly I am lost is probably above my pay grade and the knowledge I have, I was hoping for a most simplistic solution.

Hey guys I have a form that contains 1 sub-form [sub-form adds just some notes I add to each order using a separate table that contains 3 fields Key/Date/Note] the key as you can figure is my FK on my main table. Problem is that everytime I click on the sub-form to add note or notes, all the...

Thanks for your suggestion, I tried the code AS IS NO error at compile problem is that Private Sub AuthDateEntered_BeforeUpdate(Cancel As Integer) is not working and unless I go to different record then it works, which defies the whole thing. leaving the code with the Lost Focus works as I...

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.