Recent content by spaLOGICng

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

I prefer not to discriminate in that way. The feature is there for a reason. I will never tell someone not to use something, but I may provide reasons why I may not. I let them decide why or why not to use it. That is empowering.

It is a matter of preference, but for me it can save a tremendous amount of time. I have mostly automated my application development. I am about to move it from an Excel File to an Access Database. But I create Tables, Fields and all their associated Properties in a Table on a Sheet. I have...

Do not change the Data Type if it is already a number. Use the Long Format for the Number. On the bottom have of the Table Designer you will see the "Lookup" Tab. See my sample snippet as a guide.

There is a good reason why one might what to create a lookup on a Table. For instance, let's say that Table will be referenced by many Forms. When the Field is added to a Form in design view, the Drop Down is automatically created. This saves a lot of development time. When I am done with...

Check your "Anchoring" If you inadvertently changed the anchoring, they can sometimes be repositioned elsewhere on the Form. Also check the Visible Properties of the controls.

Echoing @GPGeorge

The Meaning, History, & Purpose of the Second Amendment ~ The Imaginative Conservative