Search results

  1. G

    Food for thought and maybe not for eating?

    "Sugars" come in various forms - Fructose is one (a naturally occurring sugar in fruit, honey), Glucose, Galactose, Maltose, Sucrose (commonly table sugar) are others (eg Ribose). The issue is excessive addition of sugars to the diet, the high calorific value of sugars and how easily it is...
  2. G

    Creating a Sort combo box

    There are many ways in which the sort order on a form can be changed using different types of controls - eg a toggle, or by clicking on the heading of a column in a continuous form - to some extent it is about user preference. However using a combo box as you have proposed you need to use the...
  3. G

    Trump Administration Predictions

    Disruptive it will be. Utopia or dystopia. Perspective will depend on your position in the new economic/social environment. There can be many and unforeseen consequences. What will our masters - the political class - do to adjust to the disruption? Do nothing - allow massive unemployment...
  4. G

    Machine Learning and Robotic Surgery

    Fascinating to see how AI can be applied in the highly professional/expert medical field and how readily embraced it is - driven by cost (patient/ service costs) and time (service/expert availability). Full autonomy may be a while off - da Vinci is generally used in the theatre from a console...
  5. G

    Machine Learning and Robotic Surgery

    Some of you here have developed a fondness for Chat GPT and its capabilities, others have decried the failings providing sensible output and lack of originality. You might like to consider the capabilities shown by machine learning in conjunction with Chat GPT is this article out of John...
  6. G

    Monaco Sql editor - exactly why we should use it ?

    You might appreciate this : Monaco SQL Editor
  7. G

    undo conditional format.

    You said Did you do this as a conditional format rule? If so why can you not remove the rule? If it is not a conditional format rule how did you set it? Are the other separate conditions on some columns set in the same manner?
  8. G

    Can Grow / Can Shrink not working

    next step: See above re Pat's suggestion re nulls and ZLS, / and post #6
  9. G

    Solved Is there a better option for VBA to change background color

    You can use the "point and click" conditional formating:
  10. G

    SQL VIEW, query executes but the text does not display in the editor window

    Enabled in my access and displays the SQL: Microsoft® Access® for Microsoft 365 MSO (Version 2410 Build 16.0.18129.20100) 64-bit what is your version?
  11. G

    Can Grow / Can Shrink not working

    Suspect the "grey" space between controls is adding to the space seen in print preview - compress the text box controls so no vertical spaces between them and check print preview again.
  12. G

    A Reason Why Drop Boxes Are A Bad Idea

    Are you sure those fires were not lit by MAGA Republicans against using drop boxes? Are drop boxes illegal? SO just pointing out that tRump and the Republicans are starting to fire up the same playbook as the election nears. No acceptance of the result, no effective evidence of fraud supported...
  13. G

    Election Fraud Opportunities

    Ditto You and others here suffer from a form of Messianic Adoration Disorder (MAD) that you have lost any sense or ability to evaluate / assess the character of tRump
  14. G

    Election Fraud Opportunities

    Or how stupid are you? There was no undemocratic scheme by the Trump team to overthrow the election, using Pence - irrespective of any uprising? That is not simply complaining about a tight election loss and contention about vote counting - it is way more serious. How Stupid are you? The were...
  15. G

    Election Fraud Opportunities

    Are you soo blinkered you cannot read / comprehend what it said? :ROFLMAO:
  16. G

    SQL string v stored query

    As someone who is familiar with the taxonomy of living things (but defer to your expertise, especially wrt herbaria and the specific data requirements) and with db design I do have concerns with the apparent flat file db structure (50 field items listed and 6 records) you have provided. I do not...
  17. G

    Election Fraud Opportunities

    And yet you are not bothered at all by what went on in the last election - you could bear to see it or to hear it? A pre-planned strategy to usurp the election. So hypocritical - on the one hand to claim (unproven) voter fraud and yet ignore the attempt made to STEAL the election. The rules...
  18. G

    form/subform problem

    The text box Stat should not be bound. Set its value using the expression builder ("expired" or "not expired") using an IIF statement that depends on the value of DCOUNT. Lookup the DCOUNT function and its parameters applying the appropriate criteria for selecting the records of interest, the...
  19. G

    A Reason Why Drop Boxes Are A Bad Idea

    the playbook: The Last Election Pt1 The Last Election Pt2
  20. G

    form/subform problem

    Why not do a DCOUNT on the set of records that your subform is showing to test if the subform records have any status value <> "Expired". If a count > 0 is returned then the STAT in the Sheet1 form stays as is, else change it to display "Expired" on the Sheeet1 form (not stored in the underlying...
Back
Top Bottom