isolated procedures

[connollyg]

I have a Access db that i am attempting to write some VBA code for.

I have a command button on a form that calls a VBA procedure, and that seems to work fine, but if i put another procedure in a seperate module and try to call it from the first procedure it cant see it, what am i doing wrong. i have looked at other examples and i cant see any differences between my code and them!

 

[raskew]

Would you mind providing an example of your code?

 

[JohnYingling]

Did you declare the Procedure as Public.

http://www.VBCompare.com

Compare Code (Text)

http://www.VBSortGen.com

Generate Sort in VB or VBScript

 

[connollyg]

This Works:-

- Results (Results)
- Microsoft Access Class Objects
- Form_Event5


Private Sub Close_Click()

Call AddEvent2DB

End Sub

Public Sub AddEvent2DB()
...
End Sub


This Doesnt:-

- Results (Results)
- Microsoft Access Class Objects
- Form_Event5

Private Sub Close_Click()

Call AddEvent2DB

End Sub


-Modules
- AddEvent2DB

Public Sub AddEvent2DB()
End Sub