notes:

in the "Sales contact management database" template that is offered at the MS
download site is a text box labled notes. It allows for an unlimited amount
of text to be inputed.

I would like to include the same kind of a box for the
"Inventory management database" from the same site. I have been trying on
and off for over two months and can not get it to work, please is their any
one who can help me.

On Mon, 13 Jul 2009 17:05:01 -0700, Rokmier
wrote:

in the "Sales contact management database" template that is offered at the MS
download site is a text box labled notes. It allows for an unlimited amount
of text to be inputed.

I would like to include the same kind of a box for the
"Inventory management database" from the same site. I have been trying on
and off for over two months and can not get it to work, please is their any
one who can help me.

Are you using a "Memo" type field in the table? Have you changed the form's
Recordsource query to reference this field?

"can not get it to work" is a bit hard to answer, since you don't say what you
have tried and in what way it's not working!
--

John W. Vinson [MVP]

I am not savey in any, way shape or form, in recreating the template. To be
perfectly honest what I have tried is to delete the text box that was their &
adding a new text box. When I choose "properties" (because I looked at
others) I noticed that the notes option was never available. I tried using
the help, but I could not understand what it was saying to me. I appreciate
your getting back to me. Is there anyway I could send an attachment (it may
be easier to understand if you can see what I mean)

thank you, for your time


"John W. Vinson" wrote:

On Mon, 13 Jul 2009 17:05:01 -0700, Rokmier
wrote:

in the "Sales contact management database" template that is offered at the MS
download site is a text box labled notes. It allows for an unlimited amount
of text to be inputed.

I would like to include the same kind of a box for the
"Inventory management database" from the same site. I have been trying on
and off for over two months and can not get it to work, please is their any
one who can help me.

Are you using a "Memo" type field in the table? Have you changed the form's
Recordsource query to reference this field?

"can not get it to work" is a bit hard to answer, since you don't say what you
have tried and in what way it's not working!
--

John W. Vinson [MVP]

On Tue, 14 Jul 2009 13:41:02 -0700, Rokmier
wrote:

I am not savey in any, way shape or form, in recreating the template. To be
perfectly honest what I have tried is to delete the text box that was their &
adding a new text box. When I choose "properties" (because I looked at
others) I noticed that the notes option was never available. I tried using
the help, but I could not understand what it was saying to me. I appreciate
your getting back to me. Is there anyway I could send an attachment (it may
be easier to understand if you can see what I mean)

It sounds like you're just working in the Form without understanding what the
form is doing... and therefore you're in trouble.

Forms are JUST WINDOWS. Data is not stored in forms. Textboxes don't have
character limits (well, they can be programmed to have limits but they usually
don't).

Your notes are NOT stored in the textbox, and changing the textbox won't
affect how they're stored. I think you need to take a step back and learn a
bit more about how Access works before diving into changing an application!
See

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/acc...resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

Roger Carlson's tutorials, samples and tips:
http://www.rogersaccesslibrary.com/

A free tutorial written by Crystal:
http://allenbrowne.com/casu-22.html

A video how-to series by Crystal:
http://www.YouTube.com/user/LearnAccessByCrystal

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials

I'm a self employed consultant donating my time on the group, and I fear that
downloading a database and fixing it for you would go quite a bit beyond
what's appropriate for free tech support.

Basically what you need to do is figure out what Table contains the notes, and
either add a Memo field to some appropriate table or possibly add a new notes
table.
--

John W. Vinson [MVP]

I tried adding a new notes table and still i could not get it to take more
then 255 characters. I am not asking for anyone to go out of their way, I am
asking for help, I thopught that is what this forun was suppose to be about.

thank you

"John W. Vinson" wrote:

On Tue, 14 Jul 2009 13:41:02 -0700, Rokmier
wrote:

I am not savey in any, way shape or form, in recreating the template. To be
perfectly honest what I have tried is to delete the text box that was their &
adding a new text box. When I choose "properties" (because I looked at
others) I noticed that the notes option was never available. I tried using
the help, but I could not understand what it was saying to me. I appreciate
your getting back to me. Is there anyway I could send an attachment (it may
be easier to understand if you can see what I mean)

It sounds like you're just working in the Form without understanding what the
form is doing... and therefore you're in trouble.

Forms are JUST WINDOWS. Data is not stored in forms. Textboxes don't have
character limits (well, they can be programmed to have limits but they usually
don't).

Your notes are NOT stored in the textbox, and changing the textbox won't
affect how they're stored. I think you need to take a step back and learn a
bit more about how Access works before diving into changing an application!
See

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/acc...resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

Roger Carlson's tutorials, samples and tips:
http://www.rogersaccesslibrary.com/

A free tutorial written by Crystal:
http://allenbrowne.com/casu-22.html

A video how-to series by Crystal:
http://www.YouTube.com/user/LearnAccessByCrystal

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials

I'm a self employed consultant donating my time on the group, and I fear that
downloading a database and fixing it for you would go quite a bit beyond
what's appropriate for free tech support.

Basically what you need to do is figure out what Table contains the notes, and
either add a Memo field to some appropriate table or possibly add a new notes
table.
--

John W. Vinson [MVP]

Hello Rokimer,

Access is a tool box, and I think that you are so new to it that you are
unable to clearly communicate your question, but more importantly, have shown
that you are unable to understand or utilize the answer. What the
respondents are saying that your next step is going to have to be to learn at
least a little more about Access. Otherwise it would take one of the
volunteers hours or days of work to try to help you, and that asking a
volunteer to spend all of that time is too much to ask. Doubly so if you
are not willing to first read those suggested resources to learn a little
more about Access.

is it really that difficult to have someone explain how I can add a note
field that will allow much more then 255 charecters, maybe this is not the
application I need or this is not the forum it is suppose to be.

thank you

"Rokmier" wrote:

I tried adding a new notes table and still i could not get it to take more
then 255 characters. I am not asking for anyone to go out of their way, I am
asking for help, I thopught that is what this forun was suppose to be about.

thank you

"John W. Vinson" wrote:

On Tue, 14 Jul 2009 13:41:02 -0700, Rokmier
wrote:

I am not savey in any, way shape or form, in recreating the template. To be
perfectly honest what I have tried is to delete the text box that was their &
adding a new text box. When I choose "properties" (because I looked at
others) I noticed that the notes option was never available. I tried using
the help, but I could not understand what it was saying to me. I appreciate
your getting back to me. Is there anyway I could send an attachment (it may
be easier to understand if you can see what I mean)

It sounds like you're just working in the Form without understanding what the
form is doing... and therefore you're in trouble.

Forms are JUST WINDOWS. Data is not stored in forms. Textboxes don't have
character limits (well, they can be programmed to have limits but they usually
don't).

Your notes are NOT stored in the textbox, and changing the textbox won't
affect how they're stored. I think you need to take a step back and learn a
bit more about how Access works before diving into changing an application!
See

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/acc...resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

Roger Carlson's tutorials, samples and tips:
http://www.rogersaccesslibrary.com/

A free tutorial written by Crystal:
http://allenbrowne.com/casu-22.html

A video how-to series by Crystal:
http://www.YouTube.com/user/LearnAccessByCrystal

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials

I'm a self employed consultant donating my time on the group, and I fear that
downloading a database and fixing it for you would go quite a bit beyond
what's appropriate for free tech support.

Basically what you need to do is figure out what Table contains the notes, and
either add a Memo field to some appropriate table or possibly add a new notes
table.
--

John W. Vinson [MVP]

On Wed, 15 Jul 2009 18:33:02 -0700, Rokmier
wrote:

is it really that difficult to have someone explain how I can add a note
field that will allow much more then 255 charecters, maybe this is not the
application I need or this is not the forum it is suppose to be.

Store the note in a field of Memo datatype (not Text).
Do not apply any Format clause to this field, either in the table or on the
form.
Do not sort by the Memo field either in a query or on the form.

If that doesn't do it please post a description of your table (with fieldnames
and datatypes), and the SQL view of the Recordsource of your form.
--

John W. Vinson [MVP]

John, I would like to thank you very much for your help, between what you
wrote in the email and using the help feature I was able to get the text box
to now accept an unlimited amount of text (at least it appears that way. The
only problem now is that when I close the application and open it again the
text has not been saved.

I await your response and whole heartly appreciate your patience.

"John W. Vinson" wrote:

On Wed, 15 Jul 2009 18:33:02 -0700, Rokmier
wrote:

is it really that difficult to have someone explain how I can add a note
field that will allow much more then 255 charecters, maybe this is not the
application I need or this is not the forum it is suppose to be.

Store the note in a field of Memo datatype (not Text).
Do not apply any Format clause to this field, either in the table or on the
form.
Do not sort by the Memo field either in a query or on the form.

If that doesn't do it please post a description of your table (with fieldnames
and datatypes), and the SQL view of the Recordsource of your form.
--

John W. Vinson [MVP]

On Fri, 17 Jul 2009 14:01:01 -0700, Rokmier
wrote:

John, I would like to thank you very much for your help, between what you
wrote in the email and using the help feature I was able to get the text box
to now accept an unlimited amount of text (at least it appears that way. The
only problem now is that when I close the application and open it again the
text has not been saved.

What is the Control Source property of the textbox? (It should be the name of
a Memo type field in your table).

What is the Recordsource property of your Form? (It should be the name of a
Table or Query on a table, containing the memo field; or it might be a SQL
string referencing such a table).

Again: THE TEXTBOX IS NOT YOUR PROBLEM.

A textbox, or a form, is *just a window*. A textbox is *not* a place to store
data. Data should be stored in tables, and only in tables.
--

John W. Vinson [MVP]