I would like to put together a macro in Excel that looks at an Access table and displays a MsgBox with the last(highest) ID number from said table.
The Excel spreadsheet would be located on end users computers in various locations.
The Access database is located at: "D:\Users\Henry\Desktop\Tracking.accdb" from all computers.
The table name is: "Tbl-Form" and the field name is "ID".
If you can provide pointers to examples, I would appreciate it.
Thanks in advance!!
Bookmarks