Results 1 to 6 of 6

Concatenate fields with multiple values in a combo box

  1. #1
    KWasley is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Feb 2013
    Posts
    8

    Concatenate fields with multiple values in a combo box

    Hi,

    I'm in the process of creating a database for my company in which
    records are being kept on files that have been sent to different
    clients.

    My knowledge of code building is fairly basic, however, I am not
    completely clueless.

    What I need to achieve is a combo box, in a form
    which allows multiple values to be selected and then each column in the
    drop-down from the combo box to appear in the combo box list. So in my case, I
    would like both the clients name and their association to appear once all
    selections have been made rather than just the name which I am getting
    now.

    By using lookup wizard I have been able to select multiple values
    for a field using a form and when the combo box drops down for selection, each
    column that I have requested to be shown appears however only the first column


    will appear when all selections have been made.

    I have had success
    concatenating fields which do not store multiple values. However, when I follow
    the same method for the fields that do, I get an unnamed error code
    (1613). (See .jpg's attached)


    Click image for larger version. 

Name:	1.jpg 
Views:	11 
Size:	74.3 KB 
ID:	11234Click image for larger version. 

Name:	2.jpg 
Views:	10 
Size:	80.1 KB 
ID:	11235


    Any help would be appreciated.
    Thanks in advance.

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    48,578
    I REFUSE to use multi-value fields because of their issues.

    I just tested your scenario and it works. Can't replicate issue.

    If you want to provide db for analysis, follow instructions at bottom of my post.
    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
    KWasley is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Feb 2013
    Posts
    8
    Thanks for the reply, I understand why you dont use them now hah.

    I have been trying different methods in order to allow the user to access a report based on the record they have filled in using the form. With this version however, I can't really continue as of the error message that appears as shown.

    I have attatched the db. Help would be appreciated muchly.
    Thanks.
    Attached Files Attached Files

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    48,578
    Recommend different data structure. Consider:

    tblDrawings
    DwgNum
    DwgTitle
    CurrentRev
    Description
    RevType

    tblRecipients
    RecipientID
    LastName
    FirstName
    Association

    tblIssuers
    IssuerID
    LastName
    FirstName

    tblIssued
    IssuedID
    DwgNum
    IssuerID
    IssueDate

    tblIssuedTo
    IssuedID
    RecipientID
    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.

  5. #5
    KWasley is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Feb 2013
    Posts
    8
    Thanks for the reply once again. Sorry about being so late to get back to you but I have been busy.

    I managed to achieve what I wanted originally by using list boxes instead of combo ones. However I am still struggling to get my database to do what I want it to do and I think that you could help me if I manage to clearly describe what I want.

    Basically, the main thing that I am looking for is an interface which will let a user create a report which shows; a selection of drawings issued and a selection of recipients with how many copies of the drawings each recipient will have.

    Bear in mind that the selection of drawings will be the same for each recipient however the number of copies will be different for each.

    I have managed to create a database that will allow a user to enter a selection of drawings and recipients to print off in a report however, instead of appearing individually, it will show each drawing with all the recipients underneath each time. Showing the recipients several times rather than just the once which is required.

    Please don't hesitate to ask for any further information and any help would be appreciated in advance.
    Thanks.

  6. #6
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    48,578
    You are sending printouts, not digital file?

    I don't understand why the recipient would show several times.

    tblIssuedTo
    IssuedID
    RecipientID
    NumOfCopies
    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.

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

Similar Threads

  1. Replies: 1
    Last Post: 03-13-2012, 06:11 PM
  2. Replies: 1
    Last Post: 11-01-2011, 05:55 PM
  3. Replies: 3
    Last Post: 08-16-2011, 02:20 PM
  4. Look up values in multiple table fields
    By nmcentire in forum Programming
    Replies: 2
    Last Post: 11-12-2010, 02:02 PM
  5. Replies: 3
    Last Post: 10-16-2009, 09:27 AM

Posting Permissions

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