Magic Queries

[CylonLove4Life]

I'm showing a bunch of "magic queries" with names like:

~sq_cfrmSetGraphicReport~sq_clstLocations
~sq_cfrmSetGraphicReport~sq_clstMaps
~sq_dADTReport~sq_dADTSubReportAM
~sq_dADTReport~sq_dADTSubReportPM

I can view them using the QueryDefs collection. And sometimes I get error messages from them.

What are they? Where do they come from? How come they don't show up in the Queries tab in the main Access window?

 

[Remou]

These are system queries, for such things as forms, reports, combo boxes etc. You will find them listed in the MSysObjects table with more detail in the MSysQueries table.

 

[CylonLove4Life]

I see. Do you know the naming convention? What sq_d and sq_c are?

 

[Remou]

I can't say I know, but from observation I can say:

~sq_f
Form or subform based on table or query that has not been saved. If the form is based on a saved query, it does not have a system query entry.

~sq_r
Report based on table or query that has not been saved. If the report is based on a saved query, it does not have a system query entry.

~sq_c
Something that involves a query on a form, regardless of what type (system or saved) of query. This would include:
~sq_cMainFormName~sq_cSubformName
~sq_cMainFormName~sq_cComboName
~sq_cMainFormName~sq_cListName

~sq_d
Something that involves a query on a report, regardless of what type (system or saved) of query. This would include:
~sq_dMainReportName~sq_dSubreportName
~sq_dMainReportName~sq_dComboName
~sq_dMainReportName~sq_dListName

All of which is open to contradiction and correction.