Search results

Without writing code to care take of all the numerous different maximum fields to enlarge the page header, try using the report header. This will allow you to set your properties to Can Shrink/Can Grow depending on the field size contained within. Just highlight the line that says Report...

You would have a text box already in your form with its visible property set to "No". Once a condition is met, it will set the visible property to "Yes" ready for input. Try the following: Private Sub Status_AfterUpdate() If Status = Closed Then TextBox: CloseDate.Visible = True...

Use an If Statement in the control source of your text box to get the results you want. Set up a hidden text box called PriorityName with the following: =IIf([Priority]="2","Red",IIf([Priority]='3',"Yellow","Green")) Then set up a visible text box and in its control source reference the above...

The easiest way to accomplish this is by doing it through a query. For each check box, make an additional field within the query to hold the text answers, as follows: CheckBox1: IIf([CheckBox1]="1","Autism") Then, create an additional field within the query and cancentrate all the CheckBox...

This has been answered numerous times in this forum. The following code, when placed behind the On Click of your Print command button will print out the current record shown in your report. Replace the names of the form, report and command button as necessary. Private Sub...

Unfortunately, you cannot change the formatting on continuous records in a form, but you might be able to overcome that by selecting one or a few fields that you can format depending on the selected criteria. Open up your form in design view and click on the field that you want to format. Go...

Go into your form in design view and click on the 2nd page tab. Click on the form and it will bring up the properties. Make sure that your Parent and Child field links are both set to PatientID. If it is not, then set it. This is where your problem is. Good luck

Go into both your query and your form's properties and set both the Recordset Types to Dynaset (Inconsistent Updates) Good luck

Go into the design view of your chart and click on the actual chart area and then open up the properties. You will receive options, use the Chart Edit Option. You can then set any options you need through this. If you only want to change the legend, click on the legend itself and this up open...

You could try the following: =IIf(IsNull([LinkIDField]),0,DSum("[txtSubTtl]","QueryNameforSubform","[LinkIDField]=" & [LinkIDField])) This will retrieve the information from your underlying query, since calculations are not stored. You might have to change your txtSubTtl field to the actual...

Go into the design view of your form or report, make change(s), view in print preview and save your form or report, then close. Next time you open, it should revert to the saved format. Good luck [This message has been edited by Carol (edited 07-19-2000).]

Refer to answer in todays posting question "Recordset not updatable" Good luck

To get around this problem, set the Recordset for both the query and the form to Dynaset (Inconsistent Updates) Good luck

You could create a command button on your form called New Record that when clicked would take you to a new blank form ready for input. As for the prenumbering, if you are using an autonumber field in your underlying table, then the next sequential number would be shown. If you are using a...

First, create a hidden text box that calculates the total time spent for the day. Call this TotalTime. Second, create a label called Warning with its visible property set to No. Place your warning comments in this box. On the After Update of the TotalTime textbox, place the following code...

Put the following code in the On-Click of your Preview button: Private Sub Preview_Click() On Error GoTo Preview_Click_Err DoCmd.Save acForm, "MyForm" DoCmd.OpenReport "MyReport", acPreview, "", "[IDField]=[Forms]![MyForm]![IDField]" DoCmd.Minimize acForm, "MyForm"...

If I remember, 2486 refers to running a DoCmd while a query is still running. Check out the coding used for your underlying recordsource. You might have to put in some error trapping to end. It appears as though you might be in a loop. Good luck.

Set your Close button to 'No', your Control Box to 'No' and your Min/Max to 'None'. Make sure that you have made a button with the close procedure on the On-Click. Good luck.

Go into the code in one of your forms, click on Tools, click on Options, Click on General, and then set to Break on All Errors under Error Trapping. Good luck

Here is another option for you. Private Sub TextBox_AfterUpdate() If TextBox = Yes Then TextBox: 2ndTextBox.Visible = True 2ndTextBox.SetFocus Else Me.2ndTextBox.Visible = False End If End Sub You must also set your 2ndTextBox Visible Property to "No" What this does is hide the second text...