Create a Macro to check ID

[tony wong]

i wish to create a macro to check the integrity of database, like that

if max(TableA.ID) <> max(TableB.ID) then
msgbox("ID not matched")

How can i make it in macro look?

Thanks a lot.

Tony

 

[Steve Schapel]

Tony,

You can make a macro with the MsgBox action.

In the Condition of the macro, you can enter the equivalent of this:

DMax("[ID]","TableA")<>DMax("[ID]","TableB")

(If you don't see the Condition column in the macro design window,
select it from the View menu.)

 

[tony wong]

Thanks a lot. Steve

Tony,

You can make a macro with the MsgBox action.

In the Condition of the macro, you can enter the equivalent of this:

DMax("[ID]","TableA")<>DMax("[ID]","TableB")

(If you don't see the Condition column in the macro design window, select
it from the View menu.)

--
Steve Schapel, Microsoft Access MVP

i wish to create a macro to check the integrity of database, like that

if max(TableA.ID) <> max(TableB.ID) then
msgbox("ID not matched")

How can i make it in macro look?

Thanks a lot.

Tony