Need some help with a few different things

[Unimatrix]

Hi there,

I need to pick someone's brains with the few queries I have with Access listed below.

1:- Emailing data entered on a form.
I have a made a rough call logging datababse, this allows users to log information about calls that they take. From time to time it will be required for the user to submit a refund request. What I am wanting to do is have this on a seperate form that the user can open and have it automatically populate with some of the information from the main call log form. Once they have completed the credit request form I would like to have a button on there that they can click which will email that record to a pre-defined email address with a pre-defined subject.

2:- Populating a Excel spreedsheet with data from a particular record
I have a form where various bits of customer information is stored, Is it possible to create a button that will automatically export certain fields from the form and put them into a spreedsheet in the appropriate fields.

3:- Linking data from one form to another
On a form I have a field for Support Agent, What I would like to do is when someone selects this agent from a drop down list that persons details automatically fill into the contact fields on this form. Can this be done?

Sorry if these are a bit silly but as you can tell I am a access muppet

 

[The_Doc_Man]

3:- Linking data from one form to another

If both forms are open on the same workstation and in the same Access workspace, from form 1 it is SOMETHING like Forms("form2")!Controlname.value

In the help file, use the topical index for "Working with Forms" and drill down from there.

2:- Populating a Excel spreedsheet with data from a particular record

This is a very advanced function. Your longer description further qualifies this to a specific row/column in the spreadsheet. The only way to get THIS specific is to open the spreadsheet. If you LINK to the spreadsheet and make it a faux table, you cannot update it (if I recall correctly.) But if you open the spreadsheet as an application object and manipulate it through vba, you have a shot. If you are not comfortable with VBA, you cannot get there any other way.

In the help file, search for help on "Application Objects"

1:- Emailing data entered on a form.

I believe there is a "SendObject" method that would do what you wanted, but look up SENDOBJECT in the help files and see where it takes you. If you have Outlook installed, Access knows now to send through that. You might also look up "Outlook" in the help files.

Again, there is the issue that data entered on a form doesn't really exist in a record unless you saved it some way. like in a table. No place else has much permanence.