Urgent Help Required

[Imy South]

I am a new user of Access 2000 and I have come across a few problems. Please if anyone can help reply I need your help urgently........

Town's you have visited

Manchester
London
Liverpool
Newcastle
Huddersfield

I want to select 3 town's above and store the data into the field (visited town's) How do I do this???

2)I have a list box on a form and i want to be able to select more that one value and store it into a field, how do I do this?

3) Last but not least. I have a text field that calculates from a different feild, but when it calculates it doesn't store the result into the field, it leaves it blank........

4) If I have tick boxes and more that one are selected how do I save the ones that are ticked into the table?

i.e

Which Foods do you like?

Chips
Burgers
Fish
Pasta
Pizza

I want to tick chips, fish and pasta how does this information be recorded into the table?

Thanks
Imy

 

[smercer]

Town's you have visited

Manchester
London
Liverpool
Newcastle
Huddersfield

I want to select 3 town's above and store the data into the field (visited town's) How do I do this???

Do you only want to select 3 towns, no more, no less? sounds like a Visual basic procedure.

2)I have a list box on a form and i want to be able to select more that one value and store it into a field, how do I do this?

see attachment. this project is someone elses but you will see if you like it or not.

3) Last but not least. I have a text field that calculates from a different feild, but when it calculates it doesn't store the result into the field, it leaves it blank........

It is not a good idea to calculate and store calculations, because you can always have the computer recalculate them again. (this only applies to queries, forms, and reports, but not tables). to make a calculation:

1) create a text box (NOT Label) in design view of the form you want it in.

2) Click on the text box until "Unbound" is highlighted, then type (Where "n" is a number you want to calculate):

=n*n

for multiplying or

=n+n

for adding or

=n-n

for subtracting or

n/n

for divideing

there are others, but ask and you shall receive

4) If I have tick boxes and more that one are selected how do I save the ones that are ticked into the table?

i.e

Which Foods do you like?

Chips
Burgers
Fish
Pasta
Pizza

I want to tick chips, fish and pasta how does this information be recorded into the table?

1) In your table design (use button on toolbar with the set squire) you should have "Yes/No" for data type.
then in your form design (use Same button)

2) there is a button on the tool bar when you hover the mouse over it will show "Field List" click this and insert the yes no fields you inserted into your table.

Does this help? Please respond.

 

[Rich]

you shouldn't store multiple entries in a single field, search here for articles on normalising your db

 

[Mile-O]

Imy South has already been told this (click here)

 

[Imy South]

Thanks

Hi smercer

Thank you for your help and response, I have had a look at the example you have gave me. But what i want to do is which items are selected in the list box (doesn't matter how many) I want to be able to save them in a field in a table. Its more of storing data.

Regards
Imy

 

[Rich]

http://www.access-programmers.co.uk/forums/showthread.php?t=69105