Search results

You can’t set focus to a number of control types including image - look a a controls events- does it have got/lost focus events? Clarify my questions in post #2 and I might be able to offer an alternative suggestion

Just to clarify - you have one detail section with 32 image controls? Or a detail section with one image control and 32 rows? Where are the images coming from? Attachment? File name in a field pointing to a file on disk? Something else?

the problem is you say and which implies whatever the message is, it is not important and it doesn't matter if nobody receives it. and to be clear - sql server uses smtp to send emails and unless you log the send into a sql table as part of creating the message the message is not tracked...

I think the OP means whilst editing the date by the user typing it in. If that is the case, then also look at applying an input mask - the format property only applies to presentation and hides the actual underlying value

told you :) @amorosik - what is your objection to polling? What is the real life situation you are trying to solve? Provide a real scenario where polling is not an option.

my guess would be that the OP will say that outlook is polling the email host for new messages. You could use python or C# to poll the email host regardless of whether outlook (or access) is open or not and send a message to the systray. But that is still polling. SQL server has the ability to...

The issue is vaguely described in terms of ‘what happens next’ (user might have access open , might not, user might be away from desk, might not, users machine might be switched on, might not, might have a requirement for immediate action, might not, user might be using access, might not, the...

Other thread deleted

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?