Re: Update Records Export

"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!

Create a procedure that performs the export, then add an update query that
changes the records from "To Send" to "Sent".

''''Sample - AirCode
Public Sub ExportReport()
DoCmd.OutputTo acOutputReport, "MyReport", acFormatSNP,
"C:\MyReport.snp", 0
DoCmd.RunSQL "UPDATE MyTable SET [Status]='Sent' WHERE [Status]='To
Send'"
End Sub

Fred Zuckerman



.

Relevant Pages

  • RE: Message box popup
    ... the query. ... makes more sense just to open the report or form that you are using the query ... Public Sub Form_Load ... Dim strMsg as string ...
    (microsoft.public.access.queries)
  • Re: Dynamic query - how to pass it into a report
    ... Create a query with the following SQL: ... and use that query as the RecordSource for the report. ... Public Sub cmdRun_Click ... Dim stDocName As String ...
    (microsoft.public.access.modulesdaovba)
  • Re: Populating a list -- table structure?
    ... I had made a report already and figured out about adding the ... your responce below, but thanks to your help with SQL, I was able to get the ... It takes a summary from a select query and gives the ... KitID, long integer ...
    (microsoft.public.access.forms)
  • Re: Fields in Label dont give correct information
    ... You need to create a query based on tblRegEvent and tblRegPayment. ... -If your DCountis to count values in your report, ... half the time with very few errors (other than that label problem I had.) ... For example in the Room assignment on the report an idividual will be ...
    (microsoft.public.access.reports)
  • Re: Tips on domain aggregate replacements
    ... This already is a split db, but the users are 400 miles away from the server hosting the data:) They are all running the same copy of the FE locally on a single terminal server via TS/RDP sessions. ... It doesn't seem to have much impact on performance; the report takes just about as long to run if they are all logged in as it does when I am logged on testing it at night. ... I would do DSums from the controls on the report on the data returned by the query. ... The biggest offender is a certain report that needs to Sum a particular complex total for each of the next twelve months (the DSum in VBA was a sideline to this issue) and present these as items on each line of output. ...
    (microsoft.public.access.modulesdaovba)