J
Janis
I have an Excel report output from Access. I need to change the fields in
the report. In the Excel macros you can't tell what the field definition
names are. There is a temporary table created from the make query reports
that I would like to look at the fields names. What I want to know is how do
I get access to the temporary table before it creates the report?
Here is the query:
if bEntireCompany = true Then
'sTempQry = "qryMake_Co_Signage"
sQryNm = Rpt_Co_Signage"
sEventDetail = tblTEMP_CO_EventDetaiol"
Else
xxxx
End If
the else part doesn't matter to me at this point because the report I am
dealing with has the entire company flag.
I just need a printed list of all the fields and the ID fields. I think it
may have what I want in this temporary table but I don't know where it is
stored or if it is deleted? In the report the names are changed to just the
field labels.
tnx,
the report. In the Excel macros you can't tell what the field definition
names are. There is a temporary table created from the make query reports
that I would like to look at the fields names. What I want to know is how do
I get access to the temporary table before it creates the report?
Here is the query:
if bEntireCompany = true Then
'sTempQry = "qryMake_Co_Signage"
sQryNm = Rpt_Co_Signage"
sEventDetail = tblTEMP_CO_EventDetaiol"
Else
xxxx
End If
the else part doesn't matter to me at this point because the report I am
dealing with has the entire company flag.
I just need a printed list of all the fields and the ID fields. I think it
may have what I want in this temporary table but I don't know where it is
stored or if it is deleted? In the report the names are changed to just the
field labels.
tnx,