Write in area on form

D

dannyw

Can I create an endless write in frame on a form. I need to use it as a pass
down log from one shift to another as long as possible. Excel would be
preferable. I found the active x control but it won't save the data I enter
when I close and open the form. This will be used on the "menu" form. Help!
 
G

Gargamil

If I read you correctly you want to be able to have a space on a form to
take an unlimited amount of text. This would require you to set up the
field as a MEMO field in the database table.


dannyw said:
Can I create an endless write in frame on a form. I need to use it as a pass
down log from one shift to another as long as possible. Excel would be
preferable. I found the active x control but it won't save the data I enter
when I close and open the form. This will be used on the "menu" form.
Click to expand...
Help!
 
D

Damien McBain

Gargamil said:
If I read you correctly you want to be able to have a space on a form
to take an unlimited amount of text. This would require you to set
up the field as a MEMO field in the database table.
Click to expand...

And if it's on the main menu form, you can set it to display the last record
in the table at OnOpen or OnCurrent.

Create a table with 2 fields, an autonumber (primary key) and a Memo field.
Make the this table the recordsource of your menu form.

Create a text box for the memo field on the main menu form (open the field
list and drag the memo field onto your form).

Make the text box's locked property "yes" (unless you want people to be able
to edit it on that form).

Set the form's OnOpen event:

Private Sub Form_Open(Cancel As Integer)

DoCmd.GoToRecord acDataForm, "Form2", acLast

End Sub

When the form opens it will display the last record in the table. You'll
need another form, preferably with it's data entry property set to yes, to
create the shift reports.

HTH

Damo
 
Top