Search results

Yup, that was it! Don't get old. Thanks much, James

I'm trying use a combo box based a lookup table to filter records on a continuous form. I also in the combo box have the "All" choice to show all. I'm using this same procedure to filter records in several other of my forms. In fact I copies and pasted the Row Source to the ne combo box and...

Ah. I see. I'll utilize it. Thanks much, James

I pasted the Iff statement to the Detail's On Paint. I kept getting the object doesn't support the property or method. Every time I closed the error it popped up again. I had to close Access from the Task Manager. BTY, I misspelled again and the new bound textbox conditional formatting does...

I added a text box to the table and placed it on the form. I created 2 rules using conditional formatting one for 1 (calendar event) and one for 2 (task). That doesn't work either. Very confusing.

ReminderTypeID is a number field.

Didn't help. And, what are text delimiters?

Not for the current record. For all records in the continuous form.

I fixed the spelling but the same thing: If [ReminderTypeID] = 1 Then Me!lblReminderTypeIndicator.BackColor = vbRed Else Me!lblReminderTypeIndicator.BackColor = vbGreen End If I placed the ReminderTypeID on the form and it shows 1 for Calendar Event and 2 for Task.

I put the following in the On Load of the form but the color stays green: If [ReminderTypeID] = 1 Then Me!lblReminerTypeIndicator.BackColor = vbRed Else Me!lblReminderTypeIndicator.BackColor = vbGreen End If The 1 is the ReminderTypeID value linked to the lookup table In the relationship.

I have a reminders table for appointments and tasks. There are 2 types of reminder: calendar event and task. In a continuous form based on reminders I want to display a control that displays 1 of 2 icons depending on whether the reminders is a calendar event or a task. I'm not quite sure how tro...

Sorry, I meant Column.

I narrowed one of the rows and it reappeared. It's a split form... I guess that's all that needs to be said.

I made some minor changes to a split form. Now, a filed magically disappeared form the datasheet. When I right click on the headers and bring up the 'Unhide fields', the field is checked. Meaning it should be showing but apparently access doesn't know it. Any ideas??? James

I have another issue. I have the Backstyle set to transparent The fore color is set to white and the pressed fore color is also set to white. O set the hover fore color set to red so there is no mistaking. After clicking the button I still don't get the hover fore color but, the pressed fore...

I thought the 'Hover Color' is the background color, and 'Hover Fore Color' were two different things. 'Hover Color' is the background and 'Hover Fore Color' is the color of the text.

Access 2010 Windows 10 The hover fore color on my form's buttons doesn't fire when *i have the buttons back style set to transparent. Changing the back style to normal, it's fine. If this is normal, Why? James

I created a Continuous form and used Dsum on a field in the form's footer. Works fine.

I sort the data by date so if I change a date I need the form to reorder. When I use Me.Totals.Requery the 'Totals' data member isn't found.

The form has records that are date specific. The refresh works ok, as far as the Totals value disappearing. How would I requery the Totals? I created it on the split form using Total-Sum.