email a Access form as it looks on the screen...I'm a Dunce!

[MMcCarthy]

Thanks again Mary, I've just asked NeoPa if I could use excel in some way to transfer stuff and then lo and behold your suggestion appeared on my screen. This looks very promising now. Thanks. When you say export....is that complicated or a simple copy and paste funtion?

When the report is open go to File - Export. When the window opens to save the file change the 'Save as type' from Microsoft Access to Microsoft Excel and then click save.

Mary

[dexyowl]

When the report is open go to File - Export. When the window opens to save the file change the 'Save as type' from Microsoft Access to Microsoft Excel and then click save.

Mary

You're a star! I'll give it a bash and see how we go. Thanks go to you and the others who've helped me. I'll let you know how I get on. I'm afraid the file may grow too large to send, but then again...I can send only the most recent. Great! thanks

[NeoPa]

Avoid sending a Report via Excel!
You will have more new problems than solved old ones.
However, as it's the underlying data you want to copy/paste, do one of two things :

1. Basic - Open the table with the data you want to transfer then copy/paste into Excel.
2. Design a query (We can help assuming you provide the relevant MetaData) and run that every time. Copying/pasting the results into Excel.

The beauty of the second approach is that it can select only new records, or only records entered or changed since a particular date. Obviously, this could only work this way if there is a DateTime field in your table which is updated to reflect the date when edited.

[apartain]

May I suggest looking into Microsoft InfoPath? InfoPath is a form-creation software (included in the new MS Office Ulitmate suite) which allows you to enter information into a form, and since the information is actually stored WITHIN the form, it can be emailed back and forth. You can connect your InfoPath form to your Access database and set it up to automatically update it when you open the form.

InfoPath is easy to use and straight-forward. You drag and drop fields to create your forms, and there are wizards to help you along with connecting the forms to your databases.