Search results

Dimension can unitless, then you have a unit column or a default unit. If the unit is Inch all dimension are decimal multiples or fractions of an inch. CAD software for example is unitless, users setup the default in templates or configurations with units saved with each model, imported models...

I would use the form's on current event to disable the field for those that cannot edit it. If you are adding security I would add a group table to handle each type of user. Add users to each group to give them access to that group's objects. Now that your supervisor as requested security on 1...

Calculate number of months in the year of the date and number of years to now Public Function AgeInYearMonth(ByVal DateToCheck As Date) As String Dim Months As Long Dim Years As Long If DateToCheck < Now Then Months _ = DateDiff("m", _...

I use a PartVendor table to allow each part to have multiple vendor, with one designated as primary. Each vendor has current price with a date and future price with the date it becomes current. New PO lines get the current price from which I can get pricing history. Current price is updated to...

INo app but you can save the link to your home page and open it like an app. 🍎🍊🍎

I downloaded your application and manually opening the frm_Edit_Publications" form, I see the tool tips and they stay up as long as I hover. Office365 Access x64. Version 2506 (Build 18925.20216 Click-to-Run) Monthly Enterprise Channel By the way, how is the application started. I get only...

After some testing before adding to production I found wide and long data for the tree caused it to scroll to the right, hiding the check boxes and down, hiding the top of the tree. I added code to scroll to the left and position to the top of tree on load. It also now allows editing (leaf...

The current record on the form may have been edited and needs to be saved. Try adding the following to the beginning of your procedure. If Me.Dirty then ' Save changes while executing validation code' Me.Dirty = false End If

I don't think you should put the FE or BE on OneDrive. Windows copies changes to the cloud which could slow down both your FE and keep OneDrive busy uploading the changes. The BE very likely and will be corrupted.

In sample databases you will find 2 solutions to display multiple selections without using MVF arnelgp posted "Multi-value field (MVF) Faked Form. I posted staring with arnelgp's db "Multi-value field (MVF) using tree control". The frmUsers displays using both concatenated string and sub-form.

It's setup as a callback which raises an evert on my main form of the change. You don't need any timer and the main form would know how to shut down the other forms and/or the FE. BTW if you are seeing drops on a wired network, there is a hardware problem that needs to be fixed. I don't allow...

You can quickly detect the drop by using WMI to setup a network monitor then close all forms or Access when detected.

It may not help, but try add a set frm = Nothing inside the loop If Not accApp.CurrentDb Is Nothing Then 'close db 'If Not accApp.CurrentProject Is Nothing Then 'close db For Each frm In accApp.CurrentProject.AllForms If...

On your computer using Access, add the folder to your safe locations. Use RegEdit to locate the registry key. In my case [HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Access\Security\Trusted Locations\Location0] Export that key to a reg file. If you open it in Notepad, it should look similar...

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 about running code and macros not access data on the server.

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 [HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Access\Security\Trusted Locations\Location0] "Path"="C:\\YourPath\\" "AllowSubfolders"=dword:00000001 "Description"=""...

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 changed objects, not the entire FE. Commits are small and often. One problem with Access is it's tendency to update all named objects with the same name if you...

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 from GET or roll back, builds that source into a new ACCDB which is then compiled like normal. The joyfullservice add-on is not source control, GET handles that...

Maybe were are talking past each other but once I started using joyfullservice for export and build and Git for source control, I started looking at the ACCDB FE more like a DLL. I can fork the source in GET to try a something new. If a change to the production FE is need before the fork is...

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, configure that path as safe location. Now open regedit, go to that location in your registry and export the key. Distribute that file with your FE, then on the...