Form can´t be filled on another Client

  • Thread starter Thread starter gert birkner
  • Start date Start date
G

gert birkner

hi,

my form has to be filled with data from a stored procedure "getFirmaList"
with no parameters (SQL Server 2000). It always returns at least 1 record an
max. <50.
When I open the form on my developer station (office developer), everything
is fine, the Combo is filled with those records, the form´s parameters are
set correct and the form shows the correct data from the sp "getKundenDaten"

When I open this form on another client with access 2003 installed (like my
client), then access raeises the error (translated) "unallowed usage of
NULL".
Me.FirmenNr.ItemData(0) is indeed NULL. On my Client it has the correct
value.

When I execute the stored proc "getFirmaList" on the client machine I get
all the records correct.

Why fills access the form on my machine perfect and on any other machine not
at all.


Private Sub Form_Open(Cancel As Integer)


Me.FirmenNr.RowSource = "getFirmaList"
Me.FirmenNr = Me.FirmenNr.ItemData(0)


Me.InputParameters = "@firmennr int=" & CStr(FirmenNr)
Me.RecordSource = "getKundenDaten"

End Sub
 
Hello,

You may running into a missing reference issue. Open Access database from a
client machine and
verify that there is no missing reference. See following article for more
information:

ACC2000: VBA Functions Break in Database with Missing References WGID:147
ID: 208218.KB.EN-US
http://support.microsoft.com/default.aspx?scid=kb;en-us;208218

Regards,

Ki Yi
Microsoft Support

This posting is provided AS IS with no warranties, and confers no rights.
 
Back
Top