Recent content by DaveMD

Great discussion in this thread and excellent illustration why you have to carefully evaluate the output of generative AI as it can come across as confident yet be very wrong. It is interesting how all three of the below critiques by Copilot demonstrate a lack of the AI understanding basic...

It's clear from the follow-up responses that I did not correctly interpret the intent of the OP's post. My response was assuming the intent was to be able to handle large numbers (more than the 4 byte limitation of the Long data type) to determine if the input parameter is an integer (whole...

I've dealt with this type of thing before with very large numbers. There is an easy but not well documented solution. Change your CLng() cast to Fix(). Fix can handle working with Doubles (8 byte numbers) while CLng is limited to 4 byte numbers which is why it errors out on large numbers...

I am not familiar with Firebird, but potentially this might work if it is supported. In SQL Server, you can include the "Application Name" in your ODBC/OLE connection string. Then, from SQL Server, you can identify the application related to each connection. Driver={SQL...

These points by @GaP42 are very important for database design decisions for tracking the statistics. The OP indicated the desire to be able to report on stats by shift, by position, by assignment. If the stats are only recorded at a monthly granularity, this wouldn't lend itself to reporting...

I can replicate @CJ_London 's issue when trying to copy/paste directly from Excel. If that is the scenario, I was able to first copy/paste from Excel to MS Word, then copy/paste from MS Word to a post here and that worked.

With this information that you are using SQL Server and you are looking to scale this (you note the table is expected to grow to half a million records), you have several good ways of tackling this: 1. As @DHookom notes, I also would highly suggest having this query be processed on SQL Server...

A subquery with TOP 1 can work well for your scenario. See example below. SELECT p.PricesProductFK, p.PricesOrderedFromFK, p.PricesQuantity, p.PricesRegisteredOn AS RegisteredOn, p.PricesRegisteredBy, p.PricesUnitPrice FROM tblProductPrices AS p WHERE p.PricePK...

MZ-Tools is a great tool for MS Access development. I use the function header feature frequently. It could be customized easily to format the header in xml format. I understand the OP is also referring to how Visual Studio DotNet then uses the xml header when calling the function to show...

To help illustrate some of the concepts that are being noted, the relationships for this portion of your diagram could look something like the below as far as the History tables. As many have already mentioned, there are many different factors in determining how the tables and relationships...

As a few things to check given this is a compile time error: 1. Your call above is not capturing the return value. If you declare strRange and assign the result of the function to it, that may take care of the compile error: Dim strRange As String strRange = GetDateRange(fld, cboDate) 2...

Both of your points are well taken. It's phenomenal to have a site that has lasted multiple decades (and still have active users that have been on the platform since the beginning) and I understand the difference in dynamics with a site like this.

@tvanstiphout The StringFormat and StringFormatSQL functions in your presentation look very useful for building dynamic strings. I do the same with using a Dictionary with key/value pairs for passing OpenArgs, but those additional helpers look great and I will plan to incorporate those. It got...

I'm new here and have been impressed by the functionality of this platform. I've noticed when reading a thread it does a good job of identifying similar threads at the bottom of the page. One thought was whether that similar functionality could be integrated where when a user attempts to post...

As a frustration by those lending their time to help however they can is that the OP asked almost this same question (identical SQL query issue) in May 2025 (titled "Family not included in aggregate function") and it was answered there. That should have served as a learning experience where...