Search results

Thanks I was wondering, but I had so many failures and finally that one worked..

This code works perfectly, but I tried to simplify and somehow I got lost.. I tried to simplify the code without the use of so many [ ] but I am getting lost The Commented Line: 'Me!PatientAdmitanceF!PatientNotesSF.Form!Pnote.SetFocus was my futile effort, is there a better way...

Yes you are right, hence the reason I added that I was able to do it in a different way, you know the old saying.. "There's more than 1 way to skin a cat... :ROFLMAO: " Pat I am more than grateful for your kindness and patience. Regards. Maurice.

Hey Pat. I was able to do it in a different way, I found out that Mr. Richard Rost, has a form and code he sells on his website that is very ingenious, hence the reason I cannot post the code here since he makes money out of it. In case someone is interested the only thing I can [And since you...

Like I said hats off to you sir. I appreciate your patience, I'm 60 trying to evolve from FoxBase [Yep that OLD] and in order to keep my Job I have to adapt to this new world, I left programming for about 20 to 25 years for a new adventure in the same field but as a IT Admin, now the company...

Pat you are ABSOLUTLY right, I never thought about that [NEWBIE]... Monday I will modify my form so that instead of trying to display a continuous form I have another code that displays on a text message, this way it will show the duplicate record at my will of text / color and size. Thank you...

Hello... The data in the DB is just makeup names and dates not one is real, all of them are pure inventions of my imagination for test purposes only, no confidential data whatsoever.

HA... GOTCHA [for me...] That was the reason of that particular subroutine and why I didn't use the proper name function of access, I had an issue and was breaking my head, someone send me that code and Problem Solved. So I will go back to the subroutine. Hey @Gasman , I am using a...

Done The SQL instruction did work, no problem, it actually game exactly the record found, display it without any issue. So that leaves the SubForm and I am guessing how is built or something.. I created the form using the Table as record source, then I just simply add the records I need to the...

Thanks for your suggestions, The CleanUp was actually a leftover from the OLD program I had for this sub routine, is clean now. I had the impression that the function vbProperCase didn't check names like "Paul Anthony" hence I found that alternative, but I tested a few times and seems like it...

MODERATORS PLEASE: I tried to attach my database but no matter how small, just the essentials, no data, Zipped and I still keep getting the same error message: " The Uploaded File Is Too Large " No zipped is: 14,336 kb Zipped is: 9,130kb Good [morning/afternoon/evening] wherever in the world...

I tried but I got a message saying: The uploaded file is too large. File is barely 9,436 Kb and zippped goes down a few KB but I got the same results.. So I imagine there is some sort of restriction ? Hence the reason I sent the link. I

@The_Doc_Man you hit the spot my great Guru...🤣

Sorry, I made a mistake, should have tested fully before making questions, I was simply doing the conversion to uppercase but never apply the conversion back I did " fnCapitalizeFirstLetter (PLastNameTxt) " instead of " PlastName.txt = fnCapitalizeFirstLetter (PLastNameTxt) " makes a world...

Hello Pat, sorry for the delay, the link to the file is there in my message to you, if want to see it in action.. my apologies for any confusion. Right here: Hey Pat, Here is the new Code [ See Link ] :

Hey Pat, Here is the new Code [ See Link ] : So I made the changes as suggested, thou for now I understand the code is a bit messy but I will clean it as soon as you review it if you do have time.. SO JUST IN CASE.. The idea is: - if the End User [EU] decides to create a new Patient, then 2...

Hello Pat. Thank you so much for your suggestions, I do understand a lot of what you said, but I am "a learning curve" in this world, my training was a few decades ago with 'Foxbase" [ oh yea ], and now due to my Job being "at risk" I decided to learn Access, to keep my actual job, I started...

Sorry @Gasman you are absolutly right.. Well here it is: I used toggle points to run my code, I saw that I execute "Me.NavigationButtons=True" right after all my initial code effectively canceling the "FALSE" So I moved that line of code to my procedure where I FORCE the user to use the SAVE...

Hello Gurus.. SORRY NEVER MIND I FOUND MY STUPID ERROR PLEASE IGNORE I have been working on a form that believe it or not the Navigation buttons are pretty much a match made in heaven for the form, BUT... there is a point on the execution of the code that I NEED the navigation buttons to...

DARN GENIOUS.. Thanks to you and @arnelgp he has helped me before, simply GENIOUS...