simple question (1 Viewer)

[GS1]

Hi

I've got a custom menu bar to launch forms and reports, as well as 2 append queries.

At the moment, I use openquery macros (in conjunction with the Sertwarnings command) to launch the append queries. This works OK, unless the user presses cancel on the query, where I get an ugly macro halt screen.

Could someone tell me how to use code to open the query instead?

Thanks

G

 

[Fizzio]

You can convert the macro to code via the access menu (but I cannot remember where!) I think you select the macro then in the menu, there is an option to convert macro to code. Someone may be able to tell you exactly where but have a hunt in the meantime

 

[GS1]

Thanks!