Multiple entries at the same time.

[Henley12]

I have a database that has an equipment table. Several of the pieces of equipment are the same, i.e. hospital beds. The question from one of my users is.... is there a way to add a comment to several pieces of equipment at the same time. For instance, I would need to search for hospital bed, then enter a comment to insert on multiple records at one time. Does this make sense? Any ideas?

 

[georgedwilkinson]

In a properly normalized database, yes.

Another way:

update whatevermytablenameis
set comment = 'whatevermycommentis'
where equipment = 'hospital beds'

Not really recommended but it will work (until your users recognize they just overwrote the unique comment in one of the records).

You really should look into normalizing your model.

 

[Henley12]

I believe my database is pretty well normalized. I don't want to update all records of 'name of equipment', just selected ones.

 

[Kryst51]

I have used a list box to obtain this before, select multiple records, click a button that runs some code to update the comment field of the selected objects.

I'll try to find my thread about that and maybe link it here so you can look at the code. I had a lot of help from this forum concerning that. So give me a second to look.

EDIT: Here is the thread, and it looks like it was pbaldy who helped me out on this one.

 

[gemma-the-husky]

a couple of ways

if you have a multi-item list box. you would have to step through the "selected items" collection in code,


alternatively, have a "update this" check box in the underlying table
let the users set this field for all the items they want to update, on a continuous form, probably

then you can run code to update a comment field for items with updatethis = true

the more items you have, the trickier it could get to do this (the selection bit really) - as unlike excel you cant drag and drop values in access, the same way