[AccessD] Read the "Options, Tab Width" setting of the the VBE Options from VBA?

Gustav Brock gustav at cactus.dk
Mon Sep 19 00:58:57 CDT 2016


Hi Charlotte

I think that library is for other programs. The VBE object is native to Access ... just type VBE.  and you'll see.

But no properties or settings options to see.

/gustav

-----Oprindelig meddelelse-----
Fra: AccessD [mailto:accessd-bounces at databaseadvisors.com] På vegne af Charlotte Foust
Sendt: 18. september 2016 23:08
Til: Access Developers discussion and problem solving <accessd at databaseadvisors.com>
Emne: Re: [AccessD] Read the "Options, Tab Width" setting of the the VBE Options from VBA?

Did you set a reference to the extensibility library?  That's the only way I know of to deal directly with the VBIDE.  I'm not sure what all is in there anymore, but it allows you to customize the VBE environment.

Charlotte Foust
(916) 206-4336

On Sun, Sep 18, 2016 at 1:01 PM, Gustav Brock <gustav at cactus.dk> wrote:

> Hi Charlotte
>
> It's the setting Tools, Options, Editor, Tab Width I wish to read. 
> Default value is 4.
>
> /gustav
>
> ________________________________________
> Fra: AccessD <accessd-bounces at databaseadvisors.com> på vegne af 
> Charlotte Foust <charlotte.foust at gmail.com>
> Sendt: 18. september 2016 20:32:36
> Til: Access Developers discussion and problem solving
> Emne: Re: [AccessD] Read the "Options, Tab Width" setting of the the 
> VBE Options from VBA?
>
> I haven't worked with the VBE object itself in some years and 
> pre-ribbon, so I have no idea.  What are you trying to achieve?  And which tabs?
>
> Charlotte Foust
> (916) 206-4336
>
> On Sun, Sep 18, 2016 at 1:47 AM, Gustav Brock <gustav at cactus.dk> wrote:
>
> > Hi all
> >
> > Is that possible?
> > I cannot find neither a Setting nor Options property of the VBE object.
> >
> > /gustav
> --
> 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



More information about the AccessD mailing list