[AccessD] Menu form changes app behavior?

Janet Erbach jerbach.db at gmail.com
Tue Mar 31 15:11:28 CDT 2015


Alright, thank you.  The 'Me.Dirty = false' seems to be making a difference.

On Tue, Mar 31, 2015 at 2:36 PM, Stuart McLachlan <stuart at lexacorp.com.pg>
wrote:

> No, it doesn't force a save of the dirty record, it discards the change.
>
> On 31 Mar 2015 at 8:22, Janet Erbach wrote:
>
> > I'll try that.  Doesn't 'Me.requery' do the same thing, though?
> >
> > On Mon, Mar 30, 2015 at 3:27 PM, Stuart McLachlan
> > <stuart at lexacorp.com.pg> wrote:
> >
> > > The last record is still dirty and the "accept" state has not been
> > > updated.
> > >
> > > Try a "Me.Dirty = False" at the start of the procedure to force the
> > > save.
> > >
> > >
> > >
> > > On 30 Mar 2015 at 14:59, Janet Erbach wrote:
> > >
> > > > I am trouble shooting an app that uses a switchboard menu.  While
> > > > I'm trouble shooting, I open the app in design view to write my
> > > > code, test my forms and queries, etc.  Everything is working fine
> > > > that way.
> > > >
> > > > As soon as I run the menu form and begin testing the app the way
> > > > the end user sees it, the results I get change.
> > > >
> > > > Specifically:  the user types in a part # and a machine #;  the
> > > > query inserts, say, 6 records into a temp table.  A form comes up
> > > > that displays the records in that temp table;  the user can select
> > > > the records to process with an 'accept' checkbox.  When the user
> > > > clicks 'submit', all records with 'accept=true' should be selected
> > > > and processed.
> > > >
> > > > This works fine when I open the app in design mode:  I select 6
> > > > records, and 6 records are processed.  When running this function
> > > > through the main menu, though, only 5 out of 6 are being selected!
> > > > It's as if the last 'accept' checkmark is not being posted to the
> > > > table.  I issue a 'Me.requery' to the form as soon as the 'submit'
> > > > button is checked to post all the records, but it's not working.
> > > >
> > > > I have no idea why this is happening.  Any ideas where I can look?
> > > >
> > > > Janet Erbach
> > > > --
> > > > 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
> >
>
>
> --
> 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