Search results

Thanks Auntie, When you say "Thin Client" do you mean RemoteApp? RemoteApp is another approach I'm contemplating, and I have setup a remoteApp for an Access application with a SQL Server BE but only tested on my LAN so far. This will not have the latency issues with Azure and should be just as...

Hello Auntie Jack, I knew you'd be back... grew up in Wollongong myself I'm finding it rather difficult to get any idea of cost on an Azure Db. MS's calculators come up with figures or 200-300 / month and as my client really only needs SQL Express that is a bit over the top. Roughly how much...

well spotted DBguy, but here's the thing... I have a project where i was thinking of using this method and it is going to be critical. So in the spirit of resuse/recycle it seemed fitting to use a thread that already posed the same question and expand on it. In this case not only will I be...

if @Pauldohert is currently getting the correct System_User using a trigger then a table in the db which is updated by the FE when the user logs in with the System_User and whatever their user name is in the FE should be able to lookup that user name using System_User to populate the audit table...

If you have a table (let's call it tblCurrentUser) that stores both system_user and your user name from the FE that is updated or inserted when the user opens the application, you should then be able to use this in your trigger. you can be the System User in the FE with Public Function...

Your Virtual Desktops and/or "Virtual" Virtual Desktops is a great solution. Where you don't have an actual server the "Virtual" Virtual Desktops providing RDP is often the best solution. Laptops or PCs aren't expensive so to have on sitting in the office doing nothing but providing RDP...

I was trying to keep it simple. Using a non standard join is often faster but it gets a little sporty and your example doesn't fly. in fact I'd been trying to do something similar and couldn't get it to work either. but your example got me closer. Finally figured it out It needs a Group By...

Access BE via VPNs are notoriously slow and apt to corrupt the db. I'm with TonyE on using Citrix or RDP. Only the graphics need to go over the net. And I'm with Pat - SQL Server (even Express) is going to be a better solution than trying to pull data from an Access BE over a VPN. With SQL...

BOM is a classic example of where you should use a recursive relationship NOT a Child table. The Items that make up an item are themselves items with the same (or very similar) list of attributes so they should be in the same table. In its most simple form, where an item may only be part of one...

SELECT TransactionID , TransactionDate , DSum("GallonsIssued","tblAirlineTransactions","TransactionID <= " & [tblAirlineTransactions].[TransactionID]) AS IssuedRunningSum FROM tblAirlineTransactions ORDER BY TransactionID; This Simple example shows you how to get a running sum. It assumes your...

Try removing any conditional formatting for any form that you may be opening. Function FormatConditions_Delete() Dim frm As Form Dim ctl As control Dim strFormName As String strFormName = "frmWhatever" DoCmd.OpenForm strFormName, acDesign Set frm = Forms(strFormName) For Each...