Search results for query: *

Hint: Take a look at the AfterUpdate event of the option group and the OnCurrent event of your form.

My next attempt at trouble shooting would be seeing what results you get by simply entering the dates directly into the query (rather than using the values on your form) to help understand how the criteria is being applied by the query. It doesn't look like your problem is caused by any...

Looks like the query is interpreting the dates as text. Are the dates in the Excel sheet formatted as dates?

DoCmd.TransferSpreadsheet transfertype:=acImport, SpreadsheetType:=5, _ tablename:="QA_STATUS_REPORT_FINAL", FileName:="SomeExcelFile", _ Hasfieldnames:=False, Range:="test!A:F" Are you not trying to export to Excel? Something like... DoCmd.TransferSpreadsheet...

This an example of something I did using an option group to allow the user to select their own sort order... It does what you describe the user doing in your post, but their only involvement is selecting the option and clicking 'OK' Private Sub cmdPreview_IR_Under_Review_Click() Dim...

In simple criteria you can use UK style dates in the query grid eg #07/06/2006#, but if you look at the SQL view, Access will convert these to US format. Having said that, even though the example date is ambiguous, in my experience the query still returns the records I expect it to. To...

What you have looks OK to me. Are the regional settings on the PC correct? Have you tried hard-coding the dates in the Between ... And ... Criteria - Does that work OK? For what it's worth, I usually manage to get the 'DateSerial' (yyyy,m,d) function to get around date formatting issues if I...

When I say, what is the source of your report? I mean what is the property of 'Record Source' set to? ie what object did you select as the source for the report's data on the very first page of the wizard. It will be a table or a query. I suspect it is a query which when executed repeats each...

Sounds like you need to group your data - either in the source of your report, or by using group headers in the report. What is the source of your report? A table, a query? Is the reference number repeated in that?

Thanks very much - exactly what I needed. Just what I thought it should be except I didn't discover the 'totext' function in my searches of help. I had tried 'Format' which seemed logical to me!? Anyway, thanks for the very quick response.

Completely new to Crystal Reporting... I had a formula field to count incidents for a given section Count({incident.incident_ref}, {serv_dept.serv_dept_n}) This worked as I would expect and as the result will always be an integer, it was formatted to display without any decimal places. I...

To remove the blank area caused by sub-reports with no data, set the 'Can Shrink' property of the section (the Detail section I assume) where the sub-reports are placed to 'Yes'. Did the setting of the sub-report object to the default size help with the line splitting problem?

When using sub-reports I always set the height of the sub-report object on the main report to the 'default' ie select the object and double-click on the black box marking the bottom right-hand corner. This will size the object so that it corresponds with the size of the sub-report it is trying...

Not that I know of, though you can get a free 30 day evaluation. Your original post mentioned purchasing a copy of Acrobat 5.0 - I thought that insted of this you might like to spend the money on a current product rather than going back to old versions of Acrobat - I've only used it on about...

Everything Duane says is good advice and it would be worth 'normalizing' yuor structure. Having said that, if you wish to update your new field (just this once mind!) you could run an update query to set the value to 0 where it is currently <Null>. Something like... UPDATE tblMemberConts SET...

Try... CurrentDb.Execute strSQL, dbFailOnError + dbSeeChanges

Create a Snapshot or PDF of the report?

I have found this very useful for doing what you describe with just a few lines of code... http://www.groupacg.com/ACGPDF.htm I use it with v7, but it supports v8 too. Shame to waste your existing procedure but this does work well.

Conditional Formatting (Format > Conditional Formatting...) may do what you require, though using VBA with 'OnFormat' event is more flexible if you get into more complicated condition criteria.

The SQL of the query would be something like... SELECT Sum([TheRecordsouceOfYourForm].[YourField]) AS SumOfYourField FROM TheRecordsouceOfYourForm;