Search results

That is genius. Thanks.

I have that part of it. The tricky part is selecting one record for each ID. Suppose I I have 5 records in a table. The first three have an ID of "1", and the second two have an ID of "2". I would like the query to select two records. The first record corrosponds to the record that has an...

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...

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...

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...

It is always something extremely easy. I used DoCmd.SetWarnings False and it works great. I couldn't find that simple command in the help or in any of the books. Thanks.

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...