VB macro

John Eberhard · April 2015

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 · April 2015

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 · April 2015

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 · April 2015

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 · April 2015

Thanks Jeff. Much appreciated.

Matt

VB macro

Comments

Categories