Adding records to a table from a list box using Visual Basic

Question

I am trying to allow users to double click on an item in a List box and then have the selected value (and some related values using SQL) input into a table that I have ready.

I would post the code that I have but the truth is I don't even know where to start so ANY help would be massively appreciated.

My List box (listResult) has 3 columns that I would like to be input into my table (Stock Conversion).

Thanks in advance,

Bob P

A good place to start is with a query built in the query design window that refers to the form you have created for data for an append query. You will then have some sql to play with. — Fionnuala
– Fionnuala, Commented Sep 28, 2012 at 14:49
Is there not some way of doing this with a line of code such as, but obviously not because it doesn't work, -- Stock Conversion.Update(listResult(0), listResult(1), listResult(2)) -- — Bob P
– Bob P, Commented Sep 28, 2012 at 14:54
Certainly, and when you post your sql, it will be a lot easier to say what to do. There are a dozen ways to skin this particular cat. — Fionnuala
– Fionnuala, Commented Sep 28, 2012 at 14:55

Fionnuala · Accepted Answer · 2012-09-28 15:04:48Z

1

One possibility:

Dim qdf As QueryDef

'Temporary query
Set qdf = CurrentDb.CreateQueryDef( _
       "", "Insert Into Table1 (atext,anumber) values ([p1],[p2])")

qdf.Parameters("[p1]") = "abc"
qdf.Parameters("[p2]") = 20
qdf.Execute dbFailOnError

answered Sep 28, 2012 at 15:04

Fionnuala

91.4k7 gold badges121 silver badges155 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Adding records to a table from a list box using Visual Basic

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related