Search results

I think your method 1 is the same as right clicking on the file and selecting Merge. I use the merge method, which does NOT require admin as long as the file is on the computer. The merge only updates the current user's registry settings, which is why admin is not required.

Assuming you are not using SMB1 or 2, oplocks is not and issue. I have disable leasing mode of the server share containing the BE. This is more to reduce corruption and may reduce performance. Disable Leasing Mode...

A macro can handle an event and show the message box; It's not VBA but it's code.

To me that is code. I have used the same type of call to point an event to one of my functions.

Could you create a reg file with the key and merge it into your registry? Merge works on trusted locations without admin rights, or is that key in a restricted location in the registry?

Right click on the control, select properties. Change the name.

I setup a folder on the C: drive for all Access FE files. That folder is added to Trusted Locations. Really no different from how most software is installed.

Each new generation born is in effect an invasion of civilization of little barbarians, who must be civilized before it is to late. Thomas Sowell

I would not put a FE on OneDrive, because it will be trying to sink every change while you are working with it.

It was part of the key when I exported from the registry. In this case it was the date I originally saved the location.

I merge a reg file named TrustLoc16.reg that adds the location of my FE to the trusted location list for office365 and runtime2016. Windows Registry Editor Version 5.00 [HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Access\Security\Trusted Locations\Location0] "Path"="C:\\PathToYourFE\\"...

I use the joyfullservice add-in to do exactly what you describe. It is open source so you can look at the source code to see how they handle the problem. Note it exports the form/report and code to separate files. See joyfullservice on github. https://github.com/joyfullservice/msaccess-vcs-addin

You see the same gap problem in invoicing. To solve it the invoice number is generated and applied only after the invoice record is inserted. The record can only be voided, never deleted.

ACHTUNG! ALLES TURISTEN UND NONTEKNISCHEN LOOKENPEEPERS! DAS KOMPUTERMASCHINE IST NICHT FÜR DER GEFINGERPOKEN UND MITTENGRABEN! ODERWISE IST EASY TO SCHNAPPEN DER SPRINGENWERK, BLOWENFUSEN UND POPPENCORKEN MIT SPITZENSPARKSEN. IST NICHT FÜR GEWERKEN BEI DUMMKOPFEN. DER RUBBERNECKEN...

MajP in post #2 gave you a solution, Use Top 1 sorting by ContactID.

To bad this discussion got off the topic of jokes and moved into politics. PEER'S LAW "The solution to a problem changes the problem."

All those DCount and DMax calls will be very slow in a query, but workable in a small dataset.

You have to pass it a value from a control, otherwise the query processor with not call it. CountUpRepeating(IIf([Field1 ],Null,Null)) as Assignment

If you want the repeating sequence, the following function will work. Before opening the query execute the function passing the max value in the sequence. In the query use the same function passing it null. Public Function CountUpRepeating(vResetCount As Variant) As Long On Error GoTo...

Nixon's Theorem "The man who can smile when things go wrong has thought of someone he can blame it on."