Search results

Error reports from users are notoriously un-reliable. Years ago I added logging of all trapped errors. Now I can check the log whenever there is a "CRASH" making it much easer to diagnose what the use(s) were doing before the problem.

I agree with MarkK. If you can, open the tables referenced by the form, sort each column high to low, low to high noting any null values.

It is documented by Microsoft, but I don't have a link. I am using an archive BE and have seen the problem, you can setup a transaction and process the move between BE dbs. without any warning including failures.

You can write the code to export all objects to text. Make table with a list of all objects in the current Access. Loop over a record set exporting the objects. Copy the table to the new MDB in Access 2003 Loop over a record set importing the objects. You could possibly use a version control...

The only time I open a naked query for a user is for a quick copy and paste and then only in read-only mode.

With Access BE, I also use a Archive BE but also linked to my FE. When exporting to the archive you need to understand that transaction only work on tables in the same BE. You will want to check the number of records to move then verify that quantity have been moved. Then delete the records in...

Provided a punch the time clock button. Let your hours processing function handle matching in and out punches.

I have 1 user with Grammarly installed having this issue, Windows 10 x64. There was a patch that mostly fixed it. From AI Having Grammarly installed can cause Microsoft Access to stay running in the background after it's been closed, leading to a "zombie" process in memory.

The next option would be virtual machines or RDP to 2nd computer. You could setup a virtual machine on each computer, If the computers are using the Professional version of Windows 7,10,11 and the computers have plenty of memory and a good processor. Lock down the VM and install Access on the...

If the software is critical for the business and they can't finance an update, then it looks like you will need to roll back the updates causing the problem then lock those computer down to not allow updates. Then to protect them disable the gateway on those computers NIC to keep them off the...

See my changes MainForm Public Property Get RefClassBFromSubA() As cB Dim mA As cA Set mA = Me.A_Data.Form.RefA Set RefClassBFromSubA = mA.RefB End Property SubForm-A Public Property Get RefA() Set RefA = mA End Property SubForm-B Private Sub SomeText_MouseUp(Button...

Are both the sub-form-A with instance of Class-B and sub-form-B inside the same main form? If yes, add a public property to the main form that returns the reference to Class-B in sub-form-A. Then in sub-form-B use that property. sub-form-B Set InstanceVar = me.Parent.Form.TheProperty

I pulled some code out of an existing modules, leaving in some constants and enum. modUtility.Logger is a logger function, can be replaced with debug.print or your own. pai1_Msg_Box is a function to display a custom message, can be replace with the built-in MsgBox using the same parameters...

What don't you understand? I uploaded a VBA module as a text file. Do you not know VBA? Do you not know how to import the file?

I used CAD as an example, now you are talking about rounding. In your example, convert lb to gram and round to your needs.

I am attaching a module using Microsoft Windows Image Acquisition Library v2.0 to do the scanning. The commented out enum(s) can be removed. modUtility.Logger in LogError can be replace with your logger or debug.pring pai1_Msg_Box can be replaced with the standard msgBox function.

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