[AccessD] SetOption "Default File Format", 0

Hi Dan

I have no idea. Perhaps they mixed up Value with ListIndex ...

/gustav

>>> dwaters at usinternet.com 11-12-2004 15:38:50 >>>
Gustav,

Thanks for this help!

But I wonder why you say 9 not 0.  I looked at help for the SetOption
method
and this value setting is supposed to correspond to the row number in
the
combobox (0 - based).  Access 2000 is the first choice in that list so
I was
using a 0.

Dan

-----Original Message-----
From: accessd-bounces at databaseadvisors.com 
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav
Brock
Sent: Saturday, December 11, 2004 4:15 AM
To: accessd at databaseadvisors.com 
Subject: Re: [AccessD] SetOption "Default File Format", 0

Hi Dan

It is not 0 but 9:

  SetOption "Default File Format", acFileFormatAccess2000

Browse the on-line help for "FileFormat Property"

/gustav


>>> dwaters at usinternet.com 10-12-2004 23:47:26 >>>
I'm trying to set the Default File Format to 'Access 2000' in code
during
startup.  The code should be:

        SetOption "Default File Format", 0

But - I'm getting an error which says:   The numeric value for the
setting
argument in the SetOption method doesn't correspond to any list box or
option group settings in the Options dialog box.

I set many options on startup, but this is the only one that doesn't
seem to
work as advertised.

Has anyone tried this to set this option in code?

Dan Waters
ProMation Systems 

--