Question Access VBA Query Writer

[Mohsin Malik]

Hi again,

Is there any free Addin/tool that would be helpful for Access VBA to Write Queries and passing parameters, additionally does there any Addin exist where I could manage my code libraries and use the same for different applications.

Thanks
Mohsin

 

[pr2-eugin]

Is this something that might be relevant to what you want? http://allenbrowne.com/ser-71.html

 

[Mohsin Malik]

Thanks Eugin. Do you any VBA Add-in where I could manage my code libraries. I would like to have some useful VBA things. For example in some cases if I will have to copy some controls that has VBA, I would have to copy the control and then copy the codes for each control.

 

[Simon_MT]

In VBA you can use Form independent scripts using CodeContextObject

Function Artists_Books()

    With CodeContextObject
        If .[Artist Book] = True Then
            DoCmd.OpenForm "Artists Books", acNormal, "", "[Book Detail Artist]= '" & .[Artist] & "'", acFormEdit, acWindowNormal
        End If
    End With
End Function

Simon