Coded command button only works for some users

's Computer Specifications

I have created an entry form with a command button with the following code
attached. For some users of the database this button works but for others it
doesnt. For the users it doesnt work for the button does not do anything when
clicked. Any ideas would be greatly appreciated. Could it be security
settings?

Private Sub cmdAddnew_Click()
On Error GoTo Err_cmdAddnew_Click

DoCmd.GoToRecord , , acNewRec
Me!ProjectID = DMax("[ProjectID]", "[MainTracking]") + 1
Me.Project_Pre2007 = Me.ProjectID
Me.LinkToReport = "E:\Library\Reports\" & [Project#Pre2007] & ".pdf"
Me.DateEntered = Date

Exit_cmdAddnew_Click:
Exit Sub

Err_cmdAddnew_Click:
MsgBox Err.Description
Resume Exit_cmdAddnew_Click

End Sub

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Command button works for some users but not others	Erin	Microsoft Access VBA Modules	2	27th May 2009 01:01 AM
Coded command button only works for some users	Erin	Microsoft Access VBA Modules	2	26th May 2009 09:07 PM
Command button works for some users but not others	Erin	Microsoft Access VBA Modules	0	26th May 2009 05:43 PM
how do I set up a command button that works with a combo box	=?Utf-8?B?bGlhcnNwb2tlcg==?=	Microsoft Excel Misc	1	6th Apr 2005 02:21 PM
Command Button for Macro works once		Microsoft Access Macros	2	11th Mar 2005 09:37 PM