Access information sharing

M

mpdpilot

I was wondering if there was a way to send information to another computer in
a form or anywhere else for that matter.

I have a database and I need to send a copy of each form to another person
everytime a new record is created. Idealy it needs to be easy so
non-computer-savy people can do it.
 
A

Arvin Meyer [MVP]

Why not just use the database as it was designed, and simply put the data on
a server and connect a front-end (forms, reports, etc.) to it from each
workstation?
 
D

Daniel

1-Create an account on the db for them with an email notification when a new
record is created.

2- create a report that gets generated whenever a new record is created,
convert it to a pdf and email it.
 
M

mpdpilot

I like the sound of this. Could you give me any mor information on how to do
this.

joe
 
T

Tony Toews [MVP]

mpdpilot said:
I like the sound of this. Could you give me any mor information on how to do
this.

A2000ReportToPDF is an Access 2000 database containing a function to convert Reports
and Snapshot files to PDF documents. No PDF Printer driver is required.
http://www.lebans.com/reporttopdf.htm

For a page on how to print a report for a single record and how to generate reports
to attach to emails see the Emailing reports as attachments from Microsoft Access
page at http://www.granite.ab.ca/access/email/reportsasattachments.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 
A

Arvin Meyer [MVP]

Tony answered how to create the report as a pdf. Here is some code to email
it:

http://www.datastrat.com/Code/OutlookEmail.txt

That code is for a command button (Command0). You can rewrite it as a
subroutine, or simply call it. If you use the latter, you have both an email
button and and automatic email routine by just doing something like:

Sub Form_BeforeUpdate()
If Me.NewRecord = True Then
Command0_Click
End If
End Sub
 
Top