Problem with updating queries.

[sshamir]

Hello,

I would like to make an update query that will ask the user to enter
data and in what fields does he wants to enter it. The problem I am
having is that I want that the user will be able to enter his choices
more then one time until he finish.For example I want to enter a city
name into item number 1,8,12, 20.

Is it possible to do so?
Thanks
Shachar

 

[pietlinden]

Hello,

I would like to make an update query that will ask the user to enter
data and in what fields does he wants to enter it. The problem I am
having is that I want that the user will be able to enter his choices
more then one time until he finish.For example I want to enter a city
name into item number 1,8,12, 20.

Is it possible to do so?
Thanks
Shachar

One way:
use a textbox for the City
use a listbox to select the Item Numbers.

Use the code at MVPS.org/access to turn the list of numbers into a
valid WHERE clause, then run your update query by using DBEngine(0)
(0).Execute strSQLStatement

 

[sshamir]

One way:
use a textbox for the City
use a listbox to select the Item Numbers.

Use the code at MVPS.org/access to turn the list of numbers into a
valid WHERE clause, then run your update query by using DBEngine(0)
(0).Execute strSQLStatement

thanks for your reply.
I am not that familiar with all the access things you said. Is there
any easy way I can do it?

 

[sshamir]

thanks for your reply.
I am not that familiar with all the access things you said. Is there
any easy way I can do it?

ok I have made a form with a combo box that the user can chose a
destination a text box that the user should type in an item number and
I want to add a list box or something like that that the user can
chose what items to update (with the data he was entered in the combo
box and in the text box).

Easy help anyone?
Thanks

 

[pietlinden]

ok I have made a form with a combo box that the user can chose a
destination a text box that the user should type in an item number and
I want to add a list box or something like that that the user can
chose what items to update (with the data he was entered in the combo
box and in the text box).

Easy help anyone?
Thanks

At the website I gave you there's an article about using the contents
of a listbox as query parameters. That should do it for you.