Search results

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

I just going by the values when the form is in design view. I'm not setting any values as far as the form's size or can grow.

I'm not using twips. I'm taking the width of the form (13.76) and the width of the rectangle (7.35). Subtracting them (6.41) ad dividing that by 2 (3.2). So, the left side of the rectangle should be at 3.2?

I used the formula but the rectangle is noticeably too far too the left and to the bottom. It looked mot centered when I just eyed it.

I'm using a tabbed interface and have placed a rectangle on a form and placed command buttons inside the rectangle. How can I center the rectangle which is about a third the size of the form?? Is there a formula I might use? I'm not much of a mathematician. James