If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
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] |
#12
|
|||
|
|||
notes:
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] |
#13
|
|||
|
|||
notes:
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] |
#14
|
|||
|
|||
notes:
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] |
#15
|
|||
|
|||
notes:
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] |
#16
|
|||
|
|||
notes:
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] |
#17
|
|||
|
|||
notes:
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] |
#18
|
|||
|
|||
notes:
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] |
|
Thread Tools | |
Display Modes | |
|
|