Link to home
Start Free TrialLog in
Avatar of Jegajothy vythilingam
Jegajothy vythilingamFlag for United States of America

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.
Avatar of Robert Sherman
Robert Sherman
Flag of United States of America image

Are you getting an error message, or is just nothing happening when you click the button?
ASKER CERTIFIED SOLUTION
Avatar of Scott McDaniel (EE MVE )
Scott McDaniel (EE MVE )
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Jegajothy vythilingam

ASKER

your suggestion worked.  Thank u.