By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,610 Members | 935 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,610 IT Pros & Developers. It's quick & easy.

updating a table, after pressing a button on a form

P: n/a
this is probably basic, however I ahve a form with number of buttons
and upon pressing certain buttons as part of hte buttons press
function, i would like to update a table (communications) with basic
information.

eg, pressing teh EMAIL button , after sending a outlook message i want
funtion to update the [communications]
table with current date.time pdatetimefield], also then a text field
in [communications] table with "EMAILED"

please help, how do I do this from pressing a button and calling a
function ???

Jun 5 '07 #1
Share this Question
Share on Google+
1 Reply

P: n/a

"GlennMBella2<" <g.*******@optusnet.com.auwrote in message
news:11**********************@p77g2000hsh.googlegr oups.com...
this is probably basic, however I ahve a form with number of buttons
and upon pressing certain buttons as part of hte buttons press
function, i would like to update a table (communications) with basic
information.

eg, pressing teh EMAIL button , after sending a outlook message i want
funtion to update the [communications]
table with current date.time pdatetimefield], also then a text field
in [communications] table with "EMAILED"

please help, how do I do this from pressing a button and calling a
function ???
You write VBA code to accomplish what you want, or you search and find some
code that does it or something similar to use, and place that code either in
a standard Module in your database to be called from code in the Click event
of the button, or place it directly in the Click event of the button. You'll
find information about sending e-mail from Access at the FAQ site,
http://www.mvps.org/access -- it's full of good information.

Larry Linson
Microsoft Access MVP

Jun 5 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.