Recent content by Anakardian

  1. A

    What are stored procedures, can anyone please explain in simple terms

    I have used stored procedures in combination with an app as it allowed us to bypass some limitations with regards to triggers on tables we used to fire messages off to a queue that could then perform actions based on the total data available across many different tables. The input came in from...
  2. A

    Family Fitness - Treadmill

    As an alternative, maybe a rowing machine would fare better? Those I have used have been quite robust and can provide quite the workout. I would recommend those using an air brake/fan to provide resistance as it is smoother and easy to control like a Concept2 although it is a rather expensive one.
  3. A

    COVID Reports

    Having no idea what your home is like, here is a few suggeestions: Knitting or crocheting, yes, everyone can do it. Example Embroidery. Another one for all to do. Example If you have the room, woodworking/carpentry. Example if you don't mind the smoke, there is woodburning decorations. Example
  4. A

    Importing Excel Into Access

    One explanation could be that when it imports the spreadsheeet, it takes a sample of the first 10 or so rows to determine the datatype. If on of the useridd iss not a number in one of the sheets, it willl do exactly that. It can be something as trivial as a trailing space that messses it up.
  5. A

    Vote by Mail is NOT a secret ballot

    We have about 5 million in the entire country so there is a difference in scale right there. The question is, do they count the votes on the site or ship it off to a central place to count?
  6. A

    Vote by Mail is NOT a secret ballot

    Another major difference. We have a central registry for all persons living in denmark andd thus we know who is allowed to vote. Basically it means we have a unique id for each person that follows you from birth to grave and beyond. Many reasearchers, especially of the medical kind, loves to...
  7. A

    Vote by Mail is NOT a secret ballot

    See thats where you get the issue. Many places where you vote in the US go for large volume and few people. This means machines are needed with the results we have seen so far. Discussion of that is an entire field unto itself so lets not go there. We have gone for decentralised and small...
  8. A

    Vote by Mail is NOT a secret ballot

    Of course we have our problems as well but i have never heard about anything not rsolved in a couple of days. The biggest trouble is if someone dies betwen the ballots are finalized and the election. At that point there is no going back and acciddents still happen. I forgot to mention that the...
  9. A

    Vote by Mail is NOT a secret ballot

    So this thread popped up and waved at me. I never understood the obsession with central automated counting of votes you seem to have in the US. Coming from Denmark, let me tell you how it works here. I know the scale is a bit different but at the front end it should be comparable. There is...
  10. A

    Speed up Delete Query on SQL Server table

    A thing that might be a bit of a workaround and may not work. If you can have a staging table on your BE server, you can put all you data from the FE there. With a stored procedure you could have the server do the entire append operation instead of using access for any heavy lifting. I found...
  11. A

    Coffee ring stain erks Scientist

    Sometimes you actually get interesting things answered this way. Take a look at these: https://en.wikipedia.org/wiki/List_of_Ig_Nobel_Prize_winners
  12. A

    Coronavirus - Time to Reflect on the Initial Reactions

    The infection rate lags about 2 weeks as well. Only if you test everyone, every day, and get the result in time to act upon it, will the infection rate be known. Many people do not have symptoms that they notice but are still able to spread it. All you know from the death rate is how many...
  13. A

    Query to check data in old and new tables

    Any reason you don't want to move the old data into the new table? that would solve the issue a lot simpler
  14. A

    Selective Emails Condition

    If you make a query to collect the e-mail adresses required, you can loop through the result and add them to an e-mail. Though this does require you to use VBA, it will give you more options to customize the e-mails. You could even customize it to individual e-mails with specific messages if...
  15. A

    Automated Email from List

    Did you consider using BCC? you only need to create one e-mail and none of them can see the other receivers unless you put them in the normal To and CC fields.
Top Bottom