Search results

  1. GPGeorge

    Solved You must use the dbSeeChanges option with OpenRecordset when accessing a SQL Server table that has an IDENTITY column

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

    Making the primary key as the client code from the client name

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

    Solved Encrypted Column Formula In A View Would've Been Ideal

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

    Solved Can You Restrict Important Info In Azure If Customer Owns Azure Subscription?

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

    Watch out for UltraAV Armor package

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

    how to make lastlogin date & time

    Good point. 👍
  7. GPGeorge

    how to make lastlogin date & time

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

    What's been changed

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

    Is AI Increasing Costs?

    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)...
  10. GPGeorge

    Solved SSMS22 Application Itself Slower Than SSMS21

    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?
  11. GPGeorge

    Access 2024

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

    Access 2024

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

    Is AI Increasing Costs?

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

    Is AI Increasing Costs?

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

    Access 2024

    "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.
  16. GPGeorge

    Is AI Increasing Costs?

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

    Grouping MsAccess 2003 data in a form and than clearing the filtered Data?

    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?
  18. GPGeorge

    error while Adding blank rows to a report

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

    error while Adding blank rows to a report

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

    error while Adding blank rows to a report

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