Search results

Thanks @arnelgp I see my blunder(s) now, thanks, I hope as well this code helps someone else, is simple, yet it works, I'll disclose all the authors in the code so they can be properly identified. Maurice.

Hello Gurus: Thru trial and error, and with lots of help from many of you here and some other places in the Access world, I was able to proudly create my own message box. While I thought it was working fine, I found out that was actually failing with a strange behavior I was not aware, so I...

Thanks it worked, I just made the adjustments as suggested and added order by referdate at the end so that it is sorted as well, it works pretty well, exactly as I imagined. Thank you @arnelgp I have attached the test Database, just in case anyone wants to see the final result, and might even...

Thanks @LarryE I tried already that and it didn't work, I'm going to try the solution from @arnelgp and will go from there.

Thanks @arnelgp , I am going to try your solution now.

Thanks, I'm going to try, @arnelgp 's solution and will go from there.

Hello Gurus.. After a few minutes I decided to post this here, since the issue will be handled at the end by VBA.. Issue: I am working in an application, where a specific number of records will be displayed in the form footer of my Main Menu on a Sub-Form: This SubForm is created Using 2...

Colin, could there be another way? Sorry my knowledge is very short as you can imagine, but I've seen code were you can check [for example] if a form is open or not, or maybe something like where regardless of the name of the project just detecting the project name, we can perform the same...

Thanks Colins, That code has saved me a lot of hours trying the " DoCmd.MoveSize Left, Top " Is simply genious.. By the way I also figure out that The name of the project has to match as well within: File / Options / Current Data Base / Application Title if that is not the same value in...

Hello Gurus.. I just came across a weird issue, and I don't know if anyone has a logical explanation for this weird behavior. I have been working with Colin's @isladogs "Centre Form On Screen" which is a great article, until I was just checking how things moved around the module, just as...

Thank you as well, yes most message boxes do not require painful and complicated code, yes I've seen some very wonderful things you can do, but most of us, simply want to display a Message Box that displays a message and a warning or exclamation about something, all other examples I've seen are...

Thanks for the Demo, I just had to change the order and it works, yep simple and efficient, I will get it as a teaching experience, now part of the code I create was because the "WarnMessg" label could have dual purpose, hence is Optional, the idea in my head is the Warning Label, is standard...

Hello Gurus. I am doing a simple test with OpenArgs [Learning] I am creating a very simple Customized MessageBox, something so simple without any extreme or complicated code. since it will be a message box, must be MODAL by default so that the user is forced to click YES or NO. So I found out...

Thank you so much Edgar, I appreciate your kind help, @Eugene-LS was able to provide me with code that solved my issues and went a bit beyond what I needed, check his code on post #7. Have a great day.

Eugene a million thanks, I am thinking with a bit of modification to make it a function so I can use it in a few other places that now have more possibilities thanks to your code, but for now I need to continue. Thank you so much, works like a charm.

Sorry but this did not work

Did not work, access is looking within the current form and not in the hidden form, gave me the same error as I post in #4

I think there is something missing, I got the following error: this I believe is telling me that the object in this case the name of the sub form is not found, and is because is still looking in the current form not in the hide form, I don't know how to tell access that needs to look in the...

I have a form [F1], that contains a sub form [FSF1], the sub form has the results from a query [QueryView], will usually contain about 50 to 100 records. [FSF1] is placed on the Sub Form as CONT Form. Problem: To make that [F1] work faster when I open another form [F2] I HIDE the form [F1] When...

I will Surely.. I some long weekend coming, I am going to dig in like there is no tomorrow. Thank you so much Colin, I have learned so much, from your examples and from this forum, that I was thinking in not going to classes anymore, I have learned more in your posts and website, than in 4...