Search results

Maybe I should have used the term gotten lazy?

Yeah I understand. But, I'm 66 years old. 25 years-ago I would've worked on it. 25 years ago I several access books on Access. It's daunting for me. I've gotten a bit complacent.

OK. Got it. Thanks much, James

That seems to have done the trick. As far as differences between the old and new, (forgive me if I don't use the proper terminology) The WHERE clause is different. WHERE Dupe.Reminder as opposed to WHERE Dupe.ReminderID. AND instead of greater than/less than. Not sure what the term for DUPE...

Yes. Exactly. How did you accomplish this?

Didn't help. I'm assuming you changed the schedule for my first 3 records on the subform from Mon to Sun?

Here's all the records in tblReminders. Only difference is that in my working db the tables would be linked as apposed to embedded. The first 3 records in fsubWeekleyAgenda are scheduled for Mon Sep 27.

I spoke too soon. It still isn't sorting properly. It's putting Bu... before Ba...

It seems to be ok now. Not sure why it didn't work when I applied the Reminder sort. Also, in my upload I deleted many of the records in tblReminders and left only reminders within the next 6 or 7 days. The tables in the upload were imported directly (not linked). When I opened theDBguy's upload...

Yes. But when I add the sorting to Reminders it looks like the above screen shot. Gasman, change the for the date field to what?

When I sort by Reminder on my app it looks like this:

My subform doesn't sort the way I want. It was created with much help form this forum. To make it easier for me I attached the pertinent objects. As you can see the subform fsubWeeklyAgenda orders by date fine, but I want to order by the Reminder field also. You canb see this in each days list...

Sounds good. Haven't done much in Conditional Formatting. But this all works the way I want.

Actually, no I don't.

Seems like alot of code for just setting the forecolor so they are invisible.

Been using the new Weekly Agenda for a few days now and I just wanted to reiterate how happy I am with the results of your assistance. Looks like it took a lot of time and effort for you to get this to work the way I would like. Thanks again, James

Ok thanks. I'll open the original. Thanks for all the help it is appreciated, James

So far so good. One thing though and it's not that important. When I place the Reminder field below the ReminderDate by Day the space between the rows are large. As you can see here. I can keep it with one row.

I've been putting the shingles vac off. I can use a darker color for the borders.

I did like the clean look. I was unable to resize it properly in Paint. I don't go from Sun to Sat. Tomorrow the first day will be Monday.