Search results

not sure it is related but I have been having issues with access not closing properly - it leaves an access instance in task manager>background processes, doesn't cause access to crash, just won't start. So I would check task manager to see if that is happening to you. If it is, delete or end...

or you put them in the other way round :)

that is assuming they are always next to each other Did you look at my suggestions?

a function can return a recordset - might be one record, might be more. Not clear to me what data is what - is the last column the monitorFK? You could also perhaps use a crosstab query with column set to monitorFK and the two values combined as a value (Systolic & "/" & Diastolic) and then...

you seem to be missing some code - ws is not declared, what is the code represented by ... and personally I would use dao.database rather than just database

There is also If a stupid idea works, it’s not stupid

Not prepared to get into a debate, come and live here to find out how much has gone wrong in the last 15 months or so. It's not just about those particular laws.

No - ever since labour got into power

BBC is getting a lot of stick for: 1. Biased reporting - DT is threatening to sue for $1b for unfavourably editing a video on 2021 speech, and a report on Gaza broadcast without making it clear it was created by HAMAS to mention two recent activities 2. LGBTQ agenda overly supported- recent...

Phones always do

You can't use TOP with an update query but if you know the recordPK of the first record entered you could use something like this (not tested) with recordsetclone .movefirst currentdb.execute "UPDATE myTable SET identifier="something" WHERE UserFK=" & !userFK & " and recordPK>=" &...

Wouldn’t that be the userid, perhaps with reference to the condition?

Perhaps use a function called by the query to retrieve the in memory data

Somewhat out of date - message count is about 800 down

Another option (but more work) is to create a bespoke combo using a textbox and a continuous form that looks like the dropdown. Has other benefits such as being able to use colour and/or richtext in the dropdown

Possibly - what happens with a form that has no code?

I presume your firm is open but hidden. Have you got code in your other forms triggered when they close to set focus or reference that form?

took a quick look at the changes required - if the OP meant what you think they meant, i..e. then see attached - had to modify the query filter slightly to cater for nulls

Agreed, but this is what the OP asked for and provided an image to illustrate and the solution is based on that Not all previous fields If there were three consecutive fields with the same value, the 2nd and 3rd would be highlighted. But easy enough to fix in the function - extend the static...