Hi,
I currently use Access as a frontend with linked tables to a MySQL backend.
I'm need to be able to build a single string containing the field values from several records. In other words I need to be able to gather employee id's and surname's based on variant criteria from an employee table and stitch them together into a single string.
I'm currently achieving this by populating a list box and then using listbox.itemsSelected, Listbox.ItemData etc to build the string. I want though to avoid using a listbox or similar control and instead gather the data in an array or temporary recordset from where I can build the required string.
Can anyone help here? I have no idea what the required syntax is for either populating an array from a table (linked or otherwise) or how to reference that data once in the array. I'm hoping to build a two dimensional array.
From what I've seen in other threads, ADODB or DAO seems to be the way to go although my knowledge in this area is virtually nil .
Tks,
Dave
I currently use Access as a frontend with linked tables to a MySQL backend.
I'm need to be able to build a single string containing the field values from several records. In other words I need to be able to gather employee id's and surname's based on variant criteria from an employee table and stitch them together into a single string.
I'm currently achieving this by populating a list box and then using listbox.itemsSelected, Listbox.ItemData etc to build the string. I want though to avoid using a listbox or similar control and instead gather the data in an array or temporary recordset from where I can build the required string.
Can anyone help here? I have no idea what the required syntax is for either populating an array from a table (linked or otherwise) or how to reference that data once in the array. I'm hoping to build a two dimensional array.
From what I've seen in other threads, ADODB or DAO seems to be the way to go although my knowledge in this area is virtually nil .
Tks,
Dave
