Search results

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

Hello GURUS: I am building sort of a complex query [for me "newbie"] and this is what I need to accomplish: The query should give me all the records while they are not marked CANCELED, the caveat is that 1 of the tables contains Notes for that record, they can be 1, 2 or 3 notes, for the...

Holly Jesus Pat, this is GENIUS, First of all, I had 1000% Respect for your knowledge and patience with my donkey[ness] ;) but now is up to infinity, I am actually learning from the very very very beginning access, of course I am doubling down with VBA because of timing issues, but this has...

Thanks Doc, it was just simply curiosity, no code involved, no weird things in my program, but just for the sake of argument.. I am working on a bounded form, some data will be pre-filled for the end user, all is ok with the form, no issues, is just that when I am testing for one thing or...

What event starts when you right click on a form to choose design view, nothing important, just out of curiosity. I've tried on close and on unload events but I cannot check that, is nothing of life and death, nothing and End User will ever do or use. Is simply the curiosity of someone is...

Thanks for your understanding, Pat, sometimes we forgot that we start somewhere, and we all have stupid questions, I am not afraid to ask them, stupid questions got Edison to invent the light bulb, stupid questions got him start the telegraph, so I understand when someone gets a bit disturb with...

I'll check the example, thanks.