Search results

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

You can always add some simple VBA code to loop through the unique departments to build your crosstab SQL statement. I do, however, reserve the column headings mostly to date related values since most of my crosstabs are record sources for reports.

I would create a query with this SQL to show all your import/export specs SELECT MSysIMEXSpecs.SpecName, MSysIMEXColumns.FieldName, MSysIMEXColumns.DataType, MSysIMEXColumns.IndexType, MSysIMEXColumns.Start, MSysIMEXColumns.Width FROM MSysIMEXColumns INNER JOIN MSysIMEXSpecs ON...

From my experience, parameter types are NOT always required when referencing a form control in a crosstab query. Setting the column headings should remove the requirement. This of course will only work when the column headings are known, static values like months, days, numbers,etc. for...

You can’t post URLs until you have posted 100 times. This includes replying to a post that includes an URL. I used a lot of posts welcoming new members 😁 to get up to 100.

I would change the SQL of a saved query in code just prior to opening the reportUrey would be the record source of the report and would filter as desired