Recent content by getting balder

Hi, please can someone help with what I think should be quite basic but I cannot find the answer yet! I have a report (a letter) which opens also with a form that has an unbound text box for adding free text (letter content) to the report. (unbound text field set to the forms text box control)...

Hi, Does anyone know how to force a date field, that is formatted to a day of week number (w), to sort by number? The underlying field is still formatted as a date and therefore ignores the returned values of 1 - 7! I am trying to display a report, by page from Monday through Friday. S'ok...

Seriously, thanks!

:D :D :D :D :D :D :D :D :D :D You star! A BIG THANK YOU I would never have found that in a million years. Don't know what it means but it seems to work! 3 days of work (or lack of) is ended. Cheers

Hi, thanks for getting back to me - didn't understand from your link.... I have got the following code where the Me.Text21 is the Date box updating from the Calendar6 control. I also tried it directly using Me.Calendar6.Value but the prob remains! : Private Sub Calendar6_Exit(Cancel As...

progress - slight but sure. Have noticed that the date of 11 December shows up when link criteria should be 12/11/2006. (thanks guys - you were spot on!) It is definitely to do with the us/uk date thing, but can someone help with the actual coding to resolve this? I have not come across this...

and where do I stick the 'as format(mydate,"long date") ' you mentioned? (Clean answers only please!)

Have just tried changing dates to long date, but seems to makes no difference. The stupid thing is the form works without the filtering... And I have tried using different techniques for opening the form, but it always fails in these particular dates. I think it may be the ambiguous ones so what...

Sure, worth a try, thanks. Now I have to remember how!!

Don't think so as it works for some records and not others!!....

:mad: and tearing out my hair with this one... Someone out there please help: I have a form that should open, linking to the date on another form (that is changeable using a Calendar Control), and display records for that date. My underlying data is available for a variety of dates but some...