RonPaii's latest activity
-
RonPaii replied to the thread Future of Access.You can quickly detect the drop by using WMI to setup a network monitor then close all forms or Access when detected. -
RonPaii replied to the thread Access instance remains in memory once closed.It may not help, but try add a set frm = Nothing inside the loop If Not accApp.CurrentDb Is Nothing Then 'close db...
-
RonPaii replied to the thread Help with moving Access database.On your computer using Access, add the folder to your safe locations. Use RegEdit to locate the registry key. In my case...
-
RonPaii replied to the thread Help with moving Access database.You don't need to worry about safe locations for the BE database on the server, only the FE on the workstations. The security prompt is...
-
RonPaii replied to the thread Help with moving Access database.The reg file I am merging has been in use since 2016, before moving to 365 and 64 bit. Windows Registry Editor Version 5.00...
-
RonPaii replied to the thread Future of Access.Each team member work on their own copy of the FE and pushing out changes just like an IDE like .NET. Each export only exports the...
-
RonPaii replied to the thread Future of Access.I not using Visual Studio for VBA. The programing is done in the ACCDB, the add-on is used to export changes and if I need to import...
-
-
RonPaii replied to the thread Future of Access.Maybe were are talking past each other but once I started using joyfullservice for export and build and Git for source control, I...
-
RonPaii replied to the thread Help with moving Access database.If you know your FE will be placed in a constant path such as C:\YourCompanyName, you can then add the same path to your computer...
-
RonPaii replied to the thread Future of Access.I don't understand why you are treating errors in an Access module any different then any other environment. If I make a breaking change...
-
RonPaii replied to the thread Help with moving Access database.I have a ACCDB FE using runtime on about 35 workstations with out problem. All function have error trapping an logging. If you install...
-
RonPaii replied to the thread Future of Access.All development environments have the same problem if you release without proper testing. You can get daily example on the Daily WTF...
-
RonPaii replied to the thread Future of Access.With an add-on like joyfullservice which exports each Access object to a text file, the single container is not an issue. A new ACCDB FE...
-
RonPaii replied to the thread number lock keeps going off.Eliminate the send keys by setting Response = acDataErrContinue, Undo the input, then move the focus to a different control. In this...
-
RonPaii replied to the thread Service Ticket Table(s).I would also add a Complaint table. The OP stated that the service request for 1 machine may come from multiple customers.
