Search results

Welcome aboard!

Has anyone given thought to using a dialouge form with a standard/class module and passing the title and message?

Say more...

And...you would like someone like me who HATES big brother would avoid it. I guess the convenience outweighs the hazard. I have been assimilated...

In this article, @NoLongerSet explicitly answers your question: https://nolongerset.com/why-use-subs-at-all/

Here is an example of what I was talking about. I was bored and asked "Chatty" a non-specific question. It helped wrote a PS script a few months back whose primary purpose is a FE Updater. I kept adding features and in the process, shared a few things about the application; the Workload...

@MajP, what AI is that, ChataGPT? You(it) just answerd a question I have always had but didnt quite know how to ask...

An interesting read on Function behavior. It doesnt really "solve" the problem or answer you question, but you may learn something about functions you may or may not have known... Every Function in VBA Returns a Value https://share.google/docQnUy2ZI7Eo9o4q

I had the same experience until I started using the paid version. Its almost scary how tailored and familiar it has become...

Very impressive! It took me a second to understand what was going on (RowNumber) and then even longer to adapt it to my situation. Once I got it sorted, it works great and is significantly faster. I really like this method over my original process; more precise and not having to fuss with...

Hi Jacob, welcome aboard!

(y)

Here is some data, and the query to play with. You will have to explicitly set the TempVar, but I am sure you would have worked that out...

Same results as before...

It is no bother at all...and if you want a small mock-up to play with I can port it over from my work computer and upload it.

Figured this is easier to read. Query3 PRON TimeStamp Current Proc Point ProcPointStartDate EndDate TimeInProc Updated By PALT AX6F2452AX 12/12/2025 12:40:31 PM PRON Received Buyer 12/12/2025 12/13/2025 1 Christopher Butler Yes AX6F2452AX 12/12/2025 1:42:14 PM Planning...

Results are not quite what I am looking for. There can be no gaps in the timeline. Here is what your query produced: Query3 PRON TimeStamp Current Proc Point ProcPointStartDate EndDate TimeInProc Updated By PALT AX6F2452AX...

Noted, thanks again. And...if the query could be optimized further, please tell me. I'm glad I got it working, but I am not too proud of it to know that it could use some polishing

Funny you mention that! I was using a temp table to hold the data to populate a report. While I was working it out (about a year ago), I thought that would be the easiest way to go. At some point today, while I was mucking about, I realized I could just use the query as a select and base the...

Hi Paul, yeah...not sure what happened there. I had pasted it into Excel and the did a copy and paste. I didn't see the garbage until after I had posted.