Search results

In my calendar solution, the criteria for each instance of the subreport is provided by the link master/child. There is a sample in the calendar example at http://access.hookom.net/Samples.htm.

I have created a calendar report based on a query with unique Sunday values only. I added seven text boxes across the width of the detail section and added 1, 2, 3, ..6 to the Sunday in the control source like: =DateAdd("d",1,txtSunday) I named them Date0, Date1, ... I added the same "day"...

I don’t recall having set a format in the query since formatting can easily be set in a control on a form or report.

Some environments don’t allow access to files in the root directory of C.

Don’t use strings in DateSerial DateSerial([Forms]![BankTransactions ]![ComboYear],1,1)

Can you enlighten us regarding the fix?

I believe this was recently discussed in this thread.

Your assumption is numeric 😁. If I was less lazy I might try use the words “value of” or other testing.

Len("9.11") > Len("9.9")

You can use a union query as the row source from your combo box. SELECT 0, " Add new client" FROM tblClients UNION SELECT ClientID, ClientName FROM tblClients ORDER BY 2 Edited per @Gasman’s catch.

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 (?)...