Jegajothy vythilingam
asked on
Access 2007
My Lenovo Think Centre is a Win 7 Prof 64 bit pc, and I have office 2007. A Microsoft technician had to do a reinstall of the office 2007, and then there were teething problems like the Windows installer always came up wanting to reinstall Outlook 2007, and this was fixed by Microsoft.
But now the small Access 2007 database that I had created before all this, does not work. All the buttons do not execute the code.
Private Sub Copypassword_Click()
' This procedure runs when the Copy button is clicked.
'On Error GoTo Err_cmdCopy_Click
' Set focus on the results.
Me.password_used.SetFocus
' Copy the results to the clipboard.
DoCmd.RunCommand acCmdCopy
'Exit_cmdCopy_Click:
' On Error Resume Next
' Exit Sub
'Err_cmdCopy_Click:
' MsgBox Err.Number & " " & Err.Description, vbCritical, "cmdCopy_Click"
'Resume Exit_cmdCopy_Click
End Sub
In the VB code under references, I see the following being checked :
Microsoft Access 12.0 Object library
OLE Automation
Microsoft DAO 3.6 Object library
Microsoft VB for Applications Extensibility 5.3
thank u for your suggestions.
But now the small Access 2007 database that I had created before all this, does not work. All the buttons do not execute the code.
Private Sub Copypassword_Click()
' This procedure runs when the Copy button is clicked.
'On Error GoTo Err_cmdCopy_Click
' Set focus on the results.
Me.password_used.SetFocus
' Copy the results to the clipboard.
DoCmd.RunCommand acCmdCopy
'Exit_cmdCopy_Click:
' On Error Resume Next
' Exit Sub
'Err_cmdCopy_Click:
' MsgBox Err.Number & " " & Err.Description, vbCritical, "cmdCopy_Click"
'Resume Exit_cmdCopy_Click
End Sub
In the VB code under references, I see the following being checked :
Microsoft Access 12.0 Object library
OLE Automation
Microsoft DAO 3.6 Object library
Microsoft VB for Applications Extensibility 5.3
thank u for your suggestions.
Are you getting an error message, or is just nothing happening when you click the button?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
your suggestion worked. Thank u.