Search results

Holly Jesus Pat, this is GENIUS, First of all, I had 1000% Respect for your knowledge and patience with my donkey[ness] ;) but now is up to infinity, I am actually learning from the very very very beginning access, of course I am doubling down with VBA because of timing issues, but this has...

Thanks Doc, it was just simply curiosity, no code involved, no weird things in my program, but just for the sake of argument.. I am working on a bounded form, some data will be pre-filled for the end user, all is ok with the form, no issues, is just that when I am testing for one thing or...

What event starts when you right click on a form to choose design view, nothing important, just out of curiosity. I've tried on close and on unload events but I cannot check that, is nothing of life and death, nothing and End User will ever do or use. Is simply the curiosity of someone is...

Thanks for your understanding, Pat, sometimes we forgot that we start somewhere, and we all have stupid questions, I am not afraid to ask them, stupid questions got Edison to invent the light bulb, stupid questions got him start the telegraph, so I understand when someone gets a bit disturb with...

I'll check the example, thanks.

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