Search results

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

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

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

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.

Reconsidering..

Now Share that Line of code :ROFLMAO: :ROFLMAO: :ROFLMAO: :ROFLMAO:

So Simple yet so powerful...

And this is why I Love this forums, there is always someone with a different approach, a different solution, this is great.. Thanks

in my case doesn't matter, all i am doing is for forms that are either a menu, or forms that contain no new data, so I am safe.

Absolut true.. Sorry I forgot the original code was a SUB, I am actually not using it as a SUB, hence my code differed, but yes, my mistake I stand corrected, I am only using this part: If Application.SysCmd(acSysCmdGetObjectState, acForm, "NameOfForm") = acObjStateOpen Then MsgBox "I am...

Just a little correction, to be more specific: Sub Button1_Click(nameOfForm As String) If Application.SysCmd(acSysCmdGetObjectState, acForm, "NameOfForm") = acObjStateOpen Then MsgBox "I am open" End If End Sub Should be "NameOfForm" in quotes.

Forms("FormName").ShortcutMenu = true ' Or False' I use a tempvar to handle the boolean so when your first form opens [in my case frmSplash on the Load event: I set that form to: Forms("Splash").ShortcutMenu = False Then I create a Tempvar called SCM Now in any form depending on the user...

Pat, thank you for your time, I hope that God can re-pay you back hundredfold.

WOW, this is priceless info Pat.. I have no words to thank you for being so kind and above all PATIENT 🤣 [Pun intended] with me, I have much to learn about everything, and getting rid of OLD programming style [Cobol, dBase, FoxBase, etc.] is really hard, specially after 30 years of not doing...

Pat... I'm an I.D.I.O.T. I found out my issue, I think way more than I should, I finally understood what is it that you explain plain and simple to me, ME on the other side complicated things by NOT understanding what it was presented to me in the code, by adding the PNoteID to the SQL, I was...

There is no data, the DB is under construction, so all data is fake. I'll zip and see how it goes.

Good Morning/afternoon/evening @Pat Hartman , Is there any place I can see an example of this, I have to be honest, I have no idea how to accomplish that, my knowledge does not go that far, I am lost. I rather be a dumb once and honestly ask, than trying to appear to know what I don't. Maurice.

Hello Pat, I was following instructions from: This YouTube page it works to create the sub, but I need to incorporate the PNoteID, so that when I add the subquery to the query I have [Minus the notes table], I have a FK and a PK to relate. when I add the PnoteID to the subquery I got the error...

Thanks Pat, I have never done anything like you suggest so I am going to investigate first to make sure I do understand.

Thanks Pat, sorry, the issue is that since the notes may have more than 1 note in one day, the record ID will be always different [which is correct and should be like that, is the record KEY], the date is given on the same day will be always the same date, unless the note is recorded in a...