Emailing Forms

[tlandis]

I want to email a form that is based off multiple tables. I tried using the "Create Email" button but it won't let me select fields from multiple tables. When I create a form and select the "Email" button, the form doesn't retain the formatting. Any suggestions?

 

[John Big Booty]

Welcome to the Forum.

Forms are really designed to allow your user to interact with the data in the underlying tables. What you need to do is create a Report that replicates the look of the form you are trying to Email.

If you are using '07 or latter you can easily send your report as a PDF document. If you are using an earlier version it may be easier to send the Report in Snap Shot format and give the recipient a link to the free Snap Shot viewer.

 

[tlandis]

I am using the form to collect and import data.

 

[tlandis]

Just to clarify...

I am collecting data for 3 different tables from outside sources. So i need the person I email the form to, to be able to enter info and email it back to me and then import the data into the tables. Can I do this with a form linking to 3 tables? I know how to do it from a form using 1 table.

 

[John Big Booty]

Simply emailing the form will not allow you to collect data from a remote source as the form will not be bound to any table.

You could get your external source to submit the required data via an Excel spreadsheet and then import that into your DB.

Another method might be to supply your external source with a DB that allows them to enter the data, into their copy of the DB and then on the press of a button exports the data, you require, to and Excel spreadsheet and email that to you for import into your copy of the DB.

If you are using Access '10, I believe that you may be able to set it up so your external source can access the DB over the Internet (I have not used Access '10, so have no knowledge of how this works).

 

[tlandis]

My form is linked to a query. Through Outlook you can email forms and have the returned data automatically populate your tables. I got it to work by linking to a query which links to the 3 tables.

 

[GaryPanic]

interesting .. when you have this resolved you might want to do a sample d/b and up load .. as I am sure that this would be of interest to a lot of people

all the best

Gary..

 

[John Big Booty]

interesting .. when you have this resolved you might want to do a sample d/b and up load .. as I am sure that this would be of interest to a lot of people

all the best

Gary..

I'll second that motion

@tlandis, BTW what version of Access are you using?