Search results

Richard, The data seems to be saving to the table OK. Can you be a little more specific about the problem you're having?

Otis, if the user tries to close the form when the record is partially complete, do you want the record to be deleted or the user forced to enter in the missing information?

Set the combo box's Default value to the value you want displayed.

Set the form's Cycle property to Current Record.

How about programming the field's On Got Focus property with a Go To Page command?

I'm sure this is a simple one, but can't find exactly what I need. I have a memo field on my forms. What I want is this: when the user clicks on the field to record notes, if there is already text in the field I want the cursor to automatically go to the end of the text so they can easily append...

Yes. A subform is a form-within-a-form. There is a wizard that will help you create one. If you're not familiar with subforms, do a search on "subform" in MS Access Help to learn more. I also recommend picking up a self-help book. There are many to choose from and they make great reference manuals.

Make sure you set the decimal properties for this field both on the form and in the underlying table.

I assume you already have this information entered into another table and what you want to do is display it? If so, the simplest way to do this is with a subform.

Can you be a little more specific about the problem? In what way did it not work well?

wild, If you only ever have one value in this field, why not just use a text box instead?

Steve, I've had this happen myself. The problem is that for every record in your secondary table, the ID number (or whatever variable links the 2 tables) must have a corresponding ID in the main table. You get that error message when the ID in your secondary table doesn't exist in the main...

In regard to your tables, if you will be having guests from North America you'll want to include a field in tblCustomer for State/Province. I'm also wondering whether it might not be better to link phone calls and messages to GuestBillID rather than RoomNumber. This would save some effort in...

In the form's form properties, set Cycle to Current Record.

Oh, heck - why not just use the sink? JUST KIDDING, FELLAS Is that better, Vassago? ;)

Yeah, what he said. :D

Deborah, Are you using this form to enter data, or just to view it? If you only need to view data in datasheet view, the simplest way to do a multi-column sort is with a query rather than a form.

No problem. I think you're right - this second article's approach looks like it will be easier for me to implement. Thanks again! :)

Well Jack, Despite the fact that the first sentence I saw in the article you sent was "Advanced: Requires expert coding, interoperability, and multiuser skills.", I will indeed try what you suggest. Thanks a bunch, it looks like just what I'm looking for. :)

I'm designing a form for entering a person's residential history, with each record recording one residence for an individual. What I'd like to do is this: The user enters in the year a person moved from a particular location ([YrEnded]), then clicks a command button to go to a new record to...