Results 1 to 3 of 3
  1. #1
    dixonada is offline Novice
    Windows XP Access 2007
    Join Date
    Apr 2012
    Posts
    2

    Question Code donation request

    Thanks in advance.



    Would someone help develop a function where a row is copied from a table and then paste to a different table? The challenge being the source table contains a ComboBox (multi-value) and the destination is simply a text field. An all-too-familiar error occurs when attempting a simple append, however, this can be done manually as shown in the below images. Would someone be willing to donate code which helps me accomplish this seemingly trivial task?

    Click image for larger version. 

Name:	Copy.JPG 
Views:	6 
Size:	29.5 KB 
ID:	7196 Click image for larger version. 

Name:	Paste.JPG 
Views:	7 
Size:	56.6 KB 
ID:	7197

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Why do you need to duplicate data?

    Google: Access VBA multi-value fields update

    Review
    http://office.microsoft.com/en-us/ac...49297.aspx#BM7
    http://social.msdn.microsoft.com/For...4-7af634955abb
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    dixonada is offline Novice
    Windows XP Access 2007
    Join Date
    Apr 2012
    Posts
    2

    Thumbs up

    Quote Originally Posted by June7 View Post
    Why do you need to duplicate data?
    Thanks for the info, but the question you posed was key. This database was inherited, so I went ahead and completely overhauled it in order to minimize any pushing or pulling of data. It's now lean & mean taking on anything.

    Thanks.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Request for an Example of eCount SQL
    By SwensrnTaz in forum Access
    Replies: 4
    Last Post: 03-12-2012, 11:56 AM
  2. Request to check relationships
    By adohertyd in forum Database Design
    Replies: 13
    Last Post: 12-19-2011, 04:18 PM
  3. Replies: 5
    Last Post: 05-20-2011, 06:18 AM
  4. Number operation request.
    By Playerpawn in forum Access
    Replies: 0
    Last Post: 05-18-2011, 11:29 AM
  5. request username and password
    By meysam_e2006 in forum Access
    Replies: 2
    Last Post: 07-02-2010, 02:03 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums