Re: Update Records Export

There is no way for Access "know" if the export worked or the report was
printed.
When I need to confirm this type of activity, I add 2 fields to the detail
table.

ExportID Long integer
ExportC Yes / No

Before doing the report or export, I write one export ID number into all the
records selected.
Once the export or report is completed the user will use the export ID to
set ExportC to true.

"Toby Gallier" <azroth@xxxxxxxxx> wrote in message
news:1193693947.153492.33160@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I am trying to figure out a way to update multiple records when a
report is exported. Each record has a "Status" field. I have a query
that selects all records with a status of "To Send" and that feeds
into a report. When the report is exported i want the status to be
changed from "To Send" to "Sent".

Any help would be appreciated.

Thanks!



.

Relevant Pages

  • Even as I write this I know Ive set it up wrong.....
    ... The database has a form which feeds into a table. ... How can I compile a query and then a report which will tell me how ... query / report that details how many requests there have been for each ...
    (microsoft.public.access.queries)
  • Re: Sub-reports causes multiple parameter prompts
    ... There is only one query that feeds all 5 reports. ... One of the parameter prompts is in a query that the final query pulls from ... >>I have a set of 5 Report objects that all pull from the same Query. ...
    (microsoft.public.access.reports)
  • Re: Sorting Report by combo
    ... Create a query that uses both the main table for the report, ... table that feeds the combo. ... You may need to use an outer join in the query to get all records. ... Sorting & Grouping doesnt seem to have such option, ...
    (microsoft.public.access.reports)
  • RE: View Columns Horizontally Access 2007
    ... Post the SQL of your query that feeds the report. ... KARL DEWEY ...
    (microsoft.public.access.reports)
  • Form Criteria for Query to generate Report
    ... I have created a form that feeds a query, ... report based on the choices I've made on the form. ... So, If I want to view all of the countries or all of the customers, I ...
    (microsoft.public.access.forms)