Search results

Why is this the only form doing this?? Why does it retrieve all when I select the second row in the datasheet?? One more thing I failed to mention. When I set the Split Form Orientation to top, bottom or right, the number of records displays properly.

214 records

I have a split form with the datasheet on the left. This seems to have been an ongoing issue with the Navigation Buttons at the bottom of the form not displaying the number of records. This is occurring now only on one form but in the past it was happening om all my split forms. Why only this...

I wouldn't care for that, :(

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