Can I mimick a triggerr in Access

  • Thread starter Thread starter Paul Overway
  • Start date Start date
I have a table that will be populated by user input into a form.

A user will enter the full URL of a site. I only want to store the domain
name in my table.

In SQL Server I can write a trigger that once the user inserts a full URL,
will strip out all the unnecessary peices and update the URL field with the
only the domain name.

Is it possible to do something like this in Access?

I can probably do something in VBA before calling the INSERT but is there a
way to handle this sort of thing strictly on the database side?
 
If you are using a adp project in ms-access, then you can write triggers.

If you are using a mdb application, then you can simply use the before
update event of the form.
 
Back
Top