I'm using Access 2003 This is a general outline of what needs to be done. Update: Ok I've tested, using Excel 2007 but will be basically the same for all versions, and added graphics to show the entire process. I have an Access (2010) tbl Bookings with a Date Completed field.
For example, say you would like to include donors whose records show no activity during the last six months in a special fund-raising appeal. Follow these steps: Now each time a user changes a record, Access will enter the date and time from the system before the changes are updated.I would like to enter a date into the Excel Date Completed field in the Excel linked tbl and have it update the Access Date completed field.Is the problem I have related to the fact the Excel file is a "Template"......which is after completion saved under a different name ?Check out the Microsoft Access archive and catch up on other Access tips.Help users increase productivity by automatically signing up for Tech Republic's free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.Unlike stored procedures (which also support parameters), these parameterized functions can be updateable, as you'll see later in this chapter.