syntax

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hi,
i do alot of combination and i didnt succeed :( to insert the boot
information:

strSQL = "insert into Exception values (" & Me!obligor_Id & ",rsobligor(0))"
dbs.Execute strSQL, dbFailOnError

thanks
 
Is rsobligor a local recordset variable?

If so then it should be:
strSQL = "insert into Exception values (" & Me!obligor_Id & "," &
rsobligor(0) & ")"

Cheers,
Jason Lepack
 
"didnt succeed" doesn't tell us much...

Assuming you want the value from rsobligor and not just a literal string),
try:

strSQL = "insert into Exception values (" & Me!obligor_Id & ", " &
rsobligor(0) & ")"

That assumes that Exception has only 2 fields in it, and that both of them
are numeric. If that's not the case, post back with details of the Exception
table.
 
You must log in or register to reply here.

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

to force commit 5
One cliff left to climb! INSERT INTO is copying incorrect records 1
Auto Entry Error 3
insert into syntax error 4
insert into table 2 fields instead of one 5
If a record doesn't exist 12
Allen Brown copy record from form and subform 6
Key Violations - This might help someone 2

Back
Top