Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2011
    Posts
    2

    Unanswered: Update all records on a form

    Hi,
    I have a form that queries around 25 records (a class). The user enters information about attendance and some other things and then I would like all of the 25 records updated with a date, rather than entered on each record. I would like the user to see and double check the date. How is the best way for this? Update query?

  2. #2
    Join Date
    Aug 2011
    Location
    Richmond, VA
    Posts
    38
    I'd put a text box with a date format on the form and then put a msgbox in the VBA script connected to the button that kicks off the procedure. i.e.

    Response = MsgBox("All records will be updated with the date " & Me.txtDate & _
    "Do you wish to continue?", vbYesNo)

    If Response = vbYes Then
    DoCmd****nSQL "Update MyTable Set MyDate = Me.txtDate"
    Else
    Exit Sub
    End If

    Something along those lines.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •