Recent content by mloucel

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)

Hello ALL, I have a SUB, when I close a form that checks if there are any fields changed, if no field is changed then UNDO and close the form, if not save the fields, but for a reason I cannot comprehend when I finish checking the fields and my variable is set to "TRUE", comes back to my SUB and...

Amigo, Espanol no es bueno aca, pero cuando Access te da esos nombres como "Expr0000" es porque no definiste un nombre tu, Edgar te lo explico: Data1: Field1 & " " & Field 2 Si tu solo dejas Field1 & " " & Field 2 Access va a crear el nombre "Expr0000" por eso no lo puedes borrar, no lo vews...

I am sure this answer is NOT specially perfect for you but IT MAY HELP MANY OTHERS.. There is a way to do it, but is NOT 100% cloud like you imagine, but is close enough, check this website, Richard Rost is I am sure very known around here.. Access Database Cloud [Easily Share Your Microsoft...