Method or data member not found

[Randy Yates]

Hi Folks,

I have some old code that I tried to fire up this morning. I'm using
MS Access 2000 with the DAO 3.6 Object Library reference at its
highest priority.

When I try to compile I get the "Method or data member not found"
with the first "rstP" in the "MakeProject..." line below highlighted.
Changing the paramter to "rstP As DAO.Recordset" made no difference.

Function MakeProject(rstP As Recordset) As String
MakeProject = rstP("fProjectNumber") & " " & rstP.fProjectName
End Function

rstP!fProjectNumber, rstP.fProjectNumber, and rstP.Fields.fProject
all have the same or similar error.

Please help! I have no idea what's going on, and I hate these
Microsoft compatibility/reference problems.
--
% Randy Yates % "Watching all the days go by...
%% Fuquay-Varina, NC % Who are you and who am I?"
%%% 919-577-9882 % 'Mission (A World Record)',
%%%% <ya***@ieee.org % *A New World Record*, ELO
http://home.earthlink.net/~yatescr

[Randy Yates]

Randy Yates <ya***@ieee.orgwrites:

Hi Folks,

I have some old code that I tried to fire up this morning. I'm using
MS Access 2000 with the DAO 3.6 Object Library reference at its
highest priority.

When I try to compile I get the "Method or data member not found"
with the first "rstP" in the "MakeProject..." line below highlighted.
Changing the paramter to "rstP As DAO.Recordset" made no difference.

Function MakeProject(rstP As Recordset) As String
MakeProject = rstP("fProjectNumber") & " " & rstP.fProjectName
End Function

rstP!fProjectNumber, rstP.fProjectNumber, and rstP.Fields.fProject
all have the same or similar error.

Please help! I have no idea what's going on, and I hate these
Microsoft compatibility/reference problems.

Never mind - fixed it. I'm not even sure what the problem was, but
I did have to convert all "." references to recordset fields to
bangs.
--
% Randy Yates % "Rollin' and riding and slippin' and
%% Fuquay-Varina, NC % sliding, it's magic."
%%% 919-577-9882 %
%%%% <ya***@ieee.org % 'Living' Thing', *A New World Record*, ELO
http://home.earthlink.net/~yatescr