Search results

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.

I'll work on yours and @Pat Hartman ideas, I do understand the prompt will be annoying, I just wish I knew 1/3 of 1/3 of what you guys know. I'll work on that on monday in the office. Thank you all.

100% Absolutely CORRECT, but you do not know my End Users, I've seen things that will scare the last hair in your head. But I found a solution and it works pretty good, with some minor changes, good old Richard Rost provide me another fresh idea: How To Stop Auto Record

thanks for the tip, honestly I am lost is probably above my pay grade and the knowledge I have, I was hoping for a most simplistic solution.

Hey guys I have a form that contains 1 sub-form [sub-form adds just some notes I add to each order using a separate table that contains 3 fields Key/Date/Note] the key as you can figure is my FK on my main table. Problem is that everytime I click on the sub-form to add note or notes, all the...

Thanks for your suggestion, I tried the code AS IS NO error at compile problem is that Private Sub AuthDateEntered_BeforeUpdate(Cancel As Integer) is not working and unless I go to different record then it works, which defies the whole thing. leaving the code with the Lost Focus works as I...