Search results

That 1st query is used to fill the array with part numbers to search and is not included in the timer.

Seek works with a linked Access table. tblParts in my example is linked.

At 1st I thought the select would be faster so I did a test on a large table with 300000 + records and seek was faster in this test. TestSelectVSeek Time in seconds Select time: 18 Select Parm time: 15 Seek time: 14 Public Sub TestSelectVSeek() On Error Resume Next Dim...

No reason you can't build the query testing multiple comparisons by also testing a 2nd parameter for which one will be true. Where ([FieldToTest] > [Param1] and [Param2]=">") or ([FieldToTest] < [Param1] and [Param2]="<")

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.