RE: How do I send a copy of a form to someone else

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance



Hi

Quite hard in access 2k3 - But can (almost) be done.

Design a report that looks sort of like your form.
Tip -don't use lines in your report - use strings in a unbonound text box

Then (assuming you have the e mail address of the recipient somewhere) just
email that report using OutputTo as an RTF file (lines don't work in RTF's
but strings do)

If you have problems post back





--
Wayne
Trentino, Italia.



"Tiny_Tim" wrote:

Hi All,

I have created a database in A2003 that I will be using for material
requisitioning. It consists of name, dept, date, quantity of item, item, cost
of item, source address and some other bits and pieces. What I would like to
be able to do at the end of filling in a form is email a copy in a readable
format to a college in another office. Ideally it would be in an identical
format to the form as I am trying to reduce the amount of paper that gets
passed from office to office and have designed my form to match existing
paper work.

If possible I would like to include a button for doing this on the form.

Whilst I am not a novice to Pc's my knowledge of access is a bit lacking so
any help would be greatly appreciated.
--
TimBo
.



Relevant Pages

  • Re: ISE software bug???
    ... The design & report files attached below. ... TIMING REPORT ... Add Generic Clock Buffer: 8 ...
    (comp.arch.fpga)
  • Re: Date range on reports
    ... box to your report with a control source like: ... > In the Database window (Database window: The window that appears when you ... > In the New Form dialog box, click Design View, and click OK. ... > Begin by clicking Macro Names to display the Macro Name column. ...
    (microsoft.public.access.reports)
  • Re: Date range on reports
    ... Create an unbound form (unbound form or report: A form or report that isn't ... In the Database window (Database window: The window that appears when you ... In the New Form dialog box, click Design View, and click OK. ... Begin by clicking Macro Names to display the Macro Name column. ...
    (microsoft.public.access.reports)
  • RE: Multiply qty of filtered records
    ... If you should want to try doing this with a query (which is probably the more ... etc in the bottom part of the design view. ... I do know how to get this information in a Report, ... Dim rs As DAO.Recordset ...
    (microsoft.public.access.modulesdaovba)
  • Re: Excel 2007 auto format pivot table
    ... on the Design Tab you can select from ... Pivot Style Options ... heavy styles don't actually format the report at all. ...
    (microsoft.public.excel)