Recent content by 10sectom

Forget this one, guys. It is a printer problem.

I have a report that has printed perfectly until now. I have made some format changes, none of which were to do with the colours, and suddenly the report is printing out using the wrong colours. The background colour property is correct (gray) and it displays the correct colour on screen and in...

I am using the following in a Query expression to give the day of the week e.g. Monday, Tuesday etc. Format([Arrival],'dddd',1), where [Arrival] is a date field with a standard Date/Time data type Is there a simple way that I can modify this so that the result is Lundi, Mardi etc?

Bob, the data type is Yes/No. I have solved the problem by putting the iif statement into the Form query. But I remain puzzled as to why it does not work when embedded directly into the Form. Thanks for your help.

Thanks, Bob. But no dice. fyi, the [Cancelled] field is in the Query that feeds the form, and the values show correctly when the query is run. The IIf statement is only in the Form itself. At first, I found the IIf statement only worked if the [Cancelled] field was dragged onto the Form, which...

Thanks, Bob. Here it is: =IIf([Bookings].[Cancelled]=True,"Réservation annulée Cancelled Booking","Confirmation de Réservation Booking Confirmation")

I have an Iif statement on a form which results in a text string if a Yes/No field on the form is set to "True", and an alternative text string if "False". But whenever I close the application, on re-opening the field displays the #Name error instead of the text. The only way I can fix it seems...

I have been using access to develop applications for many years. I am self-taught and by no means a programmer. I can do most things within access, but get stuck whenever VBA is involved. I am a little rusty, though, so I have joined to get some help when things don't behave as I would expect...