Using macro to delete value from a specific field in multiple reco

J

JJ1109

Hi, I'm... well, new to access macros. ie. I haven't done one! I'm sure it's
possible to do what I want done here via macro or some other way...

When the user updates a record, they change a yes/no field to "Y" that
indicates the records has been changed. Then I have a query that identifies
all these altered records and the user can print the updated reports for
those specific records.

What I want to do now is when they have printed the reports, the user can
click a button and all of the fields that are marked "Y" have the "Y"
cleared, so the next person that updates records and prints them won't be
re-printing what's already been done and finished.

More details available if I'm not being clear enough!

thanks
JJ
 
S

Steve Schapel

JJ,

Make an Update Query to re-set all the "Y" records. And then use an
OpenQuery in your macro (which you would assign on the Click event of the
command button), to run the Update Query.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SendObject Macro to multiple Recipients 1
Access Macro Repeat Expression using value of a field in table 0
Select multiple records to print from a form 3
Using a macro to print reports from multiple databases 5
Application.Printer in a Macro 7
Using Conditions In Macro 1
Use VBA Code to Assign Macro Buttons to use Different Queries for Source in a SubForm 0
Using Macros Set Value to fill in a field on a form 3

Top