Search results

Yes - instead change the form recordset type from dynaset to snapshot

Where is the code? If on the subform try Parent.recalc

There are many ways this can be done and would help if you showed what you actually tried together with details of relevant tables and fields. I would use two queries - the first to get all the periods you want and the second to calculate the cumulative totals For the first, you may already...

Perhaps that is all you watch. We get Suits, Hollywood Wives, a variety of American sports to name a few. Really think you should use I rather than we as you seem to live a very limited life and I’d hate to think our American cousins get the impression the UK population are all like you

Sounds like what you need is larger fonts or a smaller form I would look at your form design - are there fields that do not need to be displayed all the time? Just show them on a click event. Or perhaps increase font size using the mouse over event? Or use a tab control? Or an expand feature...

Without knowing the specifics of your setup, check the documentation for your TS or google something like ‘print to local printer from terminal server’

Why are you using like? And why not indexed? The use of the initial % will negate the use of an index anyway

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