Search results

Do you mean between 10 and 50 records?

The clue was in the click event signature in Post #1 ! At least @disgracept uses useful object names! (y)

See: Post #14 Post #17

It is the image. I placed an image and a button on a continuous form, each with a click event to MsgBox the record ID. Clicking image only picks up the ID of the first record, whichever record is clicked. Clicking Button shows correct ID as expected.

Try placing a transparent button over the image and use its click event to run the open form code.

Are you sure? The second argument (View:=acNormal) is present, and Where comes two after that.

Yes, perhaps image control can't receive focus, so it isn't changing the current record

Try it with just: Private Sub img_VerImovel_Click() DoCmd.OpenForm "frm_VerImovel", acNormal, , "Imovel_ID = " & [txt_ImovelID] End Sub

What does this mean?

How many records does QryJsonPos001 typically return?

What happens if DaysLeft = 0 ? I guess you could also use: SELECT t.Status, COUNT(*) AS [Count] FROM ( SELECT IIf(Days left >= 0, 'Valid', 'Invalid') AS Status FROM AllDeliveredQ ) t GROUP BY t.Status ;

One thing to double-check: With table [Date calc] in design view, what datatypes are DueDate and DatePaid ? Or if [Date calc] is a query, what is the SQL of the query?

Follow my instructions in Post #17. If you don't know how to do it, then let us know.

Switch you query to SQL view. Copy and paste the SQL here. We can show you the corrected SQL. Then you can paste it over the SQL of your query. Then switch back to query view and you will see how it is constructed by Access in the query designer.

With [Expr1], you are comparing with a string instead of a number. Try: Expr1: IIf([Days]>4,"Yes","0")

See my post above - please post [Expr1]

We need to know how [Expr1] is calculated (ie what is the expression). Since you are coercing to a boolean, if [Expr1] returns any value other than 0, then it will coerce to True ("Yes"), even negative values. In Access/VBA the value of True is already negative (-1).

You missed the point of 'the three generations of a family'. That is purely to describe the relationship between the tables employees, enrolments and cafeterias. There are no actual grandfathers, fathers or sons. It is a [mis-]translation of parent table / child table / child of child table.

Please share your final solution. It will help other users here who may have the same problem.

It would help if I could read properly! 😬 Glad you worked it out! (y)