Create a Table with Multiple Values Listbox

C

ChemEnger

Joined
Jan 30, 2012
Messages
1
Reaction score
0
Hi,

I have a list (of conferences) with associated information (staff - multiple - attending) in MS Project and I'm pulling this into Access to store.

I have created a permanent table in Access which includes a Multiple Value Listbox to store the staff information.

I am using a temporary table to bring in all the information from MS project and store it until needed in the 'permanent' database table.

I am using SQL CREATE TABLE to, well, create the table, but I can't find a away to programmatically create a multiple value field.

I know that a more rigorous method would be to create a linked table to store the staff attending information, but I prefer (in this instance) the display of the information on / in a single line (in the listbox).

Any help greatly appreciated.


Many thanks,

Simon
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Storing Multiple Selections from a list box 3
Create Table with Date Appended 3
Pass multiple selected values from list box to table 5
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Access Access, problem with query. 5
multiselect listbox code 2
Create Multiple Index 1
How do you populate a listbox based on a combo box selection in ms access? 1

Top