Sending text box content to a memo.

[Carl_and_Earl]

Hi there,

I want to ask you which will be the best way to make the database. Maybe the
way I am thinking to make it (with option buttons and so on is not the best).
And if possible a bit of how can I connect the text with the memo and the two
option buttons with the other two text boxes.

The form I am trying to make looks like a chat window where there is a big
memo like let's say in Yahoo Messanger, where the users speak and see
eachother the text they are sending and an imput text where the text is
writen and then, pressing the enter button, the text is being sent to the
memo above.

The thing is that I want to have, if possible, two option buttons, connected
to another two text boxes.

I want to be able to select one option and then the option I select to be
the text that the text box has.

That text must be copyed in front of each line I want to imput in the
"Messenger" area.

The "final product" must help me have a database with records like:

Carl: Hi, how are you.
Earl: Fine, thanks.

That I will later export and print as a conversation.

 

[John W. Vinson]

Hi there,

I want to ask you which will be the best way to make the database. Maybe the
way I am thinking to make it (with option buttons and so on is not the best).
And if possible a bit of how can I connect the text with the memo and the two
option buttons with the other two text boxes.

The form I am trying to make looks like a chat window where there is a big
memo like let's say in Yahoo Messanger, where the users speak and see
eachother the text they are sending and an imput text where the text is
writen and then, pressing the enter button, the text is being sent to the
memo above.

The thing is that I want to have, if possible, two option buttons, connected
to another two text boxes.

I want to be able to select one option and then the option I select to be
the text that the text box has.

That text must be copyed in front of each line I want to imput in the
"Messenger" area.

The "final product" must help me have a database with records like:

Carl: Hi, how are you.
Earl: Fine, thanks.

That I will later export and print as a conversation.

I'd really suggest a different design. Each record of the conversation could
be *a separate record* in a table. I'd suggest a table with three fields -
Speaker, MessageTime, Message; default MessageTime to Now() in order to
timestamp each line (for sorting purposes later, and to be able to search for
messages sent at a particular time).

You could display this construct on a Continuous Form to show all of the lines
of text onscreen concurrently, scrollable, without copying it into a memo
field; the result will be MUCH more easily searched, will bloat your database
much less, and will be less liable to database corruption.

 

[Carl_and_Earl]

I'd really suggest a different design. Each record of the conversation could
be *a separate record* in a table. I'd suggest a table with three fields -
Speaker, MessageTime, Message; default MessageTime to Now() in order to
timestamp each line (for sorting purposes later, and to be able to search for
messages sent at a particular time).

You could display this construct on a Continuous Form to show all of the lines
of text onscreen concurrently, scrollable, without copying it into a memo
field; the result will be MUCH more easily searched, will bloat your database
much less, and will be less liable to database corruption.

Thanks for taking time to answer me John.
I admit this is a difficult task for a new user, but I want to take my chance.

The time stamp is not necessary for me. The design also doesn't matter so
much also. What matters is the structure, as you told me to make a different
table for messages and speaker.
What is harder for me to understand is how to connect the text box with the
memo and how correlate the text in the text box connected to the option
buttons to appear in front of the line when I "change users" let's say.
If you could post an example would be much appreciated.
Thanks.