Recent content by Minty

  1. Minty

    Solved problem opening a .csv file in excel - dates all messed up

    @Pat Hartman - I'm afraid I've come across a similar issue with UK dates in CSV's and Excel - it's definitely an Excel "trick." No special characters etc. it's just Excel being a pain in the ass. @CJ_London - I did find a work around, but cannot find the database or process to remind myself...
  2. Minty

    Solved Export data from Passthrough Query to CSV

    DAO is the preferred/default method. I don't think with a pass-through it will make much odds to be honest. If it works stick with it.
  3. Minty

    Solved Export data from Passthrough Query to CSV

    The pass through can be used as direct source for the export to CSV, however it would probably be better to store the data locally in a table as if you need to requery it, filter it etc, the PT query will be fired again. So to confirm @Gasman option, create the local copy then simply link to...
  4. Minty

    Code Tags Query

    If you paste or type into the normal reply window, then select the text you want put in code tags and click it just doesn't work. It used to before the last updates.
  5. Minty

    Solved Database sluggish after Citrix Update

    Check things like the Trusted locations, set on the new Citrix virtual environments. If they aren't set it can cause quite a slow down.
  6. Minty

    SSMS v18 is wonky as hell

    I've just switched over to version 21.3 which is integrated into Visual studio, and is a bit different but I'm liking it, however I'm pretty sure I was on version 19 or 20 before that? Surprised your not on the latest version?
  7. Minty

    Round function being ignored in query

    What happens if you change it to a double? I've seen some strange behaviour with single data types, so no longer use them.... In fact CSng(1.00000004749745E-03) should return 0.001 as it's beyond it's prescribed accuracy: ? ? Interesting
  8. Minty

    Button Bugs

    Sorry Colin, I'm on holiday from tonight so won't get the chance to enquire with the client before I'm incommunicado. if by some miracle I do, I'll report back.
  9. Minty

    Button Bugs

    I've had a couple of end users experience this and they are definitely not on any sort of preview channel.
  10. Minty

    I need the minimum value among 5 different fields in one record

    I had a battle like this for a client, who was desperate to have a spreadsheet style method of dealing with some of their data. It involved variable number of"steps" in a process. A process could any number of steps 1, or maybe 6 or 7 steps (max according to the user). Each process can be...
  11. Minty

    Solved It takes too long to download data from server

    It looks like your first query is joining server tables to a couple of access local queries. Move the entire thing to a server based query (a View in SQL Server) including the local queries. If the local queries use form references as parameters, it gets more complicated, but can still be done...
  12. Minty

    Poor performance over WiFi

    WiFi isn't good at maintaining the type of connection Access uses (SMB Protocol), so there will be a lot of behind the scenes connection renegotiation. Most WiFi setups are also designed to save power out of the box, so continually scale back things silently as well. This ultimately can lead...
  13. Minty

    Sql Joins issue

    The easiest route to do this is to take what yon need the All from (The courses) and then left then left join it bac to the people/courses query, something like (I cant work out your table names, it looks like you are missing a courses table? ; SELECT Course.*, CourseCount.CCount FROM...
  14. Minty

    Sql Joins issue

    Right Joins are seldom if ever required, as they effectively are the same as a Left join, just with the precedence based on the Join order. It's quite hard to see what you are trying to achieve without some sample data and your expected results, but suspect you really want to use a window...
  15. Minty

    The Slightly Obscure Music Discussion And Quizzy Thread

    We saw The The in London, September last year, having been a fan since the mid 80's as well. They were excellent, and Matt Johnson still knows how to hold an audience.
Back
Top Bottom