Trevor
04-09-2008, 01:06 PM
I am trying to run an insert query where there are 3 entry's into 2 colums of the same value, and I get a duplicate insert query error, thanks for helping
DoCmd.RunSQL "Insert InTo [IndividualSettingsTbl] (UserName,UserName,UserName)" _
& " Values ('" & AccountName & "','" & AccountName & "','" & AccountName & "');"
' the reason behind this multiple inert is becaue it is for more then 1 lookup accociated with that table, which will be called to later)
thanks for helping
DoCmd.RunSQL "Insert InTo [IndividualSettingsTbl] (UserName,UserName,UserName)" _
& " Values ('" & AccountName & "','" & AccountName & "','" & AccountName & "');"
' the reason behind this multiple inert is becaue it is for more then 1 lookup accociated with that table, which will be called to later)
thanks for helping