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

Senin, 25 Maret 2013

RE: [MS_AccessPros] How to refresh data

I love this. It has helped me so much. I also like to do a requery on my list and combo boxes.

Respectfully,
Liz Ravenwood
Programmer/Analyst
Super First Class Products
B/E Aerospace
O: 1.520.239.4808
www.beaerospace.com

-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of John Viescas
Sent: Monday, March 25, 2013 1:17 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: [MS_AccessPros] How to refresh data

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]

------------------------------------

Yahoo! Groups Links

This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.