Search results

THis code: If Me!ReminderDate > Date Then DoCmd.SelectObject acForm, "frmWeekView" MsgBox "Past Due Reminders" End If Works fine on 2 of my other forms, in the On Load, that I base tblReminders on. The difference is the forms it works on are populated with the...

Again, this form DOES NOT display any text fields form the table it is based on.

What is TextFirst representing?

I'm getting 'variable not defined' on tblReminders.

Where does the message box fit in?

I'm checking to see if any record's date (ReminderDate) is before today. I want to see if there are any past due reminders.

The form isn't showing any records. I based the form on tblReminders so I can reference ReminderDate in tblReminders. If ReminderDate for na record in tblReminders is less than Today (past due) I want the message box to tell me.

I should have explained further but I didn't expect it to be that complicated. This form does not display any records from the table that I have based the form on (tblReminders) The form is similar to a main menu.

I tried that before. Now, even though there's a date earlier than today the message box does not pop up.

Well, at tis time there are no dates less than today but the message box still pops up.

I now can't seem to get it to work properly. The message box pops up regardless whether any record's date is before today. If Me!ReminderDate > Date Then DoCmd.SelectObject acForm, "frmWeekViewNew" MsgBox "Past Due Reminders" End If Also, am I the only one having...

I needed the SelectObject: If Me!ReminderDate > Date Then DoCmd.SelectObject acForm, "frmWeekViewNew" MsgBox "Past Due Reminders" Else End If It works ok now. Thanks, james

On the on Load of a form I'm checking the value of a date field. The message box pops up fine, but before the form opens. How do I have the form open before the message box. I thought using SelectObject some how works but I'm not sure how. If Me!ReminderDate > Date Then...

I knew that.

I tried but to insert a the csv attachment but the site tells me it's an invalid file.

Here it is.

Not sure if it will help, but. There is an address column off the right which didn't fit.

Well, seeing that I have some personal ph0one numbers, is there another way?

I credited a db with the imported data.

Problem is, Field1 has parts of the contact name and part of the address. It's a garbled mess.