code changes from access 2003 to access 2007

[daversb]

I am migrating a 2003 database to a 2007 database. I need some assistance....I have vba poping up when i select a function and pops up refrencing the same syntax.

Private Sub cmd_Post_Click()
Dim D As Database, I As Integer, R As Recordset, Y, RowSeperator
Dim SQLText As String
Dim CCounty As String
SQLText = "SELECT qry_TaxRate.CityName, qry_TaxRate.CountyName"
SQLText = SQLText & " FROM qry_TaxRate"
SQLText = SQLText & " WHERE ((([qry_TaxRate].CityName)='" & Me!ShipCity & "'));"


This is an example. the above in highlighted is the problem child....



Not sure if there was vba language changes that arent recognized by 2007 from 2003

[SteveF]

Do you want to use ADODB or DAO for your connections?

You'd probably be best off if you explicitly declare your connection type, like this:

Dim D as DAO.Database, R as DAO.Recordset

Different versions of Access have in the past used either ADODB or DAO as the "default" -- unless you specify, you'll get the default connection, which may not be what you coded for.

I learned the hard way years ago: Access 97 is DAO-only, Access 2000 introduced and defaults to ADODB. All of a sudden, my A97 apps weren't working! Ever since, I specify which to use & my apps run across versions without a problem in this area.

Give that a try & let us know if it works.

Steve