How does one view the SQL query that a button fires in Access? -

there existing access program need learn more about. there button in program that, when pressed, outputs excel file. queries tables within data.

how view raw sql code button utilizes generate excel file? button's properties, can see on click event "[embedded macro]". also, it's object type "query".

thank in advance.

---

in on click row (under event tab in properties), when click on ellipse next "[embedded macro]", presented expandable section containing these rows:

object type - query
object name - inv file query
output format - excel workbook (*.xlsx)
output file - (blank)
auto start - no
template file - (blank)
encoding - (blank)
output quality - print

i don't see logic (sql, vba, etc.) listed anywhere, however, how access construct excel file exports. how view logic? figure logic has stored somewhere because button return excel file populated data.

you have name of query used here.

the sql used in query called inv file query.

so need display query objects in nav pane (assuming 2007 onwards).

so choose this:

and of queries used in application display. if query inv file query not show, may hidden. (to fair, choose access objects - choose query). , hit f11 if nav pane not show.

if reason still not see query, want display hidden objects.

to display hidden objects right click on top part of nav pane (on query) this:

then: turn of options, , should able see/view sql used query called inv file query