Search results

  1. J

    Multiple Rows Into One Row comma delimeted string using Access

    Thanks for providing that link "Beetle", I really appreciate your help. It seems to be hanging up on this part of the code: 'Dim rs As DAO.Recordset and then it highlights in yellow: Function Concatenate(pstrSQL As String, _ Optional pstrDelim As String = ", ") _ As String...
  2. J

    How to set up list box to create new records based on selections

    I am trying to create a form that has list box controls for months (period), and when selected it takes all of the data currently on the form and copies it for each month selected. This will help speed up data entry, rather than entering the details in the form each time. In other words, I...
  3. J

    Multiple Rows Into One Row comma delimeted string using Access

    Any wise guys out there? I have been trying to get this to work for hours, but lack the experience to pull it off. I have provided an example with the names of my actual table and fields. Table name: eventlog SELECT e.period, e.center, e.event FROM [eventlog] as e results in this...
Back
Top Bottom