Search results

Show us your existing VBA code, then, please.;) I don't think the SQL you show corresponds to opening a recordset using OpenRecordset. My guess is that it needs to be something like this. Public Sub Populatedates() Dim intDateCount As Integer For intDateCount = 0 To 1094...

Most experienced Access developers have come to a very similar conclusion regarding the creation of Primary Keys from bits and pieces of other fields. That conclusion can be summed up as something like: "This method creates more problems than it solves." Therefore, the most commonly offered...

I have to agree with CJ. To what end would you want to deploy SSMS on a client's computer? To make it easier for the client to connect to and explore/dink around with/modify the SQL Server database for your application? I'm sure that, if the client has an IT department, their security team...

From time to time we hear about legacy apps running on Access 97/2003/2007 etc. The defining characteristics of such apps generally include isolation from integration with other applications and a business model that hasn't changed since dirt was invented. That's fine where it works. Until it...

There are very, very few black and white decisions. I well recall the contretemps surrounding Kaspersky. For a while I used other Anti-virus tools, but eventually, it seemed that Microsoft's Defender became good enough and easy enough and ubiquitous enough to decide maintaining a separate tool...

Good point. 👍

Further to what has been suggested, you need a table called something like "tblLogin". It will need fields like "Login" and "LoginDateTime". In an AuthoExec macro, call a function that captures the UserID of the person starting the application and the date and time of that login. Store that in...

There is a commercial application that is really good at comparing accdb versions. https://kellermansoftware.com/products/accessdiff When I was active as a consultant, taking over "rescue" projects, I found it well worth the cost of a license.

Who better to ask that one of the AI's? This is from Claude. Based on recent research and reporting, here are the key locations where AI data centers are being constructed with significant power and water constraints: Major Constrained Locations Northern Virginia (Loudoun & Fairfax Counties)...

Isn't this thread supposed to be about performance of SQL Server Management Studio version 21 versus SQL Server Management Studio version 22? Why are we even talking about Access in this context?

I think it's a grey area and most such reseller offers probably do skirt the edges of their licensing agreements with Microsoft. On a different, but related topic. I am now party to two different class action lawsuits against AI companies for downloading books from pirated online libraries...

The key is that you will be buying an LTSC licensed copy, with all the rights and restrictions that entails. Specifically, it is my understanding that LTSC licenses are NOT intended to be resold at retail. They are sold to an organization, to be used within that organization...

Muddying the waters ever so slightly. The current plight of technology-centric forums like AWF is clearly related to the use of AI. It's a case where I believe the correlation between increasing availability and usability of AI and decreasing activity at such forums does indicate a high...

Correlation doesn't prove causation. I'm not going to argue whether the increase in number and size of Data Centers in New Jersey has or has not contributed to increases in electricity prices there. It may well be a contributing factor. I am going to suggest that it doesn't necessarily follow...

"For ~£30 it's a steal. Is it?" And why would you think that? 😉 Is it because the full retail is $179.00 (US), or ~ £133? https://www.microsoft.com/en-us/microsoft-365/p/access/CFQ7TTC0PD0B Perhaps, when a deal seems like a steal, it really is just that.

The moral of stories like this is that risk management is a complex calculation between competing priorities and costs. A cost-benefit analysis is appropriate in this context. I'll go down memory lane a bit and try to recollect the major outlines. Basically, one can construct a four quadrant...

In addition to clarifying what you need to Group By, please explain what it means to "clear the filtered Data". Delete it? Remove it from a displayed result? Something else?

I'm partly guessing based on the use of the const in the VBA and the presence of the talley table. I've been wrong before, though.

I think the goal is to create 26 lines on the report per group, regardless of how many records are in each group.

Help us understand the request by specifying the sort order you want to apply.