rmarquez5
Registered User.
- Local time
- Today, 07:13
- Joined
- Sep 10, 2002
- Messages
- 22
Greetings all.
I have a created a useful recorded movie database in Access. One of the columns in my tables is a memo field, containing a description of the movie. I have a three main tables: a want list, scheduled recordings, and my current collection.
When I use an append/insert query to insert records from my scheduled recordings to my current collection, the memo fields are complete. However, if I use a query to display my want list records, highlight them, and then copy/paste them into my scheduled recordings, the memo fields are get truncated! So I have incomplete descriptions for some of my movie records, and complete descriptions in others.
I was just wondering if anyone else has run into this problem, just to confirm that I really should be using inserts all the time, rather than copy/paste.
Any input anyone can provide would be most appreciated. Thanks a bunch. I hope to hear from you.
R.
I have a created a useful recorded movie database in Access. One of the columns in my tables is a memo field, containing a description of the movie. I have a three main tables: a want list, scheduled recordings, and my current collection.
When I use an append/insert query to insert records from my scheduled recordings to my current collection, the memo fields are complete. However, if I use a query to display my want list records, highlight them, and then copy/paste them into my scheduled recordings, the memo fields are get truncated! So I have incomplete descriptions for some of my movie records, and complete descriptions in others.
I was just wondering if anyone else has run into this problem, just to confirm that I really should be using inserts all the time, rather than copy/paste.
Any input anyone can provide would be most appreciated. Thanks a bunch. I hope to hear from you.
R.
