Recent content by Minty

@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...

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.

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

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.

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.

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?

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

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.

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

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

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

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

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

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

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.