Update query??

[Ron]

Hi All,

I have a report in my system, rptStatements, that I generate monthly for any
client who owes the business money. After the statement for each client
prints prints successfully, I'd like to have a comment put into the
tblComment file that a statement was generated for the client on this day,
for x amount (off the statement).

Possible?

What command... a call to an update query? If so, where do I put this
command?

On another report where I needed to update a field in a table after it
printed successfully, I added a form with all the details and ask the user
if it printed successfully and they can answer yes and it updates that
field, no and it doesn't...but it seems much more difficult for a run like
this to arrange something similar.

Suggestions?

TIA,
ron

 

[Wayne-I-M]

There are a few methods. The simplest (they are ones I like) would be to
create the update query and filter it using the same filter the prints the
report.

You could run the query from the same event as you use to print the report
on even on close of the report.

Basically
create the update query
run the report from some event
run the query from the same event
That way you can't forge to do it.

You will need to have "somewhere" to hold the data from the update query.
You could create a table to hold
ID
Date
Amounts
Notes
Ect

 

[hor vannara]

Hi All,

I have a report in my system, rptStatements, that I generate monthly for
any client who owes the business money. After the statement for each
client prints prints successfully, I'd like to have a comment put into the
tblComment file that a statement was generated for the client on this day,
for x amount (off the statement).

Possible?

What command... a call to an update query? If so, where do I put this
command?

On another report where I needed to update a field in a table after it
printed successfully, I added a form with all the details and ask the user
if it printed successfully and they can answer yes and it updates that
field, no and it doesn't...but it seems much more difficult for a run like
this to arrange something similar.

Suggestions?

TIA,
ron