Recent content by DHookom

I asked for a query with "User/client, Standard Action, Challenge/Day Type, Date, and the numbers displayed" and you provided a query in post #88 with User, Action, Loop, WeekNumber, Index (?), StartTimeAchievmentDays (?), StarTimeEngagementDays (?), ActivityAchievementDays (?)...

Do you have any “save” code in your form/subform? I don’t recall ever experiencing a row height saving after closing a form.

For the same reason @Ken Sheridan limits value lists to immutable values, I rarely use Yes/No fields. I have run into too my projects where values aren’t that black and white so a “kinda/maybe” needs to be added as a choice.

I expect the subquery with the TOP 1 could be replaced by DMax(). If there are a large number of records, this would be very inefficient.

I would try remove this section of the query ( SELECT TOP 1 A.SalaryAnnual FROM tblSalary AS A WHERE A.IDSalary < tblSalary.IDSalary ORDER BY A.IDSalary DESC ) AS PreviousValue, [SalaryAnnual] -...

If you want to maintain referential integrity between your tables, they need to be in the same ACCDB file. You must also consider the combined size of all the tables since Access has a size limit.

Doug Steele has a more complete age calculation function.

The path is a folder, not a file.

I suggest you review this thread about saving records in a bound form.

I have mapped a folder on my drive as a hard drive using instructions like this. Then add any required subfolders and place your back-end there to relink. This creates a similar environment.

Each user should have Access untimely installed and their own copy of the front-end file. The f-e must be in a trusted location.

So the paper isn’t perforated or scored since the printer has a “scissors” or blade that should make cuts after every label/record. Sounds like you need only set the paper size to the proper dimensions and match this with the detail section size.

I’m trying to understand what you mean by “make the cut”. Does your printer have some type of blade or are you talking about spacing or grouping in your label report?

Does it make a difference if you change the order of the files in the processing cue?

I will use Column Headings to create daily, weekly, or monthly totals for the past ten units. For example in the Northwind, to get the last ten days of sales by salesperson, use this SQL which looks at the txtEndingDate. TRANSFORM Sum([Quantity]*[UnitPrice]) AS Expr2 SELECT Employees.LastName...