Search results

I am having a problem with this query, it is giving me the wrong results. INSERT INTO tmp_TimeInPhase (PRON, [TimeStamp], [Current Proc Point], ProcPointStartDate, EndDate, TimeInProc, [Updated By], PALT) SELECT p.PRON, a.TimeStamp, c.[Current Proc Point]...

I’ve been asked — more accurately, tasked — to provide a government employee with access to the data in the app I maintain. I considered opening the back end in read-only mode, but that won’t work because the primary need is to run queries for analysis. He wants to crunch numbers without...

Reading this thread: Solved - Undo Updates on a Subform | Access World Forums https://share.google/vcxiK5qDD0uyPyFVs The solution provided involving temp tables seemed a little unwieldy. I am wondering if a Class Module using Dictionaries, Collections or Arrays would be cleaner and/or more...

I opened up a query in SQL view and here is what I saw: SELECT tbl_Participants.RiderID, [FirstName] & " " & (" """ + [NickName] + """") AS Member, tbl_Participants.LastName, tbl_Participants.Email, tbl_Participants.ContactNumber, tbl_Participants.MotorcycleOwner FROM...

Good morning folks, I recently was given a db to look into. Aside from a few other issues, there are about 50 tables and ALL of the short text fields are sized at 255. I wrote a quick sub that looped through the TableDefs and determined the max length of the data in each field. I then...

My wife is using PowerPoint to make tutorials for her place of employment. She is using a Jabra headset with a "boom" mic, and for the most part, the sound quality is adequate, but there are times where there is an annoying fluctuation in the sound level. Has anyone experienced this and if so...

Disclaimer, I had to use AI to generate the code I got work. But I thought it would make a good thread anyway. I have a 5 digit code that I use a lot in my line of work. It's called a Commercial And Government Entity (CAGE) code and the Master file on the DoD website holds over 3 million...

I was putzin' with ChatGPT and asked her (don't judge me!) what a word (COLSETVERSION) in a connection string meant. She replied with ease so I challenged her to another word in VBA we all use and asked her why MS settled on this word in particular: "Me." Her answer: That’s an excellent and...

I can across an issue yesterday where to PM wanted to measure the amount a time a Purchase Request Order Number (PRON) spent in the Process Point (Proc Point) of its life span. After thinking on it and playing around, I remembered a similar issue I had and asked a question on this thread. Using...

To those members who celebrate our holiday and to those who just want to take a second to appreciate the good in our lives, Happy Thanksgiving!

Good morning everyone! My issue should be simple, most of my users and I have a dual monitor set up. I have a main form and one of the command buttons opens up a pop up form. Because the main window can be moved as well as the pop-up, I want to ensure that the pop-up opens on the same monitor...

Conversation while taking the girls to school The cast: Chloe aka Papoose (6yrs old), Megan aka Duckie (3 yrs old). And yours truly, 59 and getting older by the day. Papoose: "Pops, Duckie stuck her tongue out at me!" Me: "Oh did she?" Papoose: "Yes!" After a few moments of silence Papoose...

Good morning folks! Playing around this morning, I did a quick db with a password. I can open it from file explorer with no issues - a quick prompt for the password and I'm in. However, when I try to do it from the command prompt: "C:\Program Files\Microsoft Office\root\Office16\MSAccess.exe"...

Daniel Pinault is working on some new ideas. Worth checking out...

A topic most men tend to avoid...wait, wrong topic! Anyways, not a bad read. If you have about 20min to spare to read both articles, grab a cup of coffee and have a read... https://nolongerset.com/premature-declaration-redux/

https://www.devhut.net/new-sql-editor-released/

I tried to find this on AWF but was unable to find it, apologies if I am covering ground already covered. I learned yesterday that Trim in Excel works differently in Excel than Access: Trim in Excel removes all spaces but one from a given string: Trim("1234 567 89") returns "1234...

I have been able to see table information from a site that requires a password. I can inspect the table and see the columns and the data...but no matter what I try, I cannot extract the data. Several methods I have found using Dr. Google have failed and about 4 hours of ChatGPT have gotten me a...

Good morning AWF! This is from my granddaughter's school's FaceBook page: If you have some time to spare (and the means to pay the postage!), would you consider participating and earn our undying gratitude? Who can say no to this face?

Good morning all, My home network is wired; I use MOCA "bricks" to bring the service from my cable provider then connect my devices with an ethernet switch. I want to be able to make certain files available to all the devices that are wired in. Can an external HD be plugged into the switch and...