To let you know i know nothing about codes and stuff so the following code could be wrong....what i am looking for is a way have access automatically send me an email when someone saves data in the form. can someone pleasae help me...........please..........please.........
What email program are your clients using? Outlook asks users whether or not they really want to send the email. Netscape may need the email addresses to be reentered manually. Eudora requires the user to enter their password. Opera and Pegasus mail programs do not support MAPI on which SendObject relies. Are you getting an error message? Did you put your code into the AfterUpdate event of the form?
I gave the code sample. You need to go to Your Form's Properties then Event Tab, Find After Update Event and click ... next to it. it will open VB code screen, add this sample code into that. though don't forget to change email addresses to what you need. they are fake address obviously. after that whenever a record changes, it will send you an email.
yes, also as sudbury said, you can hardly send an email without noticing the user. It is a security issue. to do that you need to create your own SMPT server, which entirely a different story. the code I gave tries to do it silently but it relies on the email software installed on the machine. therefore it is bound to rules of such softwares.
As far as a flashing border I don't know. HOWEVER, you can do what I have done and create a flashing LABEL, and thereby place whatever inside of it you need, though it won't be for data entry, only a flashing notification of something. Anyway here goes:
Go to the form of your choosing in Designview. DoubleClick the upper-left corner of the form and go to the Properties. When that opens scroll down to the OnTimer event and click on the (....) to open a module.
When it opens you will see "Private Sub Form_Timer()" on the top line and "End Sub" on the bottom.
In between those lines insert this:
Me.lblYourLabelName.Visible = Not Me.lblYourLabelName.Visible
What that means is for the label of my control names YourLabelName to be Visible and Not Visible so this is what you should end up with,(supposing you have a control named Transact Now:
Private Sub Form_Time()
Me.lblTransactNow.Visible = Not Me.lblTransactNow.Visible
Finally, on the property sheet you previously opened look just below the OnTimer event and see Interval. Play around with the Flashing Intervals that suit your need. Hint, 1000 flashes every Second.
That's it. As to whether it can be adapted to other things I have no idea.
Hope this helps out some.
I am using lotusnotes so i am not sure if the code will work and about the flashing label.....for some reason it does not work.....i go into the properties and there is no ontimer event and then go into the code builder and add the timer...(i put in the code) but when i go back to the form there is not an interval section either.....what am i doing wrong can this be done.....if its easier you can email me at email@example.com.....thanks for the help thusfar....its much appreciated...