the proper syntax is Insert File (Field1,field2,..) VALUES (V1,V2,...)
--- In [email protected], Lyanne Rheeza Ong <[EMAIL PROTECTED]> wrote:
>
> Hello everyone,
>
> this is a code i created to be able to get the multiple users i
have selected in the form. i was able to select the users in the form
an select folder however i am unable to save the user name to the
table. i am able to save the folder name. what should i do?
>
> [code]
> Dim vtr As Variant
> Dim frm As Form, ctl As Control
> Set frm = Forms!Form_Assign
> ctl = frm!listFolderUserList
> ctr = ctl.ItemsSelected.count
>
> If ctr > 0 Then
> selList = ctl.ItemsSelected
> FolderID = Me.FolderName.Value
> For Each vtr In Me.listFolderUserList.ItemsSelected
> usrID = Me.listFolderUserList.ItemData(vtr)
> sqlStr = "Insert into FolderLDAP (FolderID, UserID) " _
> + "(" + FolderID + "," + usrID + ")"
> CurrentDb.Execute sqlStr, dbFailOnError
>
> Next
> End If
> [/code]
> please help!
> thanks,
> lyanne
>
>
>
> L y a n n e R h e e z a C. O n g
>
>
>
>
>
>
> ---------------------------------
> Looking for last minute shopping deals? Find them fast with Yahoo!
Search.
>
> [Non-text portions of this message have been removed]
>
