INSERT INTO "record single"

[MS]

Hi all,

I have the sequent Query:
INSERT INTO TbFornitoriProdotti ( IdProdotto, IdFornitore )
SELECT TbProdotti.IDProdotto, TbOrdini.IdFornitore
FROM TbProdotti, TbOrdini;

I must change it in line up to record single
and to Load with RunSQL.
Thanks.
Marcello

 

[John Nurick]

Dim strSQL As String

strSQL = "INSERT INTO MyTable ( Field1, Field2 ) " _
& "VALUES ( 2, 'CIRIO' )"

DoCmd.RunSQL strSQL

(or, better,

CurrentDB.Execute strSQL, dbFailOnError

)

 

[MS]

Hi John

In my case what i must write
( 2, 'CIRIO' )????

 

[MS]

Hi John
The routine don't work.
The problem is..........
Instruction SQL don't correct. To Use 'DELETE', 'INSERT', 'PROCEDURE',
'SELECT' or 'UPDATE'
Marcello

 

[John Nurick]

What values do you want to insert into the new record?

 

[MS]

Hi John
INSERT INTO TbFornitoriProdotti ......
TbProdotti.IDProdotto, TbOrdini.IdFornitore FROM TbProdotti, TbOrdini
Marcello

 

[John Nurick]

Hi Marcello,

I still don't understand what record(s) you want to insert into
TbFornitoriProdotti. Please give examples.

 

[MS]

Hi John
I Must insert into TbFornitoriProdotti the news products
by Form.
If you want i send you E-mail
Marcello

 

[John Nurick]

Marcello,

I think that the language barrier is too great. I suggest that you ask
your question in the Italian newsgroup
microsoft.public.it.office.access.

You can reach this via http://groups.google.it/ and probably also via
http://support.microsoft.com/default.aspx?ln=IT