Convert 2003 to 2007- with VBA

[MartyO]

Hi there,
I've converted a .mdb 2003 database to vs. 2007. I'm getting a compile
error in the 2007 version, everything runs fine in the old version.
For example, in
With rec
.FindFirst "[Login] = '" & Me.Login & "'"

the Compile error "Method or data member not found" is generated when
execution hits the "Me.Login" part of the code.

Is there something else I need to do in order to convert to 2007?
Secondly, I intend to Publish this to Sharepoint, is there anything else I
should look out for, or known not to work in Sharepoint?

Thanks in advance!
Marty

 

[MartyO]

Nevermind.... looks like I needed to change my "Dim db as Database"
declarations to "Dim db as DAO.Database", as well as the recordset ones too.
Now it works fine.
Thanks!
Marty

 

[Allen Browne]

Ah, the References issue again.

FWIW, MartyO, this might help avoid some of the more common issues:
Converting to Access 2007
at:
http://allenbrowne.com/Access2007.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

Nevermind.... looks like I needed to change my "Dim db as Database"
declarations to "Dim db as DAO.Database", as well as the recordset ones
too.
Now it works fine.
Thanks!
Marty

Hi there,
I've converted a .mdb 2003 database to vs. 2007. I'm getting a compile
error in the 2007 version, everything runs fine in the old version.
For example, in
With rec
.FindFirst "[Login] = '" & Me.Login & "'"

the Compile error "Method or data member not found" is generated when
execution hits the "Me.Login" part of the code.

Is there something else I need to do in order to convert to 2007?
Secondly, I intend to Publish this to Sharepoint, is there anything else
I should look out for, or known not to work in Sharepoint?