Search results

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

This is a quote from Danny Lesandrini in one of his Database Journal articles that resonated with me when I read it back in 2015. Ever since members of this forum showed me how to debug.print properly and step-through the code, I waste a crazy amount of time watching the process run - even when...

While trying to find a way to change the properties of my db (specifically the ShowDocumentTabs property) with PowerShell, I asked ChatGPT and here was the first response: That did not work and generated RT error '3061' - too few parameters. I relied this to CPT, here was the response: This...

During my morning rounds, I came across this article by Mike Wolfe. I'm going back to truck driving...

Good day AWF! My lovely wife came to me with ugliest excel spreadsheet I have ever seen. Due to a number of factors, I cannot import it and even when I did manage to do so, the data is all over the place. For example, in one record, the info she was looking for is in Field(column) F7 and in the...

Today's entry: @Galaxiom, were you in Virginia by chance?

With all the BS going on in my own life - and the fact that I intentionally avoid the lamemain-stream media - it never occurred to me that maybe some of our Canadian members on AWF may have been adversely affected. Apologies to you for being short-sighted and selfish. And although my...

My work computer (VDI/Citrix environment) has started acting strange. Whenever I open either a new or existing query in design view, Edge opens up, to the site in the graphic below. I have tried to duplicate this on my personal computer (both using O365) and this does not happen. Not a big...

Stemming from this post, @Josef P. mentioned using Add-Ins to access multiple db's from a single main form. I myself find that VERY intriguing and think it would make an excellent AUG presentation - one that I would be willing to stay up past me bed time for!

Morning folks, what I am trying to do should be simple: I want ALL the records in the detail section to be the same color as the Group they are in. I found this code and I thought I was home-free: Option Compare Database Option Explicit Dim blnalternate As Boolean Private Sub...

In short, Hell No... Following up on this post, I wanted to say a couple of things. I know a few people whose livelihood comes from using Access - me included. The major difference between me and the REAL experts here is that I get paid a salary to be on a clock rather than finding clients to...

This is what our IT sent us today. I was looking for a reason to skive, I am taking this as a divine intervention - going to rack up some miles on my new toy. Life is good - Azure sucks

The amount of jokes regarding this story are abundant and despicable. I am NO tree-hugger, but the loss of life is never a joking matter.

One more Bucket-List entry scratched...!

So...driving my car today, my radio informed me that today was "National Smile Power Day". Seems there is a day for everything - except AWF. So I am proposing that we make Apr 27th International Access World Forums Day...