Search results

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

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