Recent content by spaLOGICng

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

In addition to all other recommendations, here are a couple other things to check that may be affecting performance. 1. Indexes: I noticed that nobody mentioned indexes (through searching; I may have missed something). If you are applying filters, parameters, criteria, etc., to you report when...

In addition to the comments above regarding BIT Locker and Antivirus, there is another overlooked area within access itself that affects performance. If you have compression enabled, that could also lead to performance issues. As for anti-virus, a lot of System Admins like to blame software for...

I am not the one here trying to run a popularity contest. I come here occasionally when I might have the time to offer some insight when I have the opportunity. It is not my goal to insult or otherwise condescend on the intelligence of others. I have a business to run, a couple as a matter of...

I always love it when someone tells me that I need to change my design techniques. I am not sure to the level or degree that you have developed, but a lot of people developing in Access have not developed to the degree that I have in my career since 1991. I have also developed in DBase, Fox Pro...