Command button works for some users but not others

  • Thread starter Thread starter Erin
  • Start date Start date
E

Erin

Hi there, i have an entry form with the following code on a command button to
add a new record. This button works for some users but not others, any ideas?
could it be a security setting?

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
 
Can the user's for which this particular bit of code doesn't work execute
other code? If its a security issue with their machine, then no code will
execute. Are they getting ANY error message?

I did add some line questions that are more stylistic...

Erin said:
Hi there, i have an entry form with the following code on a command button to
add a new record. This button works for some users but not others, any ideas?
could it be a security setting?

Private Sub cmdAddnew_Click()
On Error GoTo Err_cmdAddnew_Click


DoCmd.GoToRecord , , acNewRec
Me!ProjectID = DMax("[ProjectID]", "[MainTracking]") + 1
Click to expand...
Are the project ID's simply numbers that increment by one? If so, have you
looked at changing the field type to Autonumber? Doing so will eliminate the
need to do a DMax() and avoid any conflicts from two users adding a record at
the same time. If you do have to use DMax() you can set the control's default
value to the expression as in =DMax([whatever])
Me.Project_Pre2007 = Me.ProjectID
Me.LinkToReport = "E:\Library\Reports\" & [Project#Pre2007] & ".pdf"
Click to expand...
Why is the variable named Project#Pre2007 when the variable above is
Project_Pre2007?
Me.DateEntered = Date
Click to expand...
Do you have a control on the form that displays the value in the DataEntered
field? If so, set the DefaultValue to =Date()
 
Can the user's for which this particular bit of code doesn't work execute
other code? If its a security issue with their machine, then no code will
execute. Are they getting ANY error message?

I did add some line questions that are more stylistic...

Erin said:
Hi there, i have an entry form with the following code on a command button to
add a new record. This button works for some users but not others, any ideas?
could it be a security setting?

Private Sub cmdAddnew_Click()
On Error GoTo Err_cmdAddnew_Click


DoCmd.GoToRecord , , acNewRec
Me!ProjectID = DMax("[ProjectID]", "[MainTracking]") + 1
Click to expand...
Are the project ID's simply numbers that increment by one? If so, have you
looked at changing the field type to Autonumber? Doing so will eliminate the
need to do a DMax() and avoid any conflicts from two users adding a record at
the same time. If you do have to use DMax() you can set the control's default
value to the expression as in =DMax([whatever])
Me.Project_Pre2007 = Me.ProjectID
Me.LinkToReport = "E:\Library\Reports\" & [Project#Pre2007] & ".pdf"
Click to expand...
Why is the variable named Project#Pre2007 when the variable above is
Project_Pre2007?
Me.DateEntered = Date
Click to expand...
Do you have a control on the form that displays the value in the DataEntered
field? If so, set the DefaultValue to =Date()
 
Back
Top