Convert 2003 to 2007- with VBA

  • Thread starter Thread starter MartyO
  • Start date Start date
M

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
 
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
 
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.

MartyO said:
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

MartyO said:
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?
Click to expand...
Click to expand...
 
Back
Top