Search results

I quite like the steering wheel, and a decent radio/sound system.

VAG, BMW and Mercedes have had this model for quite a lot of years. (3 or 4 at least) My wife's' Audi A3 has all the hardware on board for Intelligent (Radar controlled) Cruise control, but we didn't spec it when we ordered it. You can "rent" it by the day, month, year or forever if you want to...

Further discussion / Cross-posted here https://techcommunity.microsoft.com/discussions/Access/ssma-for-access-not-recognising-datetimeextended-fields/4442520 For information I'm using version 10.2

It's a office update thing. I had a client panicking about it about 3 weeks ago, thinking they had broken something.

An ArchivedDate flag is something I use extensively in a lot of tables. It makes it easy to manage historic data and keep data entry forms relative to the live environment. IMHO there is nothing intrinsically wrong with displaying a Autonumber ID as a unique reference as long as no relevance...

@GPGeorge - This sounded familiar when I answered earlier and lo and behold: https://www.access-programmers.co.uk/forums/threads/how-to-update-a-currentstock-control-in-the-subform-after-a-requery-from-the-parent-form.333705/ It's essentially the same question. With similar answers...

The first batch of code doesn't appear to do anything that a subform requery would't achieve, if it does indeed achieve anything at all. Do you understand the logic flow of it? It makes very little sense if you walk through it. The second code is super convoluted way to join the results of your...

I've an found an interesting bug with the SQL Server Migration Assistant for Access (SSMA) recently. I was trying to import / migrate data to a Azure SQL database, from an Access database that had most of it's date fields set to Date/Time Extended . SSMA refused to identify them as any type of...

Decimal field with a scale of 0 will have no decimal value after the integer...

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