From Access 2003 to 2007 and command is not working

[ddtpmyra]

It use to work on my MS Access 2003 but when I start using MS 2007 it does not work anymore. Is there other settings I have to do to make it work?

Private Sub MR_DblClick(Cancel As Integer)
DoCmd.OpenForm "frm_MRHolder", OpenArgs:=Me.MR
End Sub
 

[NeoPa]

I'm sorry to say that code would never work in Access 2003. I have no idea why you've made that mistake but procedure parameters can either be positional or named, but never both.

[ddtpmyra]

NeoPa... should you say it will never work on Access 2003 or Access 2007 I'm confused.

My codes works at 2003 but when I open my DB in 2007 it does work. Please clarify.

thanks!

[NeoPa]

It seems that I was in error. I've just tested it exactly as you have it (in 2003) and it does indeed work. My memory must be faulty, as I'm sure I had an error recently where I tried to call a procedure with one argument as a positional one and another as a named argument. Possibly it was as simple as trying it the other way around (Indeed i tried it that way around and it complained immediately). Once the compiler detects a named argument it doesn't allow any further non-named ones.

Nevertheless, I would try making all the arguments of the same type in future. It is more consistent and I would say better practice. It may even allow your code to work in Access 2007 too, without further changes. BTW. For more on that see Converting to Access 2007. It's a very useful page to read in your position.

Sorry for the incorrect advice earlier. It seems Access can still catch me out sometimes :-(

[ddtpmyra]

Thanks NoePa for clarifying. I used OpenArg from my previous question (another thread) about opening a form (see the link below) and I got that idea from you (wink)

http://bytes.com/topic/access/answer...-passing-value
I'm trying to create a event from From 1 to pass a value to Form 2.

what is the other way to do it?

thanks again!

[NeoPa]

It's probably as simple as :

Private Sub MR_DblClick(Cancel As Integer)
    Call DoCmd.OpenForm(FormName:="frm_MRHolder", OpenArgs:=Me.MR)
End Sub

Your concept is right. It's simply a better idea to use one type of argument consistently (and may well be required in versions after 2003).

[ddtpmyra]

Private Sub MR_DblClick(Cancel As Integer) 
    Call DoCmd.OpenForm(FormName:="frm_MRHolder", OpenArgs:=Me.MR) 
End Sub 

I wonder still doesn't work. I even tried as scimple as below on click event of a button.

DoCmd.OpenForm "frm_MRHolder" 

What went wrong :(

[NeoPa]

I don't know without some clues as to what went wrong where. What error message do you see? What line does the debugger stop on? Without this information it's a bit like a question - "My database doesn't work. Why?"

Another important question - Have you checked out the link I included in post #4?