Replies

Charlotte

Your reply seems to have got lost, but here’s some more info :

My SQL was :

SELECT Sectors.TechLogNumber AS TLP,
tblAircraft.Registration AS Reg,
Sectors.[Actual Departure Date] AS [Date],
[Sectors]![Departure Airport] & “-” & [Sectors]![Arrival Airport] AS Route
FROM tblAircraft …etc

In the comboBox header, the 2nd column appeared as “Aircraft Registration”, which is the Caption field in tblAircraft for field Registration, and not as “Reg”, which was what I wanted to see.

HTH

Nick

Not quite. I have several levels of folders & I keep them in collapsed view, because if I expanded them all, it would take up most of the screen. Also, if the Rule moves the email to a sub-folder, only the sub-folder appears in bold, not its parent folder. It’s not a show-stopper, but it is an annoyance.

I thought that Access only stored the actual number of characters in the text field. The actual length of the field is stored as a 1-byte overhead. So the maximum length is an indicator only.

Bart

I did indeed try out DAW’s tip. I imported all the objects into a new database, re-compiled & re-installed. On the test PC it came up with run-time error 3071 “The expression is typed incorrectly, or it is too complex to be evaluated”. The problem is still with the original query. Here’s the SQL for it :

SELECT DISTINCTROW tblUpdate.Updated, tblUpdate.Day
FROM tblUpdate
WHERE (((tblUpdate.Day)=format(Now(),”dd-mmm-yyyy”)));

The ‘funny’ thing is the app works perfectly on a PC where Access 97 has already been installed. It’s these little things that really make your day, don’t they ? (Not)

Nick

Thanks, but I’ve already been down that route. The wizard shows all references are fine.