DoCmd Access 2007

[GrahamJ]

I've just changed from Access 2002 to Access 2007 and it seems that a number
of lines of code that use DoCmd just do nothing.

Despite a morning's searching, I haven't found a solution or explanation so
here is one issue.

There is a button on a data input form to open a new record - it's always
worked fine in Access 2002 but in 2007 the record does not change.

The code is
Private Sub cNewRec_Click()
On Error GoTo Err_cNewRec_Click

DoCmd.GoToRecord , , acNewRec

Exit_cNewRec_Click:
Exit Sub

Err_cNewRec_Click:
MsgBox Err.Description
Resume Exit_cNewRec_Click

End Sub

 

[Gina Whipp]

GrahamJ,

Is your databse in a Trusted Location?

http://www.regina-whipp.com/index_files/TrustedLocation.htm

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[GrahamJ]

Hi Gina

Thanks very much for your prompt reply - that fixed it.

I wonder what other "gotcha's" will surface from the conversion?

Thanks

 

[Douglas J. Steele]

You might check Allen Browne's http://www.allenbrowne.com/Access2007.html
for advice on converting to Access 2007.

 

[Gina Whipp]

You're welcome and I see Douglas has provided you with a VALUABLE link!

Good Luck,
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm