Search results

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

Your above screenshot is very helpful to clarify what you are ultimately looking for. The below query should give you the output you are looking for in a single standard query. Give this a try. SELECT CurrentEntry.entry_date, CurrentEntry.entry_amount_kg AS kg_amount, (...

I have observed these same anomalies with VBA strings. One thing that I have found is that there can be a difference how a "Variant/String" is treated compared to how a pure "String" is treated in certain contexts. Interestingly, the VBA debugger can differentiate between the two as shown in...

This is very accurate. There are only so many times that you can point to some network blip (or other intermittent event) causing corruption to your users, even if it is the reason. Sometimes the users' environment (slow network, use of WiFi) is what it is and beyond your control. It will...

Give @MajP 's suggestion a try. For example, change your above code to: Me.Lvl1Img.Visible = Nz(Me.Lvl1Chk, False) Me.Lvl2Img.Visible = Nz(Me.Lvl2Chk, False) Me.Lvl3Img.Visible = Nz(Me.Lvl3Chk, False) It may also be helpful if you could post a screenshot of your report in Design View here...

Welcome Martin from a new member myself. I also had developed a large adp project linked to SQL Server many years ago that I had to convert to accdb. Many things were much easier using an adp and miss the ability to directly use TSQL queries for Record/RowSources in forms, controls, and reports.

Many on this thread have provided very good input. To help illustrate what we mean by junction tables and provide one way a portion of this can be done, you could follow a design pattern like the below diagram. This overall would provide the following benefits: tblEmployeePositionHistory...

I had a similar interpretation as @Edgar_. Many beginners who are learning Access (or even experienced users with strong database skills) may not be programmers by trade and thus may not be aware of the basics around debugging. Covering that could potentially be useful if not already addressed...

Currently based on the OP's code posted above, I see nothing from the recordset being used in the UPDATE query. For example, currently, you are looping over each record in the recordset, but you have nothing in the WHERE of your UPDATE query or in the SET that is being used from the recordset...

One thing to check on this, if you are on a recent version of Access (such as version 16), DAO is now defined as part of the reference to "Microsoft Office 16.0 Access database engine Object Library" where you should be able to remove your separate reference to DAO 3.6 to avoid any conflicts.

@arnelgp I was speaking as more of a rule of thumb to avoid "NOT IN (SELECT*..." in the context of the broader discussion about unmatched query approaches. I understand in the OP's specific instance that it wouldn't happen because the field is part of a PK and can't be NULL. From much...

I would add one more approach to this that isn't always thought of and that can perform very well when using a backend RDBMS, assuming the OP's dashboard does not need to be editable (I'm assuming it may not need to be editable based on the OP's screenshot and noting it is a dashboard that is...