Search results

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

Is not a VBS code statement it is an EXAMPLE of a LOGIC statement , sorry for the confusion.

Pat SORRY.. I hope you don't mind me asking.. I need to check that the user does not leave the fields empty so I am using " If Null(FieldName) then MsgBox " FieldName X Cannot be empty ", etc. Is there a better technique to check the fields so I don't have to write so many if then ???? thanks...

Thank you Pat, I had a fun time changing everything and figuring out how to validate the data, but a few googles and youtube help me out, I know is not perfect or the most awesome coding but it works. thanks for the advice.

Yes I did, problem solved, and I learned a new thing.

WORKED PERFECTLY.. Thanks I just learn something NEW thanks to you.

The Name was a stupid finger error, no other one has a space, but thanks for pointing out that.

Hello all; I have gone thru hours a few articles in AccessWorld and a few youtube videos, plus countless google pages trying to find out why a SIMPLE task as hiding a subform just simply does not work for me. THIS IS THE FIRST TIME I AM TRYING THIS SO PLEASE BE PATIENT. my idea is that...

Thanks a LOT @The_Doc_Man this was believe or not my very FIRST function EVER, but I have learned very important lessons, your advise is extremely appreciated. My learning is a process while I am working, I am learning, I am so grateful for your kind advise.

Thank you, I am actually learning and working, it is a process of failures and corrections, Thanks for the advice I just learn a new lesson, actually 2 I declare all the variables (and will change the rest of the application code as well)