Search results

It seems it can't compare 11/10/2002 with 11/10/02, even whan I enclose both values with "#" to say it's a date. Dates just don't make sense to me.

Nope, neither of these work. I've even created a new blank database to try it out, and it still won't match the two values. Is there no other way this can be done? Thanks for trying anyway. Tracy

I've tried this but it still won't work. An other ideas?

Hi, PLease can anyone tell me why the following code won't work: dim rs as recordset set rs = Me.RecordsetClone rs.FindFirst "TestDate = " & Me!txtFormDate TestDate: a field in a table of date type txtFormDate: a text box in a form bound to a field in a table of date type There is a...

Hi, Is there any way I can output records in a report in the order they appear in the datasheet view of a form? basically, my users want to randomly order the records in the order they chose. So they just want to insert records in various places etc.. My table orders by primary key, so can...

Wow! Thanks v much Doc Man!

Howdy, Does anyone know how to change the font colour in a field on a form or in a report depending on a criteria. So what I want to say is: If fieldvalue < 0 then 'change font colour to red End If. Hope someone can help. Thanks

Do as RichB says, but before shutting down the Grouping and Sorting Box, set the field 'include group header' to 'yes'. Then put the name field in the group header section which now appears on the report, leaving the details for each name in the detail section.

Does anyone know how to output a report to any file type (so long as it can be attached to a mail) without losing any of the border formatting and keeping the columns in line? ideally this would be possible in the code so that no manual saving would have to be done. SendObject and OutputTo...

Note that the SendObject and OutputTo methods lose most of the formatting of the report. Columns are thrown out of line and any borders etc. are all lost. Even when you do it manually through File->SaveAs/Export and save as rtf loses the formatting, only less. There is an tool called Snapshop...

Note that the SendObject and OutputTo methods lose most of the formatting of the report. Columns are thrown out of line and any borders etc. are all lost. Even when you do it manually through File->SaveAs/Export and save as rtf loses the formatting, only less. There is an tool called Snapshop...