Recent content by CJ_London

OP is not saying users share a FE, they each have their own copy - but all those copies are the same folder and there is nothing to prevent them opening the ‘wrong’ copy

you can simplify your code for example Public Sub setColours(sStr As String, frm As Form) Dim bc as long Dim str As String Dim ctl As Control bc=rgb(240 ,240,240) ' default colour if "Notes" is null Select Case sStr Case "boxes"...

That is also a no no. Wi-Fi can drop connections then reconnect but the FE will lose track of the BE. Worse when working from home since you are dealing with a router as well. It is probably the reason for your issue. If it has to be WiFi and users work from home I suggest review using terminal...

How are the users opening their front end? By selecting the file? a shortcut? something else? When you say you have put the FE back on the server, how do you ensure they open their copy and not someone else's? (generally a bad idea to have them on the server anyway - impacts performance among...

The problem with that is there is no circular reference as far as I can see - open an access instance, then close it. I’m not even assigning a .accdb

Can you not use code to assign the value rather than copy paste?

Perhaps it’s a difference in bitness?

Col - you are one sad, miserable git (my opinion) and most people don’t think like you so it will be appreciated if you don’t imply they do

My experience is with northwind - if I download and open with 32bit access, all well and good. If I then try to I open the same file (having previously opened with 32bit) with 64 bit I get errors. Same if I open the other way round

Providing the OP doesn’t then try to open the file. If they do, I doubt their client can. OP would need to provide a new virgin copy

Don’t think the OP has said what the newer version is - if 64bit, it may not convert to 32bit mdb.

Way to go👍 I created an app for cataloging photos- it populated the file properties with keywords and used a tree view type form to create and catalog the keywords and view the files in a web browser control But don’t think it meets your requirements as it is not generic enough

Perhaps the OP can provide some example data and the outcome required from that data and clarify what ‘not working’ means - wrong result? Something else?

if that is a possibility in the button got focus event, transfer the focus to a valid control or even txtCurrent