Search results

  1. mloucel

    Solved Refresh a query thru VBA

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

    Solved Break Point Loop

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

    Solved Break Point Loop

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

    Solved Break Point Loop

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

    OpenArgs issue..

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

    OpenArgs issue..

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

    OpenArgs issue..

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

    Solved Sub Form Requery a Query from another form

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

    Solved Sub Form Requery a Query from another form

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

    Solved Sub Form Requery a Query from another form

    Sorry but this did not work
  11. mloucel

    Solved Sub Form Requery a Query from another form

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

    Solved Sub Form Requery a Query from another form

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

    Solved Sub Form Requery a Query from another form

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

    Solved Glitch??

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

    Solved Glitch??

    Thanks Colin, is there a way to program the "Allow Special Keys" in a button or 2 that as you did the other ones in your example in the Control Application Interface?? (Sorry my knowledge doesn't go that far, but I am learning A LOT with your examples and with @Pat Hartman 's as well.)
  16. mloucel

    Solved Glitch??

    I've been working with some wonderful code from @isladogs [Colin] about hiding the access application window, resizing and some other great stuff, but I have found a small little glitch, that suddenly simply broke my head. me, and I believe all of you, don't like users, playing around with our...
  17. mloucel

    Make Passwords Case Sensative - StrComp()

    Well yes, but, I am just learning step by step, and I have no idea on how to do that with access, I know in my network all passwords are hashed with SHA512 and using no less than 10 characters, (2 Minimum each) Upper, Lower, Number and Special Characters, those are my defaults in my network...
  18. mloucel

    Make Passwords Case Sensative - StrComp()

    That would be awesome, but my knowledge is WAYYYY too little to even try, I know about the ASCII code, but is for now, something that I can do in the future.
  19. mloucel

    Make Passwords Case Sensative - StrComp()

    Reconsidering..
  20. mloucel

    Make Passwords Case Sensative - StrComp()

    Now Share that Line of code :ROFLMAO: :ROFLMAO: :ROFLMAO: :ROFLMAO:
Back
Top Bottom