[AccessD] Text field not editable, weird issue

Charlotte Foust charlotte.foust at gmail.com
Mon Oct 31 18:54:28 CDT 2011


Is this the only user or just the only one having problems?  Is there a
copy of the ADP on her box or is she accessing it from a network site?  If
the app is on her machine, have you done a decompile and recompile on the
app?  Once in a while breakpoints will get stuck and only recompiling will
get rid of them.  If you comment out all the code in that routine but leave
the shell, does the application run without an error?  Is the next control
in the tab order one of the two you're resetting the rowsource on?

Charlotte Foust
On Mon, Oct 31, 2011 at 4:18 PM, David McAfee <davidmcafee at gmail.com> wrote:

> 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
>
>
> >
> --
> 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