VB macro

John Eberhard

Does anyone know anything about the VB macro drop down on the tools, query options, record processing form?  At this point I am mostly just curious as to how to use it.  Where do I create the macro so that it shows up in the dropdown?  What sort of things have people done with it?

Jeff Gignac

John



This is used with the VBA Add-on module.  This (along with the same field in Export) would allow you to program extra data needed to use in your Query (or Export).  If there is information you need but its not available in Query (or Export) you could then program something to get at the data.



If you do not have the VBA Module, then you cannot use it.  If you have the VBA Module, then you can extend some functionality needed in Query (or Export)



I hope this helps



Jeff



 

Matt Page

I've been meaning to ask about this as well, so thanks Jeff for asking. Would you mind a couple more questions?



Firstly, is the VBA module free or paid for and if it's the latter roughly what is the cost



Secondly , what kinds of things do yo uuse it for and are you aware of any good examples laid out for beginners?



Thanks



Matt

Jeff Gignac

Hi Matthew



The VBA Module is not free, you need to contact your account manager to the exact fee.



It can be used to code something to happen when records are opened, or closed, or saved.  It can be usefull for clean up of data or ensure data accuracy.



You really need to know object programming and Visual Basic 6 programming.  If you do not, I would learn Visual Basic first, before diving into VBA.



Feel free to contact me off list if you have more questions.



Thanks



Jeff



 

Matt Page

Thanks Jeff. Much appreciated.

Matt