What is the value of acFormatSNP

B

Bazza

VB6 - Sp6 showns this constant as empty?

I need to create a constant and need to know the value of acFormatSNP.

Thanks, Barry
 
B

Bazza

Duane,
Thanks for the prompt reply.
That was not what I expected. I am trying to create an access snapshot
report from VB.
My code looks like:

With objAccess2
.OpenCurrentDatabase filepath:=dbspath
.DoCmd.OpenReport rptNamex, acNormal, , , , args ' Create a print
.DoCmd.OpenReport rptNamex, acPreview, , , , args ' Create a preview
.DoCmd.OpenReport rptNamex, ???????, , , , args 'Create a
snapshot
End With

I thought that acFormatSNP would give me an integer to select a snapshot.
N.B. I have left out the logic to select the relvant line.

Does that make more sense.

Thanks, Bazza
 
D

Dirk Goldgar

Bazza said:
Duane,
Thanks for the prompt reply.
That was not what I expected. I am trying to create an access snapshot
report from VB.
My code looks like:

With objAccess2
.OpenCurrentDatabase filepath:=dbspath
.DoCmd.OpenReport rptNamex, acNormal, , , , args ' Create a
print .DoCmd.OpenReport rptNamex, acPreview, , , , args '
Create a preview .DoCmd.OpenReport rptNamex, ???????, , , ,
args 'Create a
snapshot
End With

I thought that acFormatSNP would give me an integer to select a
snapshot. N.B. I have left out the logic to select the relvant line.

Does that make more sense.
Click to expand...

PMFJI, but you can't use DoCmd.OpenReport to specify output to a
snapshot file. But you can use DoCmd.OutputTo, as in

DoCmd.OutputTo acOutputReport, rptNamex, _
acFormatSNP, "C:\Temp\" & rptNamex & ".snp"
 
Top