Search results

You're right. I have several functions using date and () isn't required.

I needed to add the () to Date. "ReminderDate < Date()" Works ok now. Thanks, james

I get the 'Enter Parameter Value' for 'Date.' Which isn't the name of a field on the frmReminders form.

I'm trying to open a form with a date field from a command button. I'd like the form to open and display records where the date is less than Today() DoCmd.OpenForm "frmReminders" , , , "ReminderDate" < Date When I click the button the form opens showing no records even though I deliberately...

I have dated records that start on Nov. 1 and run all month I need to see which record start on Nov. 1 and run to Nov. 14. Then, I want to see the records that go from Nov. 15 to the last day of the month. Subsequently, I'll do the same thing for Dec.

I want to display only records with a date range from the 1st of the month to the 14th of the month. Any ideas? James

Worked great! I wasn't sure if it was going to work with a split form datasheet but it did. I was using the Display as Hyperlink=Screen Only but I was unable to get ris of the font underline. Looked funky... what ever that meas. Thanks much, James

I want a field to be enabled but want to change the cursor from an I-Beam to either a hyperlink hand or a pointer. Is this possible? James

Ok. I'm using the same approach but with a contiguous form. Thanks, James

I forgot to mention. I'd like to be able to move to other records in the single (editing) form.

What would be the best way to open an editing form from a split form to the same record as the split form? I don't want tom use the single record part of the split form, no editng at all on the split form. Currently I'm displaying the record ID and clicking that using: DoCmd.OpenForm...

DoCmd.OpenForm "Formname"

I have senior moments when early or late or what ever. This seems to only occurs when the form is called from another form. It doesn't seem to happen whit a similar situation in another db. Probably another corruption. Another work around. This is getting old with Access.

Of course it would have been clearer if I had mentioned I was using Access 2010.

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