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

Rabu, 03 April 2013

RE: [MS_AccessPros] How to refresh data

Yup, that's the ticket!

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: Wednesday, April 03, 2013 6:10 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: 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
<mailto:MS_Access_Professionals%40yahoogroups.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%40yahoogroups.com>
> [mailto:MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com> ] On Behalf Of Ray
> Sent: Monday, March 25, 2013 9:03 PM
> To: MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.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>
> <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%40yahoogroups.com>
> > [mailto:MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.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>
> <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]
>

[Non-text portions of this message have been removed]