[AccessD] the value of Access constants

Yes.
On 4 Dec 2003 at 23:10, John W. Colby wrote:

> 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
> 
> 
> 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com

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