Code not working on network

D

DebbieG

The following code works great for me (a single PC); however, when I install
the front-end on the client's PC and the back-end on a network drive it is
not working -- ie, the Save and Undo buttons are not visible when editing an
existing record and when adding a new record.

I have a textbox on my form called txtEditModeChange (visible = no) and it's
ControlSource is
=[Form].[Dirty] & EditModeChange([Form])


Function EditModeChange(F As Form) As Variant
If F.Dirty Then
F!cmdSave.Visible = True
F!cmdUndo.Visible = True
F!cmdAdd.Visible = False
F!cmdDelete.Visible = False
F!cmdNext.Visible = False
F!cmdPrevious.Visible = False
F!ComboStudent.Enabled = False
Else
F!cmdSave.Visible = False
F!cmdUndo.Visible = False
F!cmdAdd.Visible = True
F!cmdDelete.Visible = True
F!cmdNext.Visible = True
F!cmdPrevious.Visible = True
F!ComboStudent.Enabled = True
End If
End Function

Private Sub Form_Dirty(Cancel As Integer)
Me!txtEditModeChange.Requery
End Sub

Private Sub Form_AfterUpdate()
Me!txtEditModeChange.Requery
End Sub

I'm not real network savvy so I don't understand why it works fine for me
but not for the client. Anybody have any suggestions?

Thanks in advance,
Debbie
 
S

solex

Debbie,

A few questions:
(1) Do you update the links using the Linked Table Manager when you move the
database to the network?
(2) Do the users(clients) have full rights to the directory where the
database is on the network?

Regards,
Dan
 
D

DebbieG

Dan,

1. Yes, the links are updated using the Linked Table Manager. The data is
coming across fine.
2. Yes, the users have full rights to the directory.

When I edit something the txtEditModeChange textbox shows a -1, and a 0 when
it isn't being edited. The user sees #Name?. I don't understand why they
are getting an error.

This is Access XP.

Debbie



Debbie,

A few questions:
(1) Do you update the links using the Linked Table Manager when you move the
database to the network?
(2) Do the users(clients) have full rights to the directory where the
database is on the network?

Regards,
Dan
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top