Search results

I didn't see it right away. I'm currently using a crude week view with 7 subforms and the dates across the top. Thanks again.

Is there a way to group by date? That was my aim. I can deal with the way it is.

Great! Exactly what I was looking for! I want to thank you for your time and effort. It is appreciated. I'm 66. 20 years ago I would have worked on this myself but I'm too lazy now. Again thanks much, James

I looked into a treeview and it's way out of my league.

I thought about a tree view. I'll look into it.

About a week ago we worked on a subreport on a form that persistently showed the unused part of the report. Most of it has been cleared but it still shows the unused part under certain conditions. The subreport has fields for reminders: ReminderDate, ReminderTime and Reminder. I click on the...

That worked. Only thing is if I inadvertently double click the area on the subReport below the detail it disappears except for a horizontal line. Close the form and reopen and back to normal.

Ah. I see the query was altered, Seem to work ok now. Although I don't understand the sql it worked. Thanks much for all the assistance

It's no different on the report. I still get the white in the footer even though I set the backcolor to blue. In fact, if I slide open the report width the white appears.

Ok. The current report I have set the report height footer to 0. In order to eliminate the white you must put the report in design view and drag the footer to about 5 or 8 inches.

Didn't realize I crossposted. Don't get old!

I also set the footer's Visibly property to No.

That didn't work. The report is based on a query the show events a week. I put the main form in layout view and pulled up until the white disappeared. Then I added a record and set the date to next Thursday. The detail section didn't expand to show the new event which I set 5 days from now. I'm...

I have a report I put on a main form. The report footer backcolor is set to the same color as the main form detail backcolor. Even if I set the report footer to zero it shows up as a white box. If I set the report footer to 5 inches it looks fine. I even set the report footer to Visible-No and...

I downloaded the Split Form emulator (EmulateSplitForm v3accdb.) It work fine but I had to change something and was wondering about this for some time. It's about whether to use a '.' or a '!' When I first pasted the code in from the On Load event and replaced the object names with mine, I got...

Ok. I wanted the ReminderTime to have the same conditional formatting and disabled. So I had to set the background to transparent otherwise it would display the white background it. Thanks much, James

Great! I never would have been able to implement this. Although I don't grasp what the code is is doing. Is it possible for you to summarize the code?

When I click on the reminder on frmDay1 you. can see the result. I could use the same background color for the reminder as in the form and the conditional formatting butt if I change color theme it would have as different color

I'm using a continuous form to display reminders. I set a Conditional Formatting rule for the fore color of the Reminder field based on the value of ReminderTypeID. If the value equals 1 then I want the fore color to be yellow.. The problem is Conditional formatting doesn't allow you to set...