Advanced VBA Programing

[esandoval]

Hi,
I have a sub form with a pivot chart, the record source is pointing to a query. I did some programming to set the Maximum/Minimum scale but it was hard to find out hot to do it. Now I want to specify the values to be used in the pivot chart but the examples are too complicated for my knowledge.

Is there an Acces VBA book about classes, members of classes and how to use it?

Like how to use the class Chchart and its members or properties.

Thanks.

 

[Guus2005]

Most Access books cover the issues you mention. Albeit very limited.
It depends on your Access version which book to choose. Pivot charts aren't used often in Access so you have to look closely. I'd go to the book shop and make a selection there.

HTH

 

[esandoval]

Many thanks for your reply.
I've some Access books like Using Access 2002, Mastering MS Office Access 2003, Access 97 VBA and Access Database Design and Programming. (The company where I work use Office 2002) If you open the object browser from the VBA editor you'll see a lot of Classes with its respective list of properties, for example: the ChChart object has like 46 members or properties but the books that I have only use a few of those members for some exercises and they provide a poor explanation, almost nothing, about the object and its members. I was wondering if there is an Access book that same as the list of functions, also include a list of object and how to use it. I'll take your advice and visit the book shop.

Thanks.

 

[Guus2005]

Remember that there is more available on the internet than you can find in books!