Search results

Try the following: =IIf([ACCURACY]>="89","MEETING","NOT MEETING") if this does not work then set it up in your underlying query as a new field and reference this field as your control source in your report, as follows: NewFieldName: IIf([ACCURACY]>="89","MEETING","NOT MEETING") Good luck [This...

Try the following Event Procedure on the Double Click: Private Sub Details_Click() DoCmd.OpenForm FormName:="ReservationForm", WhereCondition:="[ReservationID] = " & Me!ReservationID DoCmd.Close acForm, Me.Name Forms![ReservationForm].SetFocus End Sub Change ReservationID to your...

Depending on how you have set up the various report/subreports, you could set a page break to occur before your subreport, thereby making it run on a new page. Another option would be to set the final subreport into the main report "Report Footer" section with a page break to occur first...

The fastest way to accomplish what you want to do is to create a letter/report outline within Access and merge the fields within the report where they are to be. The one thing that has to be remembered is that each section with embedded text should begin with an =" and end with an " Embedded...

I would suggest increasing your ram to minimum 64mb. Depending on the size of your database and the number of background programs you have running, you could keep hanging which could ultimately corrupt your database.

Check to see that you don't have a page break inserted. This will cause a blank page at the end of a report. If you require new pages for a report section, use the Grouping and Sorting option.

What you can also do is set the form to maximize on load and make it a pop-up.

Open your report in print preview and then adjust the page settings. Save. There is a bug in Access 97 that still has not been corrected in Access 2000.

Have you set your second form to be pop-up also.

The following should work for you: Place the first coding as an Event Procedure in the On Not in List in the properties for your CustomerID Combobox: Private Sub CustomerID_NotInList(NewData As String, Response As Integer) MsgBox "Double-click this field to add an entry to the list."...

Combo Box 1: Create a query which the user can make a selection. Combo Box 2: Create a query that links on the many to one side, with the many being the record source for the second combo box. In the criteria field for the one side, place the following: [Forms]![FormName]![ComboBox1Name] In...

Go into your forms property and set the "Cycle" to CURRENT RECORD only.

Excuse me, I didn't read that it was on a continuous form. For this to work, your SubProjectName should only be on the continuous form. Your main ProjectName field should be on the main form or else an additional subform which references the 2nd subform which is continuous.

Create a control button on your form Called Delete and place this code behind it on the "On Click" as an event procedure: Private Sub Delete_Click() On Error GoTo Delete_Click_Err ' Deletes Current Record Shown in Form View from Active Tables DoCmd.RunCommand acCmdDeleteRecord...

Make sure that your properties "Cycle" field for your subform is set to All Records instead of Current Record. This could be your problem.

Is your recordsource for your subform a query and is the date used as a parameter within your query? If so, then you must create an additional field within your query referencing the date field and use this new field in your subform. Set the new field to the sorting requirements that you want...

You require an outside help program such as Winhelp. The Access Developers program also enables you to build help files for your database.

Make a command button on your main form and call it save. Put the following code in its On Click Properties: Private Sub Save_Click() On Error GoTo Err_Save_Click DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70 Exit_Save_Click: Exit Sub Err_Save_Click...

The only way that I know to accomplish what you want is if you do make a subform to handle just the lookup field. Embed this subform within your main form and click on the window of the subform to get its properties. Set the Special Effect to Flat, the Border Style to Transparent and the...

Is your total the only field on your 2nd subform? Why not just have a total field that automatically calculates on the 1st subform, that way you don't need a requery method.