Search results

doesn't matter - a form does not have to have a recordsource. It can have unbound controls or controls bound to a calculation/function such as dcount. And as Arnel shows, you can assign a value to a label or button by assigning the value to the caption. The potential problem with having...

Given this has come about as a result of UK law, I was going to suggest ‘the speaker’ as in the speaker of the House of Commons- the person who slaps down inappropriate behaviour of MP’s

Perhaps you should also clarify what you mean by access procedure - a specific sub or function? Doing what? Is access split? If so where and what is the back end?

Why use a subform in the first place? Is the idea that it expands if the user clicks on it? Why not use a label or button? - I do something similar to show certain data and use color to indicate current status. Eg red might mean invoices to be raised or paid - user clicks on the label/button to...

Good point

An alternate to majp’s suggestion Select qryActiveUsers.* from qryActiveUsers left join TblAssignedExaminers on on qryActiveUsers.userid= TblAssignedExaminers.userid where TblAssignedExaminers.UserID is null

What if you have more than 32 pictures? And is the table one with 32 columns or so, one for each picture. Or more normalised with 32 rows ( however many actually required) of one picture each? Given you appear to have a denormalised setup as an alternative to the transparent button suggested...

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