Search results

Do you need to edit the data, or is it purely for display purposes? If it's the latter you can use a Report in a form, if that helps? Otherwise you need to repeat a sub form 4 times and figure out how to display the correct records in each one. And if you want to scroll around them it gets even...

Sad to hear, he will be missed. :cry:

You can script it in a stored procedure, without going into too much actual detail (as I think I've done something similar but can't find it.), I would loop through the field names into a #temp table then use that to drive the dynamic SQL string generation for the cross apply. If there are...

You definitely do not need to install SSMS for an end user to gain access to the SQL Server back end. If the application is self contained, once it's installed there should never be any need for anyone to do any modifications to the backend. Backups/ etc. Yes, but that is a separate topic...

Mines sits in a a dedicated dock, i have one at home and one in the office. When i'm out and about the battery life is still pretty good, but if I do need to work of a mains adapter and charge it, it's a huge 135W thing that isn't vey lightweight to cart about! I do have a much smaller 90W...

I would have thought a simple QuotationEmailCC = Nz(Me.QuotationCCEmail,"") Would have solved the problem?

We do this all the time for local versions of lookup tables with Azure SQL. Azure SQL plays absolutely fine with Access, it's our main data model for a lot of clients. I uses this process and it works very reliably. Sub sUpdateLocalTablesFromSQL(strTable As String) 'update the local table...

I have downloaded it and used the Gemma engine. I have 64 Gb RAM (Lenovo P51 Laptop, i7-7820HQ CPU @ 2.90GHz, 2904 Mhz, 4 Core(s), 8 Logical Processor(s)) and it was only using about 5Gb of the available free memory (at least 30Gb Unused). Processor use was significant though. It does have a...

That's quite a wall of text. I've removed the white space and indented it : 'STATUS "Deleting Previous Import Table" - STAGE1 On Error Resume Next DoCmd.DeleteObject acTable, "NISFeatureData2" On Error GoTo 0 'IMPORTING SHEET - STAGE2 'DoCmd.TransferSpreadsheet acImport, ...

Hmmm - The most reliable way to make sure you capture the changes no matter where they occur would be a Data Macro. MS - Data Macro They can run on a table change event, so that might be a way to achieve what you want. Alternatively, if you are certain that data isn't updated anywhere else you...

I would only update it before you run the main process. If the data isn't being used elsewhere, there is no point adding the overhead of keeping updated until you need it.

This might be one of those instances where you are better off temporarily storing the calculated values as a temp table and then joining that to your other results. Having had a closer look, I think you could create a query to produce the current stock quantity for all products with a bit of...

I'm interested. Although I haven't been suffering for this, I did some time ago, and ended up doing a full Windows re-install/upgrade. I'm sure some clients are probably experiencing it without realising.

@tvanstiphout bear in mind this was already a SQL server backend, so some of the usual issues with moving to a SQL backend should have already been overcome. However, the difference in connectivity performance between an on-prem SQL server and an Azure one is pretty significant, hence wanting...

We do lots of Azure SQL back end work. Can you post up the actual code used to open the reports, and if possible the SQL of the Access source queries?

To confirm / expound on @sonic8 answer, SQL will cast numbers automatically based on the initial supplied values. SELECT 1/CAST(1.95 as decimal(28,16)) AS WTF, 1/1.95 as Uncast WTF Uncast 0.512820512820512820512 0.512820 Does that make sense?

If you are using SQL server Ver 2019 then I would update everyone to at least ODBC driver 17 and preferably version 18. Even if it doesn't fix the immediate problem, it is much more stable and handles dropped or interrupted connections in a much more elegant fashion. This could be a network...

I'd like to claim some hand in the taking of it, but just nicked of the interwebs I'm afraid.

More like this I suspect Opps double post - the first one didn't register as uploaded. Welcome aboard Neil

More like this type of thing I suspect