Search results

You already have a document type field. I’m not sure if you could simply categorize the document types.

I wasn't aware of this. I had met him at an MVP Summit.

IIRC, seek doesn’t work with a linked table unless you use the remote DB rather than currentdb. You could also test and report back 😉

Did you attempt to compile your code? There is "Option Compare Database" twice in Module1. I also get an error "Method or Data Member not found" on this line. Set lbl = frm.Controls.Add("Label", ctrlName, True)

Compile error with Compare database and mouse clicks/key presses seemed to do nothing.

Do you have any code in the Open event that moves to a new record? I just created a continuous form using the wizard and it opens to the first record requiring me to scroll down to get to the last or a new record.

Inventory in a table would need to be refreshed regularly. However I wanted to create a snapshot of all my files (mostly images) to look for duplicates across multiple hard drives. I asked AI to write the code for me. I just added the ability to store the file type based on this thread. Sub...

What do you mean by “index”? Do you simply want an inventory of file names with specific extensions?

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.