Hi Antonio,
I wanted something exactly the same. I used the Northwind
sample database that ships with Access as a guide (97
version). Take a look at a form called "Startup" in that
database. It does exactly what you desire. That form will
continue to display at startup until you put a check in
that box that says "Do not show this screen again."
That form uses some code found in a module that is also
called "Startup." Study that module code and you should be
able to figure what is going on. When that checkbox is
checked, it changes the startup form to "None." I just
changed that to open my main switchboard form.
On my EULA form I just put two command buttons, "Accept"
and "Decline" along with the checkbox. My EULA form
continues to show every time the database is opened until
that checkbox is checked AND they hit Accept. I added some
logic to account for the fact that someone could put a
check in the checkbox and then hit Decline. All works
perfectly.
A word of caution: if you have implemented Access User
Level Security, then that complicates things. You need to
be a member of the Admins group to change startup
properties.
Study that form and module in Northwind and you should be
able to figure out how to do this. If you run into
problems, just post back here. I should be able to help on
this (surprisingly).
Jeff Conrad
Bend, Oregon