Recent content by BTSTeam

I wonder if it is a matter of timing. An on-demand subreport has not been run when your main report is being viewed. The main report it doesn't know whether the subreport is blank until it has been run so it cannot chose whether to suppress the subreport. If the subreport is not "on demand"...

Are you thinking of Conditional Formatting? (Right-click on the text box and select "Conditional Formatting") Andy

Maybe something in the GotFocus event, like: Private Sub ComboName_GotFocus() If CheckBoxName = "True" Then ListName.RowSource = "0,25,50,75,100" Else ListName.RowSource = "0,25,50,75" End If End Sub (With the control RowSourceType property set to Value List)

Select the properties option for your input (text) box. In the 'Data' tab click the 'Input Mask' box and then click the three dots "..." button to open the Input Mask Wizard. Click the 'Edit List' button and add the input mask as 00000-00000. The zeroes mean a compulsory digit must be added...

If you want digits in each of the ten character positions then I think you've already got the input mask - use "00000-00000" when you set the input mask for the field on your form and make sure that you chose the option to save with the dash.

Check out the DoCmd.SendObject command.

You could use: docmd.OpenReport "report name",acViewPreview

In the Chart Options under Axes you can choose to display two sets of data (if you have two data value sources in the Data area of the Chart Expert) and have separate Axes scales for each. Is this the sort of thing that you need?

So your code checks to see whether LocationID is blank, gives the user a warning, puts todays date in [BookingDate] if Location ID is blank and then carries on with the Update action which it cannot complete because a field is blank. I think you need to be able to jump out of the Sub and abort...

My installation of Access 2003 always does this but I only see the one I want to work on because the window is maximised so it is not a problem. The other code windows are hidden beneath.

Assuming that [txtCriteria] would hold the start date of the date range, you could have a hidden text control on the form which is only made visible and receives focus if [cboType]="Call Date" which would be used to enter the end date of the date range. In this case you might need a separate...

Excellent - just what I needed. Many thanks, Andy

Hello I am using CR XI connected to a SQL database. I have a dynamic string parameter which uses the DESCRIPTION field from the POINT_OF_CONTACT table as its data source. The POINT_OF_CONTACT table also includes the STATUS_ID which indicates whether the DESCRIPTION is current or unused. I...

I can't replicate your problem. I get two decimal places in both instances. Is there anything else in the data or formatting that might account for this?

You might be able to use DoCmd.PrintOut instead of RunCommand acCmdPrint I haven't tried it myself so not sure whether it will do what you want. Andy