Macro writing (1 Viewer)

[Rizwan Amin]

I want to write a macro which will open a dailog box and ask for search parameters, these parameters belong to different tables of a database which possesses data of an Human Resource Department, after asking for parameters the macro should create a report which displays the matching results.

 

[ahenduck]

If I were to tackle this problem I would take it in three steps. First, I would make a parameter query that includes the tables necessary to get my answer. Second, I would construct a report which would show my answer in an acceptable format. Third, I would build a macro using OpenQuery and OpenReport actions in order to tie the whole process together. You could build a form based on the parameter query in order to capture the search criteria, but it is not necessary. Be sure to give the parameters meaningful names in your query, and your process will be more readable.