Search results

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.

I want to import my Google contacts into a blank access table. The structures is very different. I exported Google contacts as a .csv (google and outlook types) and neither worked. The exported files has 90 fields. It did import data but it seemed to separate much of the data between the Access...

I'm using a tabbed interface so the form spans the width of the monitor. It doesn't need to be perfect but I measured the width of the monitor and used the formula and it looks ok now. I eye-balled the vertical position. Thanks much, James