Search results

  1. D

    Insert Into + DLookUp + IF criteria

    Hello I'm trying to append a series of values into fields from one table to another based on highlighted rows in a multi-select listbox. I'm stuck however when I need to append a couple of fields which is based on a Dlookup kind of function and an IF function. My basic code is based on...
  2. D

    INSERT into + null

    Cracked it! Thanks for everyone's help. Private Sub cmdAddMems_Click() DoCmd.SetWarnings False Dim lbl1ID As Variant For Each lbl1ID In lstStudents.ItemsSelected DoCmd.RunSQL "INSERT into tblGroupMembers ([Student ID], [Group Code ID], [Surname], [First Name], [Class...
  3. D

    INSERT into + null

    Hi Ray Where would this go please? I'm not too hot on the syntax! cheers David
  4. D

    INSERT into + null

    Hi I'm attempting to insert multiple records from one table into another based on rows selected in a multiple list box. This all seems to be working OK until I get to a field where the value is null. What seems to happen then is the entire record isn't inserted into the new table ie it...
Back
Top Bottom