Recent content by MarlaC

Your table structure is not normalized. Type should be a field in tblEquipment, and the primary key for tblEquipment should be a foreign key in tblUnits. Your current structure is not doing you any favors.

Were those events for the form, subform, or one or more of the fields? I would suggest having that in both the current event for the main form and the After Update event for the [Amount Paid] field on the subform (modifying field references accordingly) and see if that does the trick.

Agreed. That's why I clarified "tool add-in", as it's definitely not a control.

Change your subform source from this SELECT PublicComplaints.Route, Count(PublicComplaints.Route) AS “NumberOfComplaints” FROM PublicComplaints WHERE (((PublicComplaints.DateProcessed) Between [Forms]![DateSelect]![txtStartDate] And [Forms]![DateSelect]![txtEndDate])) GROUP BY...

What is the purpose of automatically generating records with no value? What is your goal by doing this?

If you can post the SQL that provides the recordsource for your subreport, we can modify it to contain the fields you need to add. You need fields in the query, not additional queries.

Make sure that your subforms either have Master/Child linked field relationships set or default values set for any required fields that you won't have users directly entering values for (foreign keys, etc.). For any fields involved in the master/child linked fields for the subform, you may want...

I don't use any third-party controls (although I did use an ActiveX calendar control before that was made part of Access), but I do use a tool add-in, MZ-Tools. I have found it very valuable, especially with inserting my custom error handler.

DSum won't get you a running total but a total per grouped field (Payment Type, presumably). You might want to look into using a totals query with a subdatasheet, though I'm not sure that will get you exactly what you want.

Looks like that ought to do it! Thanks for following up with your solution.

You're welcome! I've had to do something similar before and know how important it can be to protect 'set' values from being changed. I'll be happy to help again in the future if I can.

When you removed Group By, what did you change it to? It should be Expression, as should all calculated fields and domain aggregates that aren't using the query's built in Sum, Max, etc. Also, when you use strings as criteria, as in MinDate: DMin("[OrderDate]","Items Ordered","( [CustomerID]="...

I understand what you're asking now. The answer is that is a Windows function and will affect most Windows applications. It cannot be done within Access.

Shouting!! is impolite. Demanding is impolite. People here are helping without being paid for their time. CJ_London is being very helpful. Saying "merci" goes a long way. You could also achieve what you are trying to do by running the Replace function in an update query on your data after the...

I think, then, that Private Sub Form_Load() If DCount("*", "[TblUsers]", "[EDIPI] = '" & Me.Text59 & "'") > 0 And ([tblusers]![AdditionalDutiesRosterAdmin] = Yes) Then CmdAddRoster.Visible = True Else CmdAddRoster.Visible = False End If End Sub should be Private Sub Form_Load() If...