Duplicate Record: 599cd.com/Duplicate

Thank you....I have seen that video but it uses macros. I want to use VBA.

Okay I figured out what I said in my notes. I told myself to leave a single space there. When I try and use the code I get this message.

That's what I get when I choose debug

Hello Lee

Just Convert Macro to VBA

and this is the VBA of the Macro

Details

Private Sub DuplicateRecordBtn_Click()

On Error GoTo DuplicateRecordBtn_Click_Err

    On Error Resume Next
    DoCmd.RunCommand acCmdSelectRecord
    If (MacroError = 0) Then
        DoCmd.RunCommand acCmdCopy
    End If
    If (MacroError = 0) Then
        DoCmd.RunCommand acCmdRecordsGoToNew
    End If
    If (MacroError = 0) Then
        DoCmd.RunCommand acCmdSelectRecord
    End If
    If (MacroError = 0) Then
        DoCmd.RunCommand acCmdPaste
    End If
    If (MacroError <> 0) Then
        Beep
        MsgBox MacroError.Description, vbOKOnly, ""
    End If

DuplicateRecordBtn_Click_Exit:
    Exit Sub

DuplicateRecordBtn_Click_Err:
    MsgBox Error$
    Resume DuplicateRecordBtn_Click_Exit

End Sub
Copy

You can convert a Macro into VBA with a button on the Ribbon

Alex we where about 30 seconds apart

Lee you need to be in the from design view to see the convert macro to vba in the ribbon right Alex

Thank you all for the help.

Alex Thank you. I am aware of that. Some reason I thought the simple one line VBA would do it. Thought I had done it before. I am just starting to learn VBA a little and didn't want to cheat. Thought I would pick easy stuff to try and write code for. I guess I am wrong and its not that simple one line. Guess I will stick to the wizard.

Darrin Thank you also. That is a lot of code for a newbie like me. Its overwhelming...LOL

Lee

I start making database's in the late 90's, and I still have the Microsoft
Visual Basic 6.0 Professional Editions.

Like a lot of people I pulled Northwind apart and learned a lot.

I finished a Music database not long ago, and its awesome the best database I've made to date, thanks to Richard and the Tech Help videos, I'm learning a lot more.

One of the features is a Import button that imports all of the music from the hard drive, in seconds no manual input.

All I can say is, it maybe overwhelming now but in time you will only get better and better, and being here with Richard and the gang your in great hands.

I agree with you totally....I have come along ways.....need more time that's all...I get wrapped up in things like this button VBA...I tell myself I have done it before with simple one line code but apparently I ain't remembering like I used too...I appreciate everyone's help....I am still trying to figure out or finally convince myself I haven't done that button like that...LOL