Recent content by spaLOGICng

The Windows Learn Link OP commented on using SQL Server as a BE, using Trusted Connection. The Copilot Response to that recommended using Non-trusted DSN-less Connections and certainly no file-based DSN. I did not provide that here as the OP has Access as a BE.

My Copilot returned this for me today in addition to the other factors mentioned here as it relates to Windows 11 I have not had an issue with the clipboard. Of course, running a Windows 11 PC with 32 GB Ram and a 12th Gen Intel(R) Core(TM) i7-12700 (2.10 GHz) processor on 1TB SSD probably does...

Good stuff there... thanks for sharing!

Application, both BE and FE are important. I keep everything out of any Folder that is in the Search locations for the User. For instance, the Documents and Desktop Folders are big no-no's. For BE's, I always place them in a local drive folder on a dedicated box at least one that is accessible...

Yes. I did just respond to @isladogs. I won't create a duplicate response. You can read there. Thanks for your input.

This was a case of serendipity. He was unsure whether or not he could download an application due to their security protocol. He is a new client and migrating all his efforts to Microsoft Access from Excel. Once we confirm that he was able to download, I've been confirmed his office version...

I am hoping someone here has encountered this same issue and has a solution. I have Access M365 and a Client has Access 2021 LTSC. I sent him a blank (empty) Access Database that I created in M365. He received an "unrecognized database format" message. I then turned off all known new features...

When you have the Master and Child Link Properties referencing the correct fields, the columns on the subform will be automatically populated with the Parent/Master Values. Just create a query that represents the record source of the subform correctly and add the name of the query to the...

With M365 E3, I have opted to get the necessary end points using PowerAutomate, inserting the information into a List Table and then linking the List into Access.

Yes, that is an issue. I do not write a Function to get the Date. I use the NOW() as you do, at the table level. That would be food for thought for others who read this in the future. It is my policy to use as much of the built-in features and functions as possible until no longer makes sense...

Most if not all Applications do not have a Sequencing Method within a set of records. You would need to add the functionality. The Access Report does have a Report-level method using Running Sum across Groups or the Report, but Forms do not. For sorting, I simply use a Date Created Column that...

I echo a lot of the comments above. There are good books and there are better ones. One of the best books I have recommended for years but still relevant today is the Access Cookbook 2nd Ed. by Ken Getz.... it is available at O'Reilly publisher and Amazon, and other prices. I recommend Udemy...

It appears there is an embedded carriage return or line feed even after removing the Booking Ref: You can use the Replace() function to remove it/them Replace(Replace(Replace(Mid([RawData], InStr([RawData], "Booking Ref:") + 12, 12) AS BookingRef,CHR(9),""),CHR(10),""),CHR(13),"") You may...

We are reading reports that there was an issue with a recent update to MS Office and specifically Access that are wrecking havoc. Here is a list of issues. I have had clients reports similar issues but with Access. I suggest performing an "Online Repair" of your Office Installation.

Hi Doc, The Bug with the Update that the OP mentioned, which I am familiar with, did cause some of the issues that I mention, at least with some of the applications that a few clients have presented to me for resolution. It also affected some ODBC connections. This did not happen with all of my...