Search results

I agree, work in your native units. I mention convert because we do get models from customers / vendors / suppliers that are in another dimension, which in most cases are automatically converted on import or link. Also some customers require drawing dimensions to be in Inch or Foot - Inch, or...

With spreadsheets I only use import spec on sheets I control. Those coming outside, I allow the user to select the columns to import. For ColumnCount = 1 To 20 ' Pull each column header to var ColumnHeader _ =...

Store dimensions as double or decimal in what ever unit you want, Millimeter, Centimeter, Inch, Foot, Foot-Inch-Fractions etc. Convert user input to that unit before storing. Do normal arithmetic, accounting for loss of precision. Present it to the user in your stored units or convert to the...

To me that would be a huge problem. A few years ago I had problems with a form who's source was a table. Editing a text field in one record updated a different record. The form had been in user for over 10 years with only minor changes. It turned out that when the record count surpassed some...

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