[AccessD] Text field not editable, weird issue

David McAfee davidmcafee at gmail.com
Mon Oct 31 18:18:13 CDT 2011


I've checked everything that I could possibly think of.

I've signed on to her computer with my network credentials (admin) and it
is definitely an issue on her box.

I see no missing references.

She has Access 2003 installed on her box (Win XP SP3)

I develop in Vista / Access 2007, but in 2002-2003 file format. (The ADP
was originally created in A2000)

I tried putting an exit sub before the end sub.
The moment any other control is touched, the after update fires for
txtTranNo.

It's behaving almost like if the code was in the Before Update event and I
was canceling the event.

I tried to set focus on another control on the very last line of the sub
and I get a 2110 error (can't move focus to control txtSN)




On Mon, Oct 31, 2011 at 12:52 PM, Charlotte Foust <charlotte.foust at gmail.com
> wrote:

> Since it's an ADP, I'd suggest you check on any possible permissions
> differences on the two machines, both directory permissions and SQL Server
> permissions.
>
> Charlotte Foust
>
> On Mon, Oct 31, 2011 at 12:14 PM, David McAfee <davidmcafee at gmail.com
> >wrote:
>
> > I'm experiencing something weird on a user's computer.
> >
> > New user (to my database app), new screen (built specifically for her).
> >
> > Her screen works great on my computer whether I'm logged in to the ADP as
> > me or as her.
> >
> > On her computer, it seems to be stuck in a previous text box After Update
> > event.
> >
> > The first text box on the screen is where she enters the PO#.
> >
> > Here is the code in the after update event:
> >
> > Private Sub txtTranNo_AfterUpdate()
> >  DoCmd.SetWarnings False
> >   Me.lstModelSumm.RowSource = "EXEC dbo.stpSelectTempMach 0"
> >  DoCmd.SetWarnings True
> >  Me.lstPoResults.RowSource = "EXEC dbo.stpPurchasedMachinesByPO '" &
> > Me.txtTranNo & "'"
> >  If Nz(lstPoResults.Column(0, 1), "") <> "" Then
> >    Me.lstPoResults.Selected(1) = True
> >    Call PopulateFields
> >  Else
> >    Call ClearEntryFields
> >  End If
> >
> > End Sub
> >
> > I put a break point on the very first line and stepped through every
> line.
> >
> > On my computer I can click on any entry field and enter data or combo box
> > and select a row.
> >
> > I can do same either logged in as her or myself on my box.
> >
> > On her computer (logged in as her or myself), I can step through every
> > line, but If I click on any other control,
> > it behaves as if those controls are locked and if the break point still
> > exists the first line of
> > txtTranNo_AfterUpdate() is highlighted yellow.
> >
> > It is like we are stuck in the after update event.
> >
> > Any ideas?
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> >
> >
> > Website: http://www.databaseadvisors.com
> >
> >
> >
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>



More information about the AccessD mailing list