retrieving the data from the text box

[siva198853]

hi team,

i am new to access i already got a some events in a table where each event has got a time but got no descripition.Now i want to add a text box down to it and give the link to the particular activity ,when i tried to do the same, i am unable to do kindly help on this...

 

[JamesMcS]

Do you mean that you want to have a text box to show what's selected in your listbox? I think you just have to create the text box, and in its control source put

=listboxname.column(x)

where x is the column number starting from 0. So in this case x would probably be 1.

 

[siva198853]

hi james,
thank you very much..i want to add a text box and add some description when i select any activity and every time i stop the activity and it should be saved along with the comments the comments will be given separately for each activity each time.kindly help on this one

 

[JamesMcS]

OK. Firstly, add the descriptions to your activities table, that the listbox is looking at. That should sort that out.

When you're storing a record of what the activity is and how long it took, you should only really be storing the activity number, start/stop time and duration, rather than storing the name and description of each activity in the same table. Have a look at normalisation on the internet, you'll see what I mean.

Oh and welcome to the forum

 

[siva198853]

Thank you very much james.

Here i want to insert an text box down to the list box and want to add the comments to the activities above in the list box and the comments given in the text box should automatically saved to the activity i selected .In such a way there will be different comments every time i select the different activity and all should to be tagged to the activity selected every time and after finishing the one the text box should be blank for the next comments

 

[JamesMcS]

OK, so what you need to do there is create a field in your activities table for the comments, and have a text box bound to that.

 

[siva198853]

OK, so what you need to do there is create a field in your activities table for the comments, and have a text box bound to that.

Exactly but i am unable to bound the text box even it is bounding the message is not saving uniquely .please help in this

 

[JamesMcS]

I don't really understand your post but I'm assuming that's something to do with primary key violations in your table.

Can you upload the database so we can have a look?

 

[siva198853]

I don't really understand your post but I'm assuming that's something to do with primary key violations in your table.

Can you upload the database so we can have a look?

This is the database that has been prepared by somebody i am just trying to modify better so i dont have access to upload the one very sorry...
if you can suggest me the one how to link the text box to the above list box will be helpful....other wise its ok

thank you very much or the quick response james

 

[JamesMcS]

As in post 2 above