Search results

That thing on the left side of the screen that displays the db objects ie: forms, macros, tables queries and modules. What should I have called it??

From a main form I open a form that is Popup=No and Modal=Yes. But, after I close the Modal form the navigation pane remains minimized. Any ideas?? James

Actually what I did was[lace a label next to the date field and in the On Current checked to see if the record's date value is =Date(). Seems to work ok.

I see now. I never thought of using Conditional Formatting. Thanks much

This is a form and the field is editable. I really haven't tried anything yet. I'm currently displaying "Today" using the IIF but I'm unable to edit the date if I want to: [CODE]SELECT IIf([ReminderDate]=Date(),"Today",Format([ReminderDate], "ddd mmm dd")) AS Expr1, * FROM tblReminders WHERE...

I'd like to get a date field to display "Today" if the value of the field is =Date() (today). Any ideas? James

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