Recordset and ![Field] 2

[CharlesFS]

How make "strsql" string get value of field in the current recordset line.

I tryed this:

Dim Rst As DAO.Recordset
Set Rst = CurrentDb.OpenRecordset("ConsultaIPE")
Dim Link As Variant
With Rst
  .MoveFirst
  While Not .EOF
   Dim strsql As String
...          
       strsql = "INSERT INTO CONSULTAIPE2 (link, documento) VALUES ([red]!Link , !documento[/red]);"
       DoCmd.RunSQL strsql
...     
       
    .MoveNext
  Wend
End With

 

[RoyVidar]

You are feeding the literals, you need the values, i e

[tt]... VALUES (" & !Link & ", " & !documento & ")"[/tt]

Now, this if for numeric fields, if the fields are text, you need text delimiters (for instance single quotes)

[tt]... VALUES ('" & !Link & "', '" & !documento & "')"[/tt]

or dates, where you'd need something more, check out Allen Brownes page

http://allenbrowne.com/ser-36.html

Roy-Vidar

 

[PHV]

Assuming that both field aren't defined as numeric in CONSULTAIPE2:

strsql = "INSERT INTO CONSULTAIPE2 (link,documento) VALUES " _
 & "('" & Replace(!Link, "'", "''") & "'" _
 & ",'" & Replace(!documento, "'", "''") & "')"

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[CharlesFS]

Thanks Guys!