Recent content by Gingerale75

Thanks, however I'm not sure in which report should I copy this line. Should it be onto rpt_Products --> CustID properties --> double click event --> Event procedure? Private Sub CustID_DblClick(Cancel As Integer) DoCmd.OpenReport ReportName:="rpt_Customer", View:=acViewReport...

Hello All, I faced a problem where I couldn't figure out the solution. I'm not expert on Access but not a complete beginner either. There are two queries (Cust_1 & Cust_2), which collects customer details from two ODBC tables (one for each query). The ODBC tables include a customer ID field...

Hello All, Thanks for all your help, at the end I used the last solution from 'arnelgp' in Post #8 as it is not require another VBA function to introduce. Only one more question left, but I'm not sure if it's the right thread for it. The tables which included in the query are ODBC tables...

Thanks for your reply. In the meantime I think I figured out why I got the message during the first conversion. In the query expression I need to write the following: ConcatRelated([Text], [tblName], "ID = " & [ID], "Type = " & [Type]) which is translated by the VBA code to...

Hello All, I'm quite new on Access, however I have basic knowledge of queries, etc. also on VBA. I need to concatenate related fields, but not only on one level (which can be done with Allen Browne's code) but on two levels. The source table looks like this: ID Type Line Text 100...