Search results

Providing your phones support terminal server- it can be done at a cost - and clearly form design needs to take the screen size into account and how users navigate the app

so my qualifier is irrelevant? Perhaps need to look at the query plan to see how it is optimised

Please clarify what you mean by Cartesian product. My understanding is no joins

I was going by the original post - Agree using FK would be better. I don’t see a Cartesian query in my suggestion

on the basis that a contact can only have one qualification per category (i.e. a contact cannot have more than one bike qualification), this can simply be done with joins SELECT A. ContactID FROM tbl_Contact_Category As A INNER JOIN tbl_Contact_Category As B ON A.ContactID=B.ContactID WHERE...

Reminds me of the guy who worked in a building yard. Every evening he left with his lunch box, tools and work clothes in a wheel barrow. Security regularly checked and verified all this stuff was his. Turned out he was stealing wheel barrows

You might be able to do it using a shell command to open the file with acrobat and save as a png. I don’t use acrobat so refer to the acrobat documentation Perhaps ChatGPT can help

when creating a field name, if you use a reserved word Access usually gives you a heads up that it is not a good idea - could apply the same principle to spaces - doesn't stop you using them but gives fair warning. I remember many years ago someone argued strongly that spaces in field names...

Providing you understand the limitations I don’t see a problem with a calculated field-they can’t be indexed, but then the same calculation in a query can’t be either. For me it’s more about how often it is required so for things like concatenating firstname lastname where it needs to be used...

As a test , suggest reverse your sort order - if the error is now at the bottom of the recordset it implies an issue with the data. If still at the top then the issue is with the function - perhaps a variable has not been initialised for example

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?

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.