Search results

For modules, you won't get the last modified date. Apparently 'LastUpdate' refers only to the module documents collect as a whole. I found that I needed to run a hash comparison (MD5 Hex as I recall) to see if any changes have occurred and then use the date of the comparison as the last modified...

Code to insert Code Public Sub EventProcedure_Insert() On Error GoTo Error_Handler Dim Frm As Form, mde As Module, obj As Object Dim strForm As String Dim strTarget As String, strCode As String, strEnd As String Dim lngStartLine As Long, lngStartColumn As Long, lngEndLine As Long, lngEndColumn...

When I create a table in SS from VBA, I create the table with just the PK strSQL = "CREATE TABLE dbo." & strTableName _ & " (" & strFieldName _ & " INT IDENTITY(1,1) NOT NULL" & vbNewLine _ & " CONSTRAINT " &...

KMan, I had a similar experience except that it was with combo boxes not text boxes. This was on a single record view, unbound form. I removed and recreated to fix the issue. But then I had crashes on another (Continuous form). again, combo boxes. After much addoo, wailing, nashing of teeth...

@Jike Krailo "There are many DB's that will never have the need to move to sql server." very true, I was attempting to provide Pros as well as Cons but will admit I'm a bit biases against attachments, or any other non conforming data type, because I spend much of my time migrating the...

arenpg is correct. If you can, keep the file external to the db and only store the file name (or full path) in the table. But you will need to save the file to a location that all users can access. storing the image as an attachment in the db bloats the db and the attachment data type is not...

Yep, I looked a Parallels and was quite impressed but I've no where enough users to make it worthwhile. Thanks AJ, might save me from ripping both my bluddyarmsoff.

Pat, why do you think this might not work in a multi user environment? is it because System_User may not be reliable? Or because of the possibility of the same user opening more than one instance of the application? or is there some other reason?

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