notes:

[Rokmier]

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.

 

[John W. Vinson]

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!

 

[Rokmier]

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]

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/accessjunkie/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.

 

[Rokmier]

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

 

[Fred]

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.

 

[Rokmier]

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

 

[John W. Vinson]

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.

 

[Rokmier]

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]

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.

 

[Rokmier]

I am sorry John, I tried finding Control Source property & Recordsource
property and I have no idea what this info is or how to recognize it.

I need software that I can keep track of my inventory and notes that go with
it. I opened access (had heard that it is perfect for what I need), I noticed
that MS offered templates and I found two. Sales Contact Management database,
which is perfect for contacts and inventory management database (the notes in
this database only allows 255) I need much, much more than that.

The Sales Contact management database has a notes field that allows for
apparently much, much more than 255 characters. All I want to do is get the
notes box in the Inventory database to do the same as the notes in Sales
contact database.

I had no idea I was going to have to learn how to design the darn thing.
Maybe my best bet is to just go to some third party program.

thank you again for your patience and understanding

 

[John W. Vinson]

I am sorry John, I tried finding Control Source property & Recordsource
property and I have no idea what this info is or how to recognize it.

Open the Form in design view. View its Properties (or the Properties of the
textbox).

I need software that I can keep track of my inventory and notes that go with
it. I opened access (had heard that it is perfect for what I need), I noticed
that MS offered templates and I found two. Sales Contact Management database,
which is perfect for contacts and inventory management database (the notes in
this database only allows 255) I need much, much more than that.

The Sales Contact management database has a notes field that allows for
apparently much, much more than 255 characters. All I want to do is get the
notes box in the Inventory database to do the same as the notes in Sales
contact database.

I'm not familiar with either of these template databases. You should view
Access as a toolbox that lets you design and build your own applications. In
my experience, someone else's idea of a template or sample database will only
rarely be exactly customized to YOUR particular needs.

I had no idea I was going to have to learn how to design the darn thing.

Sorry you're not finding your expectations met.

Maybe my best bet is to just go to some third party program.

If you can find one that meets your needs that's probably your best bet!
Access has a steep learning curve and is a complex program. I'm pretty sure we
can get the memo field working for you if you're willing to keep digging, but
that's surely only the first of many changes which will need more work.

thank you again for your patience and understanding

You're welcome. If you want to get into using Access to design your own custom
app, I think you'll be pleased and impressed with its power... but it WILL
require a substantial time investment! There are some resources (including
some more samples) at

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/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

 

[Rokmier]

Ok, John, I hope this works I opened the database under view
then I right click on the notes box and this is the following information
listed

upper left hand corner "Page: Notes"
in drop down box "Notes"

under the "all" tab is the following

Name......Notes
Caption..........
Picture.........(none)
Picture Type.....Embeded
Page Index......1
Status Bar Text......
Visible........Yes
Enabled........Yes
Left.......... 0.1958"
Top........... 1.2917"
Width......... 6.1583"
Height........ 3.0833"
Shortcut Menu Bar.....
ControlTip Text.......
Help Context Id....... 0
Tag............
On Click.........
On Dbl Click......
Om Mouse Down....
On Mouse Move......
On Mouse Up........

Please forgive me if I am sounding hopeless, but I really need this and I
had originally thought this would be the quickest way to get it done.

Please remember that through the frustration, I really do appreciate your time

 

[John W. Vinson]

Ok, John, I hope this works I opened the database under view
then I right click on the notes box and this is the following information
listed

upper left hand corner "Page: Notes"
in drop down box "Notes"

I'm sorry, but *you're not listening*.

You are looking at the *TEXTBOX*.

The problem is not *with* the textbox. The problem is not with the form.

The problem is in the table where the data is being stored.

You need to open the TABLE - not the form - and make the datatype change
there.

Your reference to a "page" makes me think that you're using an ADP (Access
Data Project) instead of a .mdb or .accdb database (which has been my
assumption). Is that the case?

 

[Rokmier]

Ok John, first it is an (.mdb), I opened the table and this is what it shows

upper left hand corner "Products: Table"
there are three columns

Field Name Data Type Description
ProductID AutoNumber
ProductName Text
Notes Memo
CategoryID Number
SerialNumber Text
UnitPrice Currency
ReorderLevel Number
Discontinued Yes/No
LeadTime Text

all rows under the column Descripotion are empty

at the bottom of this table are two more tabs that read

General & Lookup

I am sure you know that under each Field name is a new set of variables (for
a lack of a better word) if you let me know which field name you need this
information for I will supply it for you, in the same manner I supplied the
above info.

thank you again

 

[John W. Vinson]

Ok John, first it is an (.mdb), I opened the table and this is what it shows

upper left hand corner "Products: Table"
there are three columns

Field Name Data Type Description
ProductID AutoNumber
ProductName Text
Notes Memo
CategoryID Number
SerialNumber Text
UnitPrice Currency
ReorderLevel Number
Discontinued Yes/No
LeadTime Text

all rows under the column Descripotion are empty

at the bottom of this table are two more tabs that read

General & Lookup

I am sure you know that under each Field name is a new set of variables (for
a lack of a better word) if you let me know which field name you need this
information for I will supply it for you, in the same manner I supplied the
above info.

And you're trying to put more than 255 bytes into the field named Notes?

Select the Notes field and look at the properties in the lower left of the
screen. If you have *anything* in the format property, remove it.

Now try opening the table (not the "notes page" but the table). Try typing
some text (more than 255 bytes) into the Notes field and then move off that
record. Does it accept the data?

If that works, then please describe again your previous post about a "page".
What I was recommending is that you use an access Form based on your table,
with a Textbox control on the form with its Control Source property set to
Notes. If you have that and it's still not working, be sure that the Format
property of the textbox is blank.

I'd be willing to give you some (brief, preferably) offline help; contact me
at jvinson <at> wysard of info <dot> com if you are still having trouble, and
we can set up an interactive session.

 

[Rokmier]

It will allow more than 255 charecters, but when I moved to the next record
what was typed in the first record appears in the next record & when I close
the database and load it again all notes that I typed in are gone.

Under the General Tab (lower left hand corner) for the field "Notes" is
listed the following

General
Format...............
Caption..............
Default Value........
Validation Rule......
Validation Text......
Required.............No
Allow Zero Length....No
Indexed..............No
Unicode Compression..Yes
IME Mode.............No Control
IME Sentence Mode....None
Smart Tags...........

Under the Lookup Tab (next to the General Tab)
For the Field Name

ProductID.....
ProductName...Text Box
Notes.........
CategoryID....Text Box
SerialNumber..Text Box
UnitPrice.....
ReorderLevel..Text Box
Discontinued..Text Box
LeadTime......Text Box

Please let me know what else you need

Again Thank you

 

[John W. Vinson]

It will allow more than 255 charecters, but when I moved to the next record
what was typed in the first record appears in the next record & when I close
the database and load it again all notes that I typed in are gone.

I'm still having a real problem understanding the situation; let me renew my
offer:

I'd be willing to give you some (brief, preferably) offline help; contact me
at jvinson <at> wysard of info <dot> com if you are still having trouble, and
we can set up an interactive session.

What I'm proposing is that we set up a telephone discussion and use
GoToMeeting, a remote interaction program, so that I can *see your screen* and
figure out what is going on. It's clear that I'm not asking my questions in
the right way.