Search results

The simpliest way to accomplish what you want to do is to use a Page Footer instead of a Report Footer.

I was waiting to see if someone else had a suggestion for you before I gave you an option that you can try. My way of resolving this problem is to open the properties of the graph and in your recordsource, add the additional fields that you want included. The graph will now display these...

Create a Header to contain the field that you want groupings on. Select this to sort Ascending with Group Header = Yes, Group Footer = No, and Group On = Prefix Characters. For example purposes, I will use CustomerName. In the header, create a text box with the following...

Instead of having a Course ID field set up in your tables, which is a combination of information already contained within 2 fields, set this up in a query. Have the recordsource for your form a query. In a empty field within that query, make a new field name called CourseID. Set this field to...

Make your combo box and unbound combo box not related to your forms underlying record source. Set the record source for this combo box to your query and that should do it. Good luck.

Create a Dialog Box with an unbound Text Box. Name this text box "JobNumber". In your query in the criteria line for your Job field, insert the following: [Forms]![DialogFormName]![JobNumber] You could also do this by having a combo or list box that displays all entered jobs. It would be set...

You could try the following code in the "Activate" of your form: Private Sub Deceased_Activate() On Error GoTo Deceased_Activate_Err DoCmd.Requery "Deceased" Deceased_Activate_Exit: Exit Sub Deceased_Activate_Err: MsgBox Error$ Resume Deceased_Activate_Exit What this does is...

Go into the properties for your combo box and set the column widths to hide the primary key and only show the name field. Example: If your first field is the primary key and your second field is the name field, then your column widths would be as follows: 0; 1; and so on. This way the first...

What does your button, when clicked do. Perhaps if you showed the coding.

Sometimes when converting or copying gremlins can appear in code even if it is compiled. What may work on one form, presents this error message on another even when things appear correct. The only solution I have found is to delete both the button and the code behind it and create a new button...

In the criteria line for your Printed field in your query, just state "Yes" this will return all records that have been printed. [This message has been edited by Carol (edited 06-28-2000).]

Your recordsource for your form should be the query that displays all fields that you want populated. Your combo box should be an unbound combo box with its source set to either a sql or an underlying query that you can obtain the "Cost Rate" from. Use the column widths and bound column of...

This query is the recordsource for your form. There is no code required here. Put the code I gave you in the After Update of the combo box. Once you select an account, the cost rate, along with all fields will be automatically shown on your form.

Refer to today's reply to READY TO LOSE IT!!! Good luck

Put the following code (as an Event Procedure) in the "After Update" of your combo box: Sub Account_AfterUpdate() ' Find the record that matches the control. Me.RecordsetClone.FindFirst "[Cost Rate] = '" & Me![Account] & "'" Me.Bookmark = Me.RecordsetClone.Bookmark End Sub Change...

The code for the tab on-click is still present in the code for your form. Go into your form in design view, click on code and remove this coding only. Good luck.

Go into the properties of your subform and change the cycle to Current Record only. This should help.

Set the auto center to no and adjust where you want the form to be displayed in design view. Save the new location while still in design view. Good luck

To help with your first question, the subform must contain a link to the main form. Open up your form in design view and check to make sure that the parent and child links have been set. Good luck

Another easy way to accomplish this is to add this in the criteria line of the field Unit Rate in your query: [Forms]![JobCosting]![Description] As long as your query is set up with the correct joins this will automatically update your Unit Rate depending on your description that you have entered.