Search results

  1. I

    Creating Multiple Appointments from one form

    Brilliant, thank you so much for you help! I've learnt heaps from this
  2. I

    Creating Multiple Appointments from one form

    Sorry, just one more question, is it possible to build in to the code that if a date is blank it will move to the next date? I am sure it is simple but I am scared I might break the code if I do it wrong and end up back at square one
  3. I

    Creating Multiple Appointments from one form

    Legend! I moved the For i statement to before that line and it worked! Thank you so much :D
  4. I

    Creating Multiple Appointments from one form

    I tried adding the code in again and this time it worked! Well 1/3 did. I am not getting errors. Yay. But only the third appointment, DateBowlCut, is being created. Private Sub CreateAppt_Click() Me.Dirty = False If Me.chkAddedtoOutlook = True Then MsgBox "This appointment has...
  5. I

    Creating Multiple Appointments from one form

    I have taken the spaces out of the field names as you suggested and removed the brackets [] but I am still getting the object error.
  6. I

    Creating Multiple Appointments from one form

    Thanks for the code and the extra advise. I have tried integrating your code with mine and then running it on it's own but I keep getting an error regarding an object (either error 424 or 91) on this line: .Start = Nz(ctl, "") & " " & ("07:00") I've tried all sort of fixes but I just don't...
  7. I

    Creating Multiple Appointments from one form

    I have been putting together code from bits I have found online that will create an appointment in Outlook from a date field in my form. My form has a number of dates and I need to create appointments for each one. Is there any way I can incorporate that into the existing code? Or will I...
View older results
Back
Top Bottom