Search results

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...

Also, you may want to add a True/False field to your table that is updated to True when the value is changed, if there are cases where the calendar date may change but you don't want the other date to change again.

You might also want to compare OldValue with NewValue before writing your date.

Assuming you mean a form or forms in your database, yes, through the forms designer (design view, usually in the upper left corner). If you mean part of the Access application itself, you can change colors and fonts through the Windows interface settings.

Here's one way that might work: 1. Create a query with your order header and details tables linked, with criteria on the order date field where order date <Date() and >Date()-7 (or however many days you want to check against). 2. For each order you cycle through in your import, check customer ID...

In the query which is the recordsource for your report, create calculated fields for each portion of the date that you need to sort by using the DatePart function. Then use the Group and Sort part of the report designer to group and sort on those fields.