Group updates - all at once

  • Thread starter Thread starter JohnF
  • Start date Start date
J

JohnF

Can someone pls tell me, if what I wish to do, can be
done in Access.

1> I wish to be able to do a query to get certain records,

2> I then would like to add new info. to the query
results all in one shot. Is this possible in Access, if
so how do I go about doing it? Please apply KISS
explantion.

Thanks, John
 
You need to build an 'update' query. Create your query to locate the
records you want. Change the query type (there is a dropdown in the menu
bar) from 'select' to 'update'. In the 'update to' filed you can specify
what you would like to update.

For example, let's say that you want to change all the records pulled into
the query to contain a particular zip code. You would add the zip code
field to your query and put the desired zip in the 'update to' field.

That 'update to' field can also use fields and formulas. for example, you
could insert the curret date into a field by entering date() in
the 'update to' field.

Post back with more details if you need specific help.

Rick B



Can someone pls tell me, if what I wish to do, can be
done in Access.

1> I wish to be able to do a query to get certain records,

2> I then would like to add new info. to the query
results all in one shot. Is this possible in Access, if
so how do I go about doing it? Please apply KISS
explantion.

Thanks, John
 
Thank you Rick, but this is not what I want to do.

In my situation I have Form A with SubForm B.

I want to be able to call certain records, lets say who
attended military exercise. Once I have all the names
(records) I want be able to enter particulars such as
Exercise name, dates, and comments. ALL IN ONE SHOT.

I do not want to enter this data (which would be the same
for all records) individually.

Can this be done in Access? If so, how? please KISS....

Thanks, John
 
Another way which would more closely resemble standard database design,
would be to build a separate table for the Exercise and then select which
users attended. In the users table, you could find all the exercises they
had attended as well.

This seems to be a classic many-to-many relationship situation.

It might even need to be a many-to-many relationship now that I think about
it.

Table1 - one record per PersonName, Info, Etc. Key = UserID?
Table2 - one record per exercise with dates and comments Key = Exerc#?
Table 3 - UserID and Exerc# (many records with one person and one
exercise per record)

That's what you need!

If you insist on doing it the way you have it now, other than having a field
in your main form that would use code to place it's contents into all the
records of your subform, I can't think of a way to do it. I have never seen
a post with this type of code, but it should be doable.

It might need to be a loop that cycles through each record in the recordset
and changes the value for the particular field to the value of your input
field at the top.


HTH

Rick B


Thank you Rick, but this is not what I want to do.

In my situation I have Form A with SubForm B.

I want to be able to call certain records, lets say who
attended military exercise. Once I have all the names
(records) I want be able to enter particulars such as
Exercise name, dates, and comments. ALL IN ONE SHOT.

I do not want to enter this data (which would be the same
for all records) individually.

Can this be done in Access? If so, how? please KISS....

Thanks, John
 
Back
Top