[AccessD] the value of Access constants

John W. Colby jcolby at colbyconsulting.com
Thu Dec 4 22:10:00 CST 2003


Well... that makes it easy.  So if you want to feed the text, you have to
feed that whole string - "Snapshot Format (*.snp)"?

John W. Colby
www.ColbyConsulting.com

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Stuart
McLachlan
Sent: Thursday, December 04, 2003 11:03 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] the value of Access constants


On 4 Dec 2003 at 22:48, John W. Colby wrote:

> I need to know the value of the constants acFormatSNP, acFormatRTF etc.
If
> I go to the debug window and input:
>
> ?acFormatSNP
>
> I get:
>
> Snapshot Format (*.snp)
>
> I need the actual integer (or long?) value of the constant so I can store
it
> in a lookup table and allow selecting the kind of report I want using the
> docmd.outputto.
>
> Does anyone know how to see the actual numeric value of this thing?
>

Doesn't have one. It's a text constant, not a numeric.
acFormatSNP =  "Snapshot Format (*.snp)"

Open the VBA Object Browser Window and look at Access.Constants
All the acFormatxxx constants are listed as string values.


--
Lexacorp Ltd
http://www.lexacorp.com.pg
Information Technology Consultancy, Software Development,System
Support.



_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com





More information about the AccessD mailing list