Creating Macros

[Bvincey2002]

I want to create a macro that will automatically run when I open my database and check to make sure that my sums are accurate.



What I have are 3 querys one Distributor, Dealer, and Aggragate. The Aggragate should equal Distributor+Dealer, and I want to create an automatic macro that will make sure that the above is always true and I would like to have a pop up window warn me when this is not true. Is this possible if so can I get some help setting this up since I am a beginner with access. Thank you

[asmores]

There is a few different ways you can do this but i think the best method for you would be to either use a conditional statement within the macro for your popup message and then save the macro as "Autoexec," this will mkae the macro run automatically on open. Another method would be to set up an additional query with an "iif" statement and again saving as Autoexec.

[Bvincey2002]

How would I set the macro up to make it automatically determine if everything is equal, and if the aggragate is not equal to Distributor+Dealer then the macro will show me the pop up?

[ssanfu]

Just curious. If you are using the same dataset for all three queries, how can the aggragate not be equal to Distributor+Dealer?

[Bvincey2002]

When I was creating the Queries for some reason they did not pull all orders for the aggragate and distributor. The information was all imported into the table but when I ran the query specific orders were not included. I want place an automatic check so I dont have to double check my values every time I pull the reports.

[asmores]

Rather then using a pop up and complicating your database try using a force. When you are linking your tables right click on the thin line between the tables and chioce the appropiate link type to include all of your records, this way you will not need to double check it.

[ssanfu]

Got it. I've had issues like that.

I wouldn't use a macro (I never use macros).

But you could do this easily in code. Open the 3 queries, add the two and compare to the third. If different values, the pop up a message box or display a label on the main form.

[Bvincey2002]

I do not know how to use codes. I am very green beginner .