View Full Version : Question


rkrause
09-24-2007, 06:53 AM
Could someone help me out with the following, i will try to describe my best what i want done.

I have a table with a note field in it. It is only used for this purpose. On the form all that would be added would be a text box. On my form i want my data entry person to beable to enter any notes possible into the text box. On form close have those notes save and when reopened have those notes open back up.

Could someone give me some steps on this process.

Thanks,

ajetrumpet
09-24-2007, 07:21 AM
I have a table with a note field in it. On the form all that would be added would be a text box. On form close have those notes save and when reopened have those notes open back up.I assume its going to be a bound txtbx?? That's automatic....please be more specific...

rkrause
09-24-2007, 07:38 AM
actually it is an unbound textbox. I didnt create the form and the developer before me has created all unbound controls and populated them with code.

rainman89
09-24-2007, 07:39 AM
well u will have to assign it to some field in a table somwhere so that the database can store it so it will open on the next time. can u make tables? or add fields?

rkrause
09-24-2007, 07:46 AM
i have a table created and a field in it called notes. but i am having troubles with the next steps. When i drop a text box on the form it just says unbound and my field list in the toolbar is grayed out

rainman89
09-24-2007, 07:50 AM
you have notes set as a memo field in the table correct? thats gonna be crucial for ya

next step would be. do u want them to have the option to save it or do u want it to save automatically when they close the form?

rkrause
09-24-2007, 07:53 AM
yep its a memo field,
save automatically

rainman89
09-24-2007, 07:57 AM
is the form based on a query or is the whole thing unbound?

How was the designer before u saving the data?

rkrause
09-24-2007, 09:23 AM
everything is unbound. The information that is brought up on the form is from another form but this notes field is only going to be on the 2nd form so i need the data entry to be able to add and then save.

rainman89
09-24-2007, 09:59 AM
k look here.
http://www.access-programmers.co.uk/forums/showthread.php?t=102897&highlight=saving+unbound+field