Search results

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

Hey Pat. Probably since No One has the FULL spectrum of this database, everyone is going THE CORRECT WAY of doing things IF THIS WAS A DIFFERENT TYPE OF DATABASE AND REQUIEREMENT. This is NOT what everyone thinks it is.. Hence I posted the name of the Database, and the purpose of such...

Yes George, but like I said because of the aplication this particular segment MUST be like that. Literally the Authorizations person does not care if the doctor can perform various practices, if that is the case Dr. Peter Hong, MD will be in THIS PARTICULAR SEGMENT. Head and Neck Surgery - Dr...

Nup.. not for this particular, I guess there is a serious confusion on what the database will accomplish, I guess everyone is more fixed on the wrong place.. The final IDEA: 1 Speciality MUST BE UNIQUE NO MATTER WHAT.. 2 Specialist DOCTOR MUST be ASSIGNED to a particular SPECIALTY NO MATTER...

Sorry that was just an BAD example ex: Optometry: -- Dr Pete -- Dr Rick -- Dr Scott -- Dr Mag Gastroenterology: -- Dr Gas -- Dr Oil -- Dr Can -- Dr Key -- Dr Wrench Pulmonology: -- Dr Smokey -- Dr Marlboro -- Dr Kill

no dear friend; maybe I am not being clear, and my apologies if that is the case. For this particular database only and for this particular need, I must save the record the way it is. your point is well taken, but in my database for the need of an authorization this must be done. I cannot...

I see your point, but for this particular case is NOT a many to many. is always a 1 to many 1 specialty to MANY doctors, not the other way around. like I said for THIS particular only. My Database is called Authorizations and has nothing to do with doctor's skills, maybe that's where all the...

The main table will keep records of what we call authorizations.. The reason why it has to be the way is designed: Each authorization has many parts 1 of them is What Specialty do we send the patient to: [Ophtalmology, Gynecology, Cardiology, etc] once we know that then we decide which doctor...

Pat they are working as a parent Child if you go back to my initial post, you'll see how the picture #2 shows the link on the Specialists sub form, It works UP to the point where a NEW Specialty has to be entered then if for any reason the EU moves the mouse to the specialists I do not check...

That's exactly what is happening right now.... [Answering @ebs17 as well] This is a MAINTENANCE routine for the EU (End User) So here the EU has to input the new Specialty and then what Doctors do attend that specialty [One to Many] One Specialty ---->> Many Doctors not the other way around...