2003 to 2007 porting, functions not found.

  • Thread starter Thread starter H. Martins
  • Start date Start date
H

H. Martins

Hope I can explain what I think my problem is.

Testing an application under Access 2007, it asks me for the value of
a couple functions.

These functions are called from a Query attached to a Form's TextBox
and from a Query attached to a DropDownBox.

Looks like it doesn't find the functions. 2003 does find but nor 2007.

The functions are located in the Form's own code.

Thanks
Henry

==========================

Criteria: Like ([fnGetDI])

Which is:

Function fnGetDI() As String

If IsNull(txtbxBIBusca.Value) Then
fnGetDI = "*"
Else
fnGetDI = Trim(txtbxBIBusca.Value) & "*"
End If
End Function

==============================

Criteria: [forms].[TurmasConstituicaoDe].[fnGetNAlunoAccao]

Static Function fnGetNAlunoAccao() As Long
' função que devolve o índice de registo à query
If IsNull(constlintNSerieAlunoAccaoKMaster) Then
fnGetNAlunoAccao = 0
Else
fnGetNAlunoAccao = lstbxAlunos.Column
(constlintNSerieAlunoAccaoKMaster)
End If
End Function
 
The first place to check would be references. Look at the references in 2003
(Open a module in design then Tools/References) and check in 2007. See if
any references are missing.

Neville Turbit
www.projectperfect.com.au
 
Back
Top