notes:

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" wrote:

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]

On Sun, 19 Jul 2009 16:36:01 -0700, Rokmier
wrote:

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

--

John W. Vinson [MVP]

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



"Rokmier" wrote:

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" wrote:

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]

On Sun, 19 Jul 2009 21:31:01 -0700, Rokmier
wrote:

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?
--

John W. Vinson [MVP]

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

"Rokmier" wrote:

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



"Rokmier" wrote:

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" wrote:

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]

On Mon, 20 Jul 2009 10:50:02 -0700, Rokmier
wrote:

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

John W. Vinson [MVP]

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" wrote:

On Mon, 20 Jul 2009 10:50:02 -0700, Rokmier
wrote:

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

John W. Vinson [MVP]

On Mon, 20 Jul 2009 23:46:01 -0700, Rokmier
wrote:

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.

--

John W. Vinson [MVP]