Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Check if new record added to DB

Status
Not open for further replies.

ianbar

Technical User
Jan 10, 2003
69
GB
I would like a reminder to appear when a new record has been added to the database. The reminder needs to prompt the user if they wish transfer some files (a seperate form performs this function). Any ideas?
 
Unfortunately, Access doesn't give you triggers so you
can't use an add trigger (which is what you would use in
other mainstream DBs i.e. Oracle, Sybase etc). If you are
allowing the addition of data to the database using one
of your forms only, then add code after the record
addition code on your form to popup a msgbox to give the
user the choice of selecting whether they want to open
the transfer files form itself then and there.

Regards...
 
I'll have to think this one over! Think I have an answer though! Thanks for the advice.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top