Search results

Sure. I opened my new database and table in one monitor, then the old database and table on the other monitor. I made sure they had the same fields, named the same, and then selected the records I wanted copied, did a ^c of the old fields and ^v in the new table. Copied 632 records in one go...

Solved my issue, thanks! It was so simple, I felt like this: :banghead: Thanks all for your input!

Thanks to all!

I appreciate that, but isn't applicable. My DB is a catalogue of designs. The attachment is a picture of that design and doesn't change. This isn't a power database, it's simple and only for me, but needs to be portable to my laptop. I created a blank DB and pulled both main tables and their...

What? Did you not see my post earlier? Just curious... It was a demo showing you exactly how it's done. No, it was a demo showing it CAN be done. It wants me to buy your $54 book to see HOW to do it. Thanks for the info.

Gentlemen, much as I appreciate the info/suggestions, no one has actually answered the question. Can I move/append/copy/update records containing an attachment from one table to another?

Attachment.

Did you remove only this field and then you could append to the table? Yes, the rest of the fields worked as expected. Better to have a text field that stores the file path and use something like Application.FollowHyperlink method - without making the field a hyperlink field. I actually tried...

I am trying to combine two tables that are very similar, I used Append. It gave me the "An Append query cannot contain a multi-valued field" error message. Through examination, I figured out that the graphic field is what Access considers multi-valued. It won't append or update that picture...

I'm Nancy, I live in Arizona, USA. I'm retired! My hobby is crafty stuff but I've always been something of a nerd. Been using Access for about 20 years but at a very elementary level. I get something working and then leave it alone, just use it. So every time I need something new, I struggle!