B
bbxrider
from a vb program, i want to give user the functionality of exporting an
access report where they can choose the location and file type eg. .rtf
been trying to invoke the access preview with this but nothing comes up and
no error msg: (when using acNormal the report gets sent to default printer
ok)
strFilter = ""
strWhere = "dbVariable = somevalue"
objAccess.DoCmd.OpenReport "rptName", acPreview, strFilter, strWhere
While objAccess.SysCmd(acSysCmdGetObjectState, acReport, "voldatarpt1") =
acObjStateOpen
DoEvents
Wend
if i can't actually bring up the access preview or print window for the
report, i would do it 'silently' by separately obtaining the directory and
file type with vb input stuff but can't find in my access object the methods
for export/filetype/etc
access report where they can choose the location and file type eg. .rtf
been trying to invoke the access preview with this but nothing comes up and
no error msg: (when using acNormal the report gets sent to default printer
ok)
strFilter = ""
strWhere = "dbVariable = somevalue"
objAccess.DoCmd.OpenReport "rptName", acPreview, strFilter, strWhere
While objAccess.SysCmd(acSysCmdGetObjectState, acReport, "voldatarpt1") =
acObjStateOpen
DoEvents
Wend
if i can't actually bring up the access preview or print window for the
report, i would do it 'silently' by separately obtaining the directory and
file type with vb input stuff but can't find in my access object the methods
for export/filetype/etc