Can I mimick a triggerr in Access

[Paul Overway]

No....Jet doesn't provide for triggers. You'll have to use VBA.

 

[Dave]

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?

 

[Albert D. Kallal]

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.

 

[Dave]

Thanks guys