Search results

Alas, this is the problem I started with when I first built the database. Having spent some time on this forum I came up with the syntax that I used in the original post. However, this only works when the [DueDate] part is in US date format. When it was shifted to European format it became a...

Evening All, I know this is an issue that has been run down to death, but I can't seem to get the syntax right and I need some help. I have a report within a database that I need to filter so it only shows the overdue items. in the past I had used the following: DoCmd.OpenReport...

This seems to be working, although I still have some more testing to do. It's not the most elegant solution ever :) Function GETNETWORKPATH(ByVal DriveName As String) As String Dim objNtWork As Object Dim objDrives As Object Dim lngLoop As Long Set objNtWork...

TBH, I didn't even think of that one! That would certainly take care of all future events, but I still have quite a few old versions to convert and I really was hoping to find a quick way to do it rather than having to go and fix them all manually.

Hi All, I have a database that lets engineers link to engineering drawings in the processing record using a hyperlink. Although we've had the discussion many times, occasionally the engineers will forget to browse via the Network Drives and go via their mapped drives instead. Thus you have a...