Search results

  1. J

    Select the record with the largest value in Field 1 for each ID

    I have a table that intentionally permits duplicate values for a field called "ID". For each ID, there is a distinct date captured in a field called "DATE". In a query, I would like to select the largest date (most recent) for each ID. Any suggestions on how to do that would be very much...
  2. J

    Change field name in a table

    How do I change a field name in a table? I have tried the following (and several derivations of it) with no luck: Dim db As DAO.Database Dim rst As DAO.Recordset Dim field As DAO.field Set db As CurrentDb Set rst = db.OpenRecordset(TblName, dbOpenTable) Set field = rst.Fields("OldName") Set...
  3. J

    Handling close instead of send using SendObject

    I have SendObject set up and working. The user can press a button on a form that evokes the SendObject command, which in turn opens an MS Outlook mail message. If the user elects to send the message, there are no problems. If the user closes the mail message instead of sending it, the next...
  4. J

    Warning Messages

    Two part question. I have a database that removes and appends tables based on a search performed by the user. On my system I can turn off the confirmation messages by going through the tools/options menu. Is there a way to turn them off via code for any user on a different system in liu of...
Back
Top Bottom