ACCESS FEED: Re: [MS_AccessPros] How to refresh data

Rabu, 03 April 2013

Re: [MS_AccessPros] How to refresh data

Hi John

I finally solved the requery challenge - it makes perfect sense now! As I was on a subform when I needed to update the other subforms linked to the main form, I had to tell Access to go back up to the parent form before coming back down to the next subform.

The code:
Me.Parent.fsubEventPlace_delegate_info.Form.Requery
worked fine.

Thanks for the help.
Ray

--- In MS_Access_Professionals@yahoogroups.com, John Viescas <JohnV@...> wrote:
>
> Ray-
>
>
>
> Just Requery the subforms to stay on the same record.
>
>
>
> John Viescas, Author
>
> Microsoft Access 2010 Inside Out
>
> Microsoft Access 2007 Inside Out
>
> Microsoft Access 2003 Inside Out
>
> Building Microsoft Access Applications
>
> SQL Queries for Mere Mortals
>
> http://www.viescas.com/
>
> (Paris, France)
>
>
>
>
>
>
>
> From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Ray
> Sent: Monday, March 25, 2013 9:03 PM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: Re: [MS_AccessPros] How to refresh data
>
>
>
>
>
> Hi John
>
> Thanks for the nudge in the right direction.
>
> When I did a Requery on the Master form it correctly "refreshed" the data on
> all the child forms. The master form then displayed the first record in the
> set again, rather than the record I was looking at but I'll experiment to
> solve that one.
>
> Thanks again
> Ray
>
> --- In MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com> , John Viescas
> <JohnV@> wrote:
> >
> > Ray-
> >
> >
> >
> > DoCmd.Requery does a Requery of the entire form - and that should do the
> > trick. The alternative is to use the Requery method and target each
> > specific subform:
> >
> >
> >
> > Me.fsubStudents.Requery
> >
> > Me.fsubStudentExams.Requery
> >
> >
> >
> > .. or something like that.
> >
> >
> >
> >
> >
> > John Viescas, Author
> >
> > Microsoft Access 2010 Inside Out
> >
> > Microsoft Access 2007 Inside Out
> >
> > Microsoft Access 2003 Inside Out
> >
> > Building Microsoft Access Applications
> >
> > SQL Queries for Mere Mortals
> >
> > http://www.viescas.com/
> >
> > (Paris, France)
> >
> >
> >
> >
> >
> >
> >
> > From: MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> > [mailto:MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com> ] On Behalf Of Ray
> > Sent: Sunday, March 24, 2013 5:49 PM
> > To: MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> > Subject: [MS_AccessPros] How to refresh data
> >
> >
> >
> >
> >
> > I have database that holds training courses, students and allocations on a
> > course. The main form shows the course details. The lower half of the main
> > form has a few pages, each with an embedded subform showing the students
> who
> > are on the course. The first page shows the students on the course (i.e.
> > name, company, email etc on a continuous form). The next page shows the
> > student name, exam results etc (again continuous form).
> >
> > I have placed a command button on the first page, embedded in the
> continuous
> > form, to allow the student to be moved to another course. This opens
> another
> > form in dialog mode which allows the new course to be selected, runs some
> > SQL to update the allocations table and return to the original form. The
> vba
> > code is
> > stDocName = "frmMoveDelegate"
> > DoCmd.OpenForm stDocName, , , stLinkCriteria, , acDialog
> > DoCmd.Requery
> >
> > The requery does remove the student from the first page - showing the user
> > that they have been successful. However, if you click on the second page
> the
> > "moved" student is still there, like an after image. How can I refresh the
> > data on all the pages associated with the course? It's probably a simple
> > solution but I'm a bit stumpted at present and would appreciate some help.
> >
> > Many thanks
> > Ray
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>