Hello, i need help please, i need to create an trigger in ms access 2007, probably by vb code, but don't know how. The issue: i created a database in ms access 2007 and i need to make an time trigger to show every time when opening the database (it opens and shows first switchboard) a 6 weeks ahead (trigger) of expiring time of different data entries in the "permit expire" fields of one of my created tables or reports. If possible flashing dates or anything similar. I was checking thru 3 different tutorials for ms access 2007 but can't find an solution. What are my options? And how can i go about it?