How can I put multiple records into a textbox?

[Jamie Loren]

How can I take several records from a Table and put all of the
data into a textbox? (i don't want to use a listbox).

 

[Joseph Meehan]

How can I take several records from a Table and put all of the
data into a textbox? (i don't want to use a listbox).

On a form? a report?

 

[Jamie Loren]

On a form. I have a textbox on a form and I would like
to put all records that have Status of "Complete" into the
textbox. It doesn't really matter if they line up into columns
as long as all the data is there.

I don't want to dump ALL of the records, just the
ones that have a status of "Complete".

Help please!

 

[Larry Daugherty]

What you have asked for help doing is not good practice. You have to
work hard to get Access to behave like a flat file!

If you would explain what you're trying in real world terms you'll
probably get some suggestions.

Something you could do is place a listbox on your from based not on
the form's recordset but on a query that returns all records with a
status of "Complete"

HTH

 

[Jamie Loren]

That's a great suggestion about using the ListBox. The problem
is that when I do that the text won't wrap to the next line.

You asked for it in "real world practical terms" so let me give
that my best shot.....

In my Access database I have records that I enter in for each
customer. For example, I might enter a record for John and
then for Jill. Basically a customer database. Each customer
is given a unique ID.

Several "notes" entries will be made for each customer such
as this...
01-01-2006 John called and placed an order
01-01-2006 John purchased something
01-01-2006 John said his address changed

I need an easy way to add/remove things in the "Notes" section
for each person.

What do you think?

 

[Joseph Meehan]

On a form. I have a textbox on a form and I would like
to put all records that have Status of "Complete" into the
textbox. It doesn't really matter if they line up into columns
as long as all the data is there.

I can't for the life of me, figure out what you are doing. However it
sounds wrong. If you have a "Complete" status for a record, the usual best
practice is to create a yes - no field for "Complete." and just check it
when complete.

I don't want to dump ALL of the records, just the
ones that have a status of "Complete".

Why dump them? You know in six weeks someone will want to know who
completed course during the week of ... With the addition of that
"Completed" field (only make it a date type) you can record the date as well
as the fact it was complete. You need not show any records where there is a
date in that filed so you will never need know they are there until you need
to hunt for one.

 

[Jamie Loren]

It was exactly like I said in my first post...... I wanted to
take records from a table and stick them into a textbox. I finally
found out that this can be done through programatically using a
recordset.

Thanks so much to all that helped!

 

[Larry Daugherty]

I have an application such as you describe. There is a table for
customers and another for Notes. The form is based on a query on
tblCustomer and a subform is based on a query on tblNote. The note
entries are in a Memo field so there can be lots of text with multiple
lines in a given note. The sense of the note is that it records a
contact event with that customer. The design of the subform is such
that only a few lines are actually displayed of a given note but those
few lines are displayed for several notes. I capture the date of the
event in a textbox in the subform. You can scroll back and forth in
the notes and you can scroll up and down within a note.

Maybe the above ideas will be useful to you.

HTH