Klos, Susan
Susan.Klos at fldoe.org
Wed Feb 3 12:03:47 CST 2010
Outlook 2003
If you need further assistance feel free to contact me.
Susan Klos
Senior Database Analyst
Florida Department of Education
Evaluation and Reporting Office
Phone: 850.245.0708
Fax: 850.245.0710
email: susan.klos at fldoe.org
-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of accessd-request at databaseadvisors.com
Sent: Wednesday, February 03, 2010 1:00 PM
To: accessd at databaseadvisors.com
Subject: AccessD Digest, Vol 84, Issue 3
Send AccessD mailing list submissions to
accessd at databaseadvisors.com
To subscribe or unsubscribe via the World Wide Web, visit
http://databaseadvisors.com/mailman/listinfo/accessd
or, via email, send a message with subject or body 'help' to
accessd-request at databaseadvisors.com
You can reach the person managing the list at
accessd-owner at databaseadvisors.com
When replying, please edit your Subject line so it is more specific
than "Re: Contents of AccessD digest..."
Today's Topics:
1. Re: Survey - Preferred Email and NewsGroups client (Steve Schapel)
2. Re: Survey - Preferred Email and NewsGroups client (Helmut Kotsch)
3. Re: Survey - Preferred Email and NewsGroups client
(Stuart McLachlan)
4. Re: Survey - Preferred Email and NewsGroups client
(Darren - Active Billing)
5. Re: Survey - Preferred Email and NewsGroups client (Drew Wutka)
6. Re: Survey - Preferred Email and NewsGroups client (Robert)
7. Re: Survey - Preferred Email and NewsGroups client
(Kenneth Ismert)
8. Re: Survey - Preferred Email and NewsGroups client (Edward Zuris)
9. Re: Survey - Preferred Email and NewsGroups client (Jeff B)
10. Re: Survey - Preferred Email and NewsGroups client (Bobby Heid)
11. Re: Survey - Preferred Email and NewsGroups client
(Charlotte Foust)
12. Re: Survey - Preferred Email and NewsGroups client (Jack and Pat)
13. Re: Survey - Preferred Email and NewsGroups client (Joe O'Connell)
14. Two levels up (or down) , twice removed (jwcolby)
15. Re: Survey - Preferred Email and NewsGroups client (A.D. Tejpal)
16. Re: Survey - Preferred Email and NewsGroups client (A.D. Tejpal)
17. Re: Two levels up (or down) , twice removed (Max Wanadoo)
18. Re: Two levels up (or down) , twice removed (Stuart McLachlan)
19. Re: Two levels up (or down) , twice removed (Max Wanadoo)
20. Re: Survey - Preferred Email and NewsGroups client
(Johncliviger at aol.com)
21. Re: Ask Again? - Updateable Query - Access vs. SQL Server
(Dan Waters)
22. Re: Ask Again? - Updateable Query - Access vs. SQL Server
(Dan Waters)
23. Re: Survey - Preferred Email and NewsGroups client (A.D. Tejpal)
24. Re: Survey - Preferred Email and NewsGroups client (Doug Steele)
25. Re: Survey - Preferred Email and NewsGroups client (Debbie)
26. Re: Survey - Preferred Email and NewsGroups client (Gustav Brock)
27. Re: Survey - Preferred Email and NewsGroups client
(Johncliviger at aol.com)
28. Re: Survey - Preferred Email and NewsGroups client (Gary Kjos)
----------------------------------------------------------------------
Message: 1
Date: Wed, 03 Feb 2010 07:00:07 +1300
From: Steve Schapel <miscellany at mvps.org>
Subject: Re: [AccessD] Survey - Preferred Email and NewsGroups client
To: Access Developers discussion and problem solving
<accessd at databaseadvisors.com>
Message-ID: <DFE00B32DB3043EFBE9E7380A3682686 at stevePC>
Content-Type: text/plain; format=flowed; charset=iso-8859-1;
reply-type=original
Windows Live Mail for everything.
Regards
Steve
--------------------------------------------------
From: "A.D. Tejpal" <adtp at airtelmail.in>
Sent: Wednesday, February 03, 2010 3:23 AM
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Subject: [AccessD] Survey - Preferred Email and NewsGroups client
> Members of this forum are requested to kindly indicate the application
> used by them for Emails and NewsGroups.
>
------------------------------
Message: 2
Date: Tue, 2 Feb 2010 19:51:40 +0100
From: "Helmut Kotsch" <hkotsch at arcor.de>
Subject: Re: [AccessD] Survey - Preferred Email and NewsGroups client
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Message-ID: <JIECLJNJOMBJFEDLONCBCEJEGJAA.hkotsch at arcor.de>
Content-Type: text/plain; charset="us-ascii"
Emails: Outlook 2000 SP3
NewsGroups: Outlook Express 6
Helmut
-----Ursprungliche Nachricht-----
Von: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]Im Auftrag von A.D. Tejpal
Gesendet: Dienstag, 2. Februar 2010 15:23
An: Access Developers discussion and problem solving
Betreff: [AccessD] Survey - Preferred Email and NewsGroups client
Members of this forum are requested to kindly indicate the application
used by them for Emails and NewsGroups.
Best wishes,
A.D. Tejpal
------------
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
------------------------------
Message: 3
Date: Wed, 03 Feb 2010 06:55:54 +1000
From: "Stuart McLachlan" <stuart at lexacorp.com.pg>
Subject: Re: [AccessD] Survey - Preferred Email and NewsGroups client
To: Access Developers discussion and problem solving
<accessd at databaseadvisors.com>
Message-ID: <4B68915A.1295.9252CAA at stuart.lexacorp.com.pg>
Content-Type: text/plain; charset=US-ASCII
Pegasus Mail
(don't do NewsGroups)
--
Stuart
On 2 Feb 2010 at 19:53, A.D. Tejpal wrote:
> Members of this forum are requested to kindly indicate the application used by them for Emails and NewsGroups.
>
> Best wishes,
> A.D. Tejpal
> ------------
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
------------------------------
Message: 4
Date: Wed, 3 Feb 2010 08:38:58 +1100
From: "Darren - Active Billing" <darren at activebilling.com.au>
Subject: Re: [AccessD] Survey - Preferred Email and NewsGroups client
To: "'Access Developers discussion and problem solving'"
<accessd at databaseadvisors.com>
Message-ID: <0FDACED3BF0945E2B691EA29CAC7B8F5 at darrendPC>
Content-Type: text/plain; charset="us-ascii"
Outlook 2003
No Newsgroups
Darren
On 2 Feb 2010 at 19:53, A.D. Tejpal wrote:
> Members of this forum are requested to kindly indicate the application
used by them for Emails and NewsGroups.
>
> Best wishes,
> A.D. Tejpal
> ------------
> --
> 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
------------------------------
Message: 5
Date: Tue, 2 Feb 2010 16:09:19 -0600
From: "Drew Wutka" <DWUTKA at Marlow.com>
Subject: Re: [AccessD] Survey - Preferred Email and NewsGroups client
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Message-ID:
<A5615CBECEC42E4791D7A7C724E1E9B20307D621 at MIEXCH.Marlow.ii-vi.net>
Content-Type: text/plain; charset="us-ascii"
Outlook 2007.
Haven't been on a newsgroup in ages, but when I did, I used Google
groups.
Drew
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of A.D. Tejpal
Sent: Tuesday, February 02, 2010 8:23 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] Survey - Preferred Email and NewsGroups client
Members of this forum are requested to kindly indicate the
application used by them for Emails and NewsGroups.
Best wishes,
A.D. Tejpal
------------
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
The information contained in this transmission is intended only for the person or entity
to which it is addressed and may contain II-VI Proprietary and/or II-VI Business
Sensitive material. If you are not the intended recipient, please contact the sender
immediately and destroy the material in its entirety, whether electronic or hard copy.
You are notified that any review, retransmission, copying, disclosure, dissemination,
or other use of, or taking of any action in reliance upon this information by persons
or entities other than the intended recipient is prohibited.
------------------------------
Message: 6
Date: Tue, 2 Feb 2010 17:11:04 -0500
From: "Robert" <robert at servicexp.com>
Subject: Re: [AccessD] Survey - Preferred Email and NewsGroups client
To: "'Access Developers discussion and problem solving'"
<accessd at databaseadvisors.com>
Message-ID: <001901caa454$9df9ea90$d9edbfb0$@com>
Content-Type: text/plain; charset="us-ascii"
Outlook 2007
No Newsgroups (probably would if outlook 2007 handled them..)
WBR
Robert
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of A.D. Tejpal
Sent: Tuesday, February 02, 2010 9:23 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] Survey - Preferred Email and NewsGroups client
Members of this forum are requested to kindly indicate the application
used by them for Emails and NewsGroups.
Best wishes,
A.D. Tejpal
------------
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
------------------------------
Message: 7
Date: Tue, 2 Feb 2010 16:15:51 -0600
From: Kenneth Ismert <kismert at gmail.com>
Subject: Re: [AccessD] Survey - Preferred Email and NewsGroups client
To: accessd at databaseadvisors.com
Message-ID:
<7c7841601002021415y6e91a762j27f2f19eb54d58fd at mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1
GMail, and yes for NewsGroups, GMail (sadly unconfigured for this use)
-Ken
------------------------------
Message: 8
Date: Tue, 2 Feb 2010 15:45:33 -0700
From: "Edward Zuris" <edzedz at comcast.net>
Subject: Re: [AccessD] Survey - Preferred Email and NewsGroups client
To: "'Access Developers discussion and problem solving'"
<accessd at databaseadvisors.com>
Message-ID: <001f01caa459$6ee66d00$5bdea8c0 at edz1>
Content-Type: text/plain; charset="us-ascii"
I using Outlook 2002.
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of A.D. Tejpal
Sent: Tuesday, February 02, 2010 7:23 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] Survey - Preferred Email and NewsGroups client
Members of this forum are requested to
kindly indicate the application used by
them for Emails and NewsGroups.
Best wishes,
A.D. Tejpal
------------
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
------------------------------
Message: 9
Date: Tue, 2 Feb 2010 16:54:25 -0600
From: "Jeff B" <jeff.developer at gmail.com>
Subject: Re: [AccessD] Survey - Preferred Email and NewsGroups client
To: "'Access Developers discussion and problem solving'"
<accessd at databaseadvisors.com>
Message-ID: <4b68ac5c.5644f10a.3220.fffff2df at mx.google.com>
Content-Type: text/plain; charset="iso-8859-1"
Outlook 2007
No Newsgroups
Jeff Barrows
MCP, MCAD, MCSD
?
Outbak Technologies, LLC
Racine, WI
jeff.developer at gmail.com
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of A.D. Tejpal
Sent: Tuesday, February 02, 2010 9:23 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] Survey - Preferred Email and NewsGroups client
Members of this forum are requested to kindly indicate the application
used by them for Emails and NewsGroups.
Best wishes,
A.D. Tejpal
------------
--
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
No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 9.0.733 / Virus Database: 271.1.1/2663 - Release Date: 02/02/10
01:35:00
------------------------------
Message: 10
Date: Tue, 2 Feb 2010 17:53:08 -0500
From: "Bobby Heid" <bheid at sc.rr.com>
Subject: Re: [AccessD] Survey - Preferred Email and NewsGroups client
To: "'Access Developers discussion and problem solving'"
<accessd at databaseadvisors.com>
Message-ID: <001f01caa45a$7d40c890$77c259b0$@rr.com>
Content-Type: text/plain; charset="us-ascii"
Outlook 2007 - home and work.
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of A.D. Tejpal
Sent: Tuesday, February 02, 2010 9:23 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] Survey - Preferred Email and NewsGroups client
Members of this forum are requested to kindly indicate the application
used by them for Emails and NewsGroups.
Best wishes,
A.D. Tejpal
------------
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
------------------------------
Message: 11
Date: Tue, 2 Feb 2010 17:45:25 -0600
From: Charlotte Foust <cfoust at infostatsystems.com>
Subject: Re: [AccessD] Survey - Preferred Email and NewsGroups client
To: Access Developers discussion and problem solving
<accessd at databaseadvisors.com>
Message-ID:
<AA01CCF72D3E4246A8AF6ECCE4E013A91E3473F27F at 34093-MBX-C14.mex07a.mlsrvr.com>
Content-Type: text/plain; charset="us-ascii"
Home and office: gmail
Office only: Outlook 2007 through exchange server
No newsgroups only forums and lists
Charlotte Foust
-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of A.D. Tejpal
Sent: Tuesday, February 02, 2010 6:23 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] Survey - Preferred Email and NewsGroups client
Members of this forum are requested to kindly indicate the application used by them for Emails and NewsGroups.
Best wishes,
A.D. Tejpal
------------
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
------------------------------
Message: 12
Date: Tue, 2 Feb 2010 19:13:53 -0500
From: "Jack and Pat" <drawbridgej at sympatico.ca>
Subject: Re: [AccessD] Survey - Preferred Email and NewsGroups client
To: "'Access Developers discussion and problem solving'"
<accessd at databaseadvisors.com>
Message-ID: <BLU0-SMTP580FF51888448ACADB3698C4560 at phx.gbl>
Content-Type: text/plain; charset="US-ASCII"
Outlook 2003 and Gmail
jack
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of A.D. Tejpal
Sent: Tuesday, February 02, 2010 9:23 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] Survey - Preferred Email and NewsGroups client
Members of this forum are requested to kindly indicate the application
used by them for Emails and NewsGroups.
Best wishes,
A.D. Tejpal
------------
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 9.0.733 / Virus Database: 271.1.1/2661 - Release Date: 02/02/10
02:35:00
------------------------------
Message: 13
Date: Tue, 2 Feb 2010 23:11:54 -0500
From: "Joe O'Connell" <joeo at appoli.com>
Subject: Re: [AccessD] Survey - Preferred Email and NewsGroups client
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Message-ID:
<1CF20DB644BE124083B31638E5D5C0234A2543 at exch2.Onappsad.net>
Content-Type: text/plain; charset="us-ascii"
Outlook 2003
No Newsgroups
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of A.D. Tejpal
Sent: Tuesday, February 02, 2010 9:23 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] Survey - Preferred Email and NewsGroups client
Members of this forum are requested to kindly indicate the
application used by them for Emails and NewsGroups.
Best wishes,
A.D. Tejpal
------------
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
------------------------------
Message: 14
Date: Tue, 02 Feb 2010 23:54:48 -0500
From: jwcolby <jwcolby at colbyconsulting.com>
Subject: [AccessD] Two levels up (or down) , twice removed
To: Access Developers discussion and problem solving
<accessd at databaseadvisors.com>
Message-ID: <4B690198.9010705 at colbyconsulting.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
As you probably know by now, subforms load before parent forms, and their current events fire before
the parent's current event. It always puzzled me how they pull off this trick, but they do.
Usually this is not a problem but it can be. For example, the main form has a "client" combo /
field. The child form does not use or care about that. The grandchild form however needs that
value to filter a combo to only display records from a table for that specific client.
In this case, it doesn't appear to work correctly. The combo in the grandchild form is always a
step behind the parent form, IOW if the parent displays client A, the combo in the grandchild
displays whatever the parent had the PREVIOUS record.
So the current event of the main form fires last after all of the child / grandchild forms load (and
their load / current events fire). Logically, that current event of the main form needs to reach
two levels down and tell that combo to requery itself.
What a PITA.
I actually built in to my framework collections of dependent child objects so that I could tell a
form or a control on a form that "these objects are dependent on your data" and call those objects
and requery them. Of course I have to write code in the load event of the form to set up the
dependent object hierarchy.
So how do YOU handle this kind of situation?
Curious minds want to know.
--
John W. Colby
www.ColbyConsulting.com
------------------------------
Message: 15
Date: Wed, 3 Feb 2010 11:13:58 +0530
From: "A.D. Tejpal" <adtp at airtelmail.in>
Subject: Re: [AccessD] Survey - Preferred Email and NewsGroups client
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Message-ID: <016001caa494$f15a9140$3701a8c0 at adtpc>
Content-Type: text/plain; charset="iso-8859-1"
Ken,
Would it imply that you are accessing web based services without using any desktop client ?
Best wishes,
A.D. Tejpal
------------
----- Original Message -----
From: Kenneth Ismert
To: accessd at databaseadvisors.com
Sent: Wednesday, February 03, 2010 03:45
Subject: Re: [AccessD] Survey - Preferred Email and NewsGroups client
GMail, and yes for NewsGroups, GMail (sadly unconfigured for this use)
-Ken
------------------------------
Message: 16
Date: Wed, 3 Feb 2010 11:15:17 +0530
From: "A.D. Tejpal" <adtp at airtelmail.in>
Subject: Re: [AccessD] Survey - Preferred Email and NewsGroups client
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Message-ID: <016101caa494$f3434e70$3701a8c0 at adtpc>
Content-Type: text/plain; charset="iso-8859-1"
Doug,
Would it imply that you are accessing web based services without using any desktop client ?
Best wishes,
A.D. Tejpal
------------
----- Original Message -----
From: Doug Steele
To: Access Developers discussion and problem solving
Sent: Tuesday, February 02, 2010 21:24
Subject: Re: [AccessD] Survey - Preferred Email and NewsGroups client
Gmail for both
Doug
On Tue, Feb 2, 2010 at 6:23 AM, A.D. Tejpal <adtp at airtelmail.in> wrote:
> Members of this forum are requested to kindly indicate the application
> used by them for Emails and NewsGroups.
>
> Best wishes,
> A.D. Tejpal
> ------------
------------------------------
Message: 17
Date: Wed, 3 Feb 2010 07:16:58 -0000
From: "Max Wanadoo" <max.wanadoo at gmail.com>
Subject: Re: [AccessD] Two levels up (or down) , twice removed
To: "'Access Developers discussion and problem solving'"
<accessd at databaseadvisors.com>
Message-ID: <4b692324.0707d00a.12c0.ffff8aab at mx.google.com>
Content-Type: text/plain; charset="us-ascii"
You are correct in the loading order but if you have your links set up
correctly they work as expected. I have thousands of example over the
years and the parent is NEVER a step behind the sub form. Use the wizard to
load the sub form into the main form and set the link criteria via that and
it will work.
Max
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: 03 February 2010 04:55
To: Access Developers discussion and problem solving
Subject: [AccessD] Two levels up (or down) , twice removed
As you probably know by now, subforms load before parent forms, and their
current events fire before
the parent's current event. It always puzzled me how they pull off this
trick, but they do.
Usually this is not a problem but it can be. For example, the main form has
a "client" combo /
field. The child form does not use or care about that. The grandchild form
however needs that
value to filter a combo to only display records from a table for that
specific client.
In this case, it doesn't appear to work correctly. The combo in the
grandchild form is always a
step behind the parent form, IOW if the parent displays client A, the combo
in the grandchild
displays whatever the parent had the PREVIOUS record.
So the current event of the main form fires last after all of the child /
grandchild forms load (and
their load / current events fire). Logically, that current event of the
main form needs to reach
two levels down and tell that combo to requery itself.
What a PITA.
I actually built in to my framework collections of dependent child objects
so that I could tell a
form or a control on a form that "these objects are dependent on your data"
and call those objects
and requery them. Of course I have to write code in the load event of the
form to set up the
dependent object hierarchy.
So how do YOU handle this kind of situation?
Curious minds want to know.
--
John W. Colby
www.ColbyConsulting.com
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
------------------------------
Message: 18
Date: Wed, 03 Feb 2010 17:36:28 +1000
From: "Stuart McLachlan" <stuart at lexacorp.com.pg>
Subject: Re: [AccessD] Two levels up (or down) , twice removed
To: Access Developers discussion and problem solving
<accessd at databaseadvisors.com>
Message-ID: <4B69277C.4399.B6FA732 at stuart.lexacorp.com.pg>
Content-Type: text/plain; charset=US-ASCII
If you think about it, the parent can't finish loading until it's children have loaded since they
are in controls inside the parent.
I use an unbound parent "wrapper form" with all of the other forms as first level children. The
form also has a series of hidden text boxes which point to the PK in the parent form. I use the
textbox as the "Link Master Field" for the child form.
Most of the system I do these days use this method extensively.
As an example, tak a geographic system using a hierarchy of:
Province, District, LLG (Local Level Government Area), Ward with
tblProv = Prov_PK,Prov_Name....
tblDist = Dist_PK, Prov_FK, Dist_Name.......
tblLLG = LLG_PK, Dist_FK, LLG_Name...
tblWard = Ward_PK,LLG_FK,Ward_Name......
I create an unbound form frmMain with 4 child forms
frmProv, frmDist, frmLLG, frmWard.
I place the 4 child forms side by side on the parent form
I create 3 hidden text boxes
txtProvLink = [frmProv].[Form]![Prov_PK]
txtDistLink = [frmDist].[Form]![Dist_PK]
txtLLGLink = [frmLLG].[Form]![LLG_PK]
I set up the child form dependencies as:
frmDist: Linked Master Field = txtProvLink, Linked Child Field = Prov_FK
frmLLG: Linked Master Field = txtDistLink, Linked Child Field = Dist_FK
frmWard: Linked Master Field = txtLLGLink, Linked Child Field = LLG_FK
This method completely solves your problem. A child form does not update until the form
above it has finished updating.
It also has a few other advantages:
allows you to have as many generations as you can fit on your screen
you can use any combination of Single Form and Continuous Form at the various levels.
you can layout the screen in any way you want, you don't need child forms completely
embedded inside its parent.
--
Stuart
On 2 Feb 2010 at 23:54, jwcolby wrote:
> As you probably know by now, subforms load before parent forms, and their current events fire before
> the parent's current event. It always puzzled me how they pull off this trick, but they do.
>
> Usually this is not a problem but it can be. For example, the main form has a "client" combo /
> field. The child form does not use or care about that. The grandchild form however needs that
> value to filter a combo to only display records from a table for that specific client.
>
> In this case, it doesn't appear to work correctly. The combo in the grandchild form is always a
> step behind the parent form, IOW if the parent displays client A, the combo in the grandchild
> displays whatever the parent had the PREVIOUS record.
>
> So the current event of the main form fires last after all of the child / grandchild forms load (and
> their load / current events fire). Logically, that current event of the main form needs to reach
> two levels down and tell that combo to requery itself.
>
> What a PITA.
>
> I actually built in to my framework collections of dependent child objects so that I could tell a
> form or a control on a form that "these objects are dependent on your data" and call those objects
> and requery them. Of course I have to write code in the load event of the form to set up the
> dependent object hierarchy.
>
> So how do YOU handle this kind of situation?
>
> Curious minds want to know.
>
> --
> John W. Colby
> www.ColbyConsulting.com
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
------------------------------
Message: 19
Date: Wed, 3 Feb 2010 10:00:48 -0000
From: "Max Wanadoo" <max.wanadoo at gmail.com>
Subject: Re: [AccessD] Two levels up (or down) , twice removed
To: "'Access Developers discussion and problem solving'"
<accessd at databaseadvisors.com>
Message-ID: <4b694955.1818d00a.5d30.ffffb1c7 at mx.google.com>
Content-Type: text/plain; charset="us-ascii"
Stuart,
The sub form loads and then the other controls on the main form. The data
is undetermined at this stage.
The main form then re-queries itself and the sub form is bought into line
with the main form.
There is no need to jump through the loops you describe.
I am talking about bound forms through. If it was an unbound form I would
simple issue a requery command to the sub form.
Max
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan
Sent: 03 February 2010 07:36
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Two levels up (or down) , twice removed
If you think about it, the parent can't finish loading until it's children
have loaded since they
are in controls inside the parent.
I use an unbound parent "wrapper form" with all of the other forms as first
level children. The
form also has a series of hidden text boxes which point to the PK in the
parent form. I use the
textbox as the "Link Master Field" for the child form.
Most of the system I do these days use this method extensively.
As an example, tak a geographic system using a hierarchy of:
Province, District, LLG (Local Level Government Area), Ward with
tblProv = Prov_PK,Prov_Name....
tblDist = Dist_PK, Prov_FK, Dist_Name.......
tblLLG = LLG_PK, Dist_FK, LLG_Name...
tblWard = Ward_PK,LLG_FK,Ward_Name......
I create an unbound form frmMain with 4 child forms
frmProv, frmDist, frmLLG, frmWard.
I place the 4 child forms side by side on the parent form
I create 3 hidden text boxes
txtProvLink = [frmProv].[Form]![Prov_PK]
txtDistLink = [frmDist].[Form]![Dist_PK]
txtLLGLink = [frmLLG].[Form]![LLG_PK]
I set up the child form dependencies as:
frmDist: Linked Master Field = txtProvLink, Linked Child Field = Prov_FK
frmLLG: Linked Master Field = txtDistLink, Linked Child Field = Dist_FK
frmWard: Linked Master Field = txtLLGLink, Linked Child Field = LLG_FK
This method completely solves your problem. A child form does not update
until the form
above it has finished updating.
It also has a few other advantages:
allows you to have as many generations as you can fit on your screen
you can use any combination of Single Form and Continuous Form at the
various levels.
you can layout the screen in any way you want, you don't need child forms
completely
embedded inside its parent.
--
Stuart
On 2 Feb 2010 at 23:54, jwcolby wrote:
> As you probably know by now, subforms load before parent forms, and their
current events fire before
> the parent's current event. It always puzzled me how they pull off this
trick, but they do.
>
> Usually this is not a problem but it can be. For example, the main form
has a "client" combo /
> field. The child form does not use or care about that. The grandchild
form however needs that
> value to filter a combo to only display records from a table for that
specific client.
>
> In this case, it doesn't appear to work correctly. The combo in the
grandchild form is always a
> step behind the parent form, IOW if the parent displays client A, the
combo in the grandchild
> displays whatever the parent had the PREVIOUS record.
>
> So the current event of the main form fires last after all of the child /
grandchild forms load (and
> their load / current events fire). Logically, that current event of the
main form needs to reach
> two levels down and tell that combo to requery itself.
>
> What a PITA.
>
> I actually built in to my framework collections of dependent child objects
so that I could tell a
> form or a control on a form that "these objects are dependent on your
data" and call those objects
> and requery them. Of course I have to write code in the load event of the
form to set up the
> dependent object hierarchy.
>
> So how do YOU handle this kind of situation?
>
> Curious minds want to know.
>
> --
> John W. Colby
> www.ColbyConsulting.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
------------------------------
Message: 20
Date: Wed, 3 Feb 2010 06:20:55 EST
From: Johncliviger at aol.com
Subject: Re: [AccessD] Survey - Preferred Email and NewsGroups client
To: accessd at databaseadvisors.com
Message-ID: <16b2.19b8c89d.389ab617 at aol.com>
Content-Type: text/plain; charset="US-ASCII"
AOL email
no newsgroups
john cliviger
------------------------------
Message: 21
Date: Wed, 3 Feb 2010 06:11:18 -0600
From: "Dan Waters" <dwaters at usinternet.com>
Subject: Re: [AccessD] Ask Again? - Updateable Query - Access vs. SQL
Server
To: "'Access Developers discussion and problem solving'"
<accessd at databaseadvisors.com>
Message-ID: <A45985594E374601A1C460C9FE4FB28E at danwaters>
Content-Type: text/plain; charset="us-ascii"
Well - no joy. Good idea though.
Thanks,
Dan
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Max Wanadoo
Sent: Saturday, January 30, 2010 12:06 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Ask Again? - Updateable Query - Access vs. SQL Server
Dan,
Weird I know, but from time to time this has happened to me. I have found
that deleting the query and creating a new query (not cut n paste, but a
brand new query) has cured it. Some flag incorrectly set in the "behind
the scenes" sql code perhaps)
Shrug!
Try it and see if it works.
Max
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters
Sent: 29 January 2010 22:18
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Ask Again? - Updateable Query - Access vs. SQL Server
I have an Access file which contains a LEFT JOIN query between two tables.
If the query uses table links to an Access BE, the query is updateable -
which it should be. But if the query uses ODBC table links to a SS Express
database on my PC, then the query is not updateable.
To compound the mystery, the same Access query using ODBC table links to a
standard SQL Server database with the same tables IS updateable!
Does anyone know what's up with this or how it can be fixed?
Thanks!
Dan
--
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
------------------------------
Message: 22
Date: Wed, 3 Feb 2010 06:12:23 -0600
From: "Dan Waters" <dwaters at usinternet.com>
Subject: Re: [AccessD] Ask Again? - Updateable Query - Access vs. SQL
Server
To: "'Access Developers discussion and problem solving'"
<accessd at databaseadvisors.com>
Message-ID: <21C6B29E0FD144728B6525B498724F0B at danwaters>
Content-Type: text/plain; charset="us-ascii"
I did try that - but still not working.
Thanks!
Dan
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rusty Hammond
Sent: Saturday, January 30, 2010 1:58 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Ask Again? - Updateable Query - Access vs. SQL Server
Just a clutch, did you delete the linked table and relink after setting
the bit fields to not allow null?
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters
Sent: Friday, January 29, 2010 7:11 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Ask Again? - Updateable Query - Access vs. SQL
Server
The tables did have primary keys. There are several bit fields, and all
were set to allow nulls, with false as the default value. I changed all
the fields to no allow nulls, but that did not solve the problem.
Anything else?
Thanks!
Dan
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rusty Hammond
Sent: Friday, January 29, 2010 4:40 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Ask Again? - Updateable Query - Access vs. SQL
Server
A couple of things to check. Do you have primary key defined in the
linked table and do you have any bit fields that allow nulls?
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters
Sent: Friday, January 29, 2010 4:18 PM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Ask Again? - Updateable Query - Access vs. SQL Server
I have an Access file which contains a LEFT JOIN query between two
tables.
If the query uses table links to an Access BE, the query is updateable -
which it should be. But if the query uses ODBC table links to a SS
Express database on my PC, then the query is not updateable.
To compound the mystery, the same Access query using ODBC table links to
a standard SQL Server database with the same tables IS updateable!
Does anyone know what's up with this or how it can be fixed?
Thanks!
Dan
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
**********************************************************************
WARNING: All e-mail sent to and from this address will be received,
scanned or otherwise recorded by the CPI Qualified Plan Consultants,
Inc.
corporate e-mail system and is subject to archival, monitoring or review
by, and/or disclosure to, someone other than the recipient.
**********************************************************************
--
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
**********************************************************************
WARNING: All e-mail sent to and from this address will be received,
scanned or otherwise recorded by the CPI Qualified Plan Consultants, Inc.
corporate e-mail system and is subject to archival, monitoring or review
by, and/or disclosure to, someone other than the recipient.
**********************************************************************
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
------------------------------
Message: 23
Date: Wed, 3 Feb 2010 18:45:21 +0530
From: "A.D. Tejpal" <adtp at airtelmail.in>
Subject: Re: [AccessD] Survey - Preferred Email and NewsGroups client
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Message-ID: <005b01caa4d3$101189c0$3701a8c0 at adtpc>
Content-Type: text/plain; charset="iso-8859-1"
John,
Would it imply that you are handling the messages directly at web site, without making use of any desktop client ?
Best wishes,
A.D. Tejpal
------------
----- Original Message -----
From: Johncliviger at aol.com
To: accessd at databaseadvisors.com
Sent: Wednesday, February 03, 2010 16:50
Subject: Re: [AccessD] Survey - Preferred Email and NewsGroups client
AOL email
no newsgroups
john cliviger
------------------------------
Message: 24
Date: Wed, 3 Feb 2010 07:39:53 -0800
From: Doug Steele <dbdoug at gmail.com>
Subject: Re: [AccessD] Survey - Preferred Email and NewsGroups client
To: Access Developers discussion and problem solving
<accessd at databaseadvisors.com>
Message-ID:
<4dd71a0c1002030739v7d6ea63bp50e248ebe921637a at mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1
No, whenever I join a newsgroup I make sure that I get all the items emailed
to me so I can use Gmail. I filter all my incoming into folders. I
(almost) never use a web interface to look at a newsgroup.
Doug
On Tue, Feb 2, 2010 at 9:45 PM, A.D. Tejpal <adtp at airtelmail.in> wrote:
> Doug,
>
> Would it imply that you are accessing web based services without using
> any desktop client ?
>
>
------------------------------
Message: 25
Date: Wed, 3 Feb 2010 09:53:42 -0600
From: Debbie <delam at zyterra.com>
Subject: Re: [AccessD] Survey - Preferred Email and NewsGroups client
To: Access Developers discussion and problem solving
<accessd at databaseadvisors.com>
Message-ID: <938051A1-1506-40C7-BAA5-59B658CA7A12 at zyterra.com>
Content-Type: text/plain; charset=us-ascii; format=flowed; delsp=yes
I just use the service's webmail program for email and no newsgroups.
I had Internet service that made a mess of my email settings so often
in the name of Internet security that I gave up on outlook for a while
and have just gotten used to webmail. Interestingly, mail to these
lists does not go through from webmail, so I must send messages from
my phone.
Debbie
Sent from my iPhone
>>
>
------------------------------
Message: 26
Date: Wed, 03 Feb 2010 17:07:29 +0100
From: "Gustav Brock" <Gustav at cactus.dk>
Subject: Re: [AccessD] Survey - Preferred Email and NewsGroups client
To: <accessd at databaseadvisors.com>
Message-ID: <sb69ad5c.061 at cactus.dk>
Content-Type: text/plain; charset=US-ASCII
Hi A.D.
Sooner or later you should reveal why you are researching this ...
To confuse you, my colleagues use the desktop client when in the office and the web interface when at clients, and at home I use the client at my workstation, the web interface on the laptop, and (not so often) my mobile phone via a web access.
/gustav
>>> adtp at airtelmail.in 03-02-2010 06:43 >>>
.. you are accessing web based services without using any desktop client ?
Best wishes,
A.D. Tejpal
------------------------------
Message: 27
Date: Wed, 3 Feb 2010 11:15:23 EST
From: Johncliviger at aol.com
Subject: Re: [AccessD] Survey - Preferred Email and NewsGroups client
To: accessd at databaseadvisors.com
Message-ID: <9460.5954b37b.389afb1b at aol.com>
Content-Type: text/plain; charset="US-ASCII"
AD,
Yes.
johnc
------------------------------
Message: 28
Date: Wed, 3 Feb 2010 10:28:53 -0600
From: Gary Kjos <garykjos at gmail.com>
Subject: Re: [AccessD] Survey - Preferred Email and NewsGroups client
To: Access Developers discussion and problem solving
<accessd at databaseadvisors.com>
Message-ID:
<aea6c4951002030828o3f93e7dapa2e3f708bd8ad08a at mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1
Personal Email1 = Comcast email - Browser interface (called Smartzone)
Personal Email2 = Gmail - Browser interface
Work e-mail = Outlook 2003
No newsgroups
On Tue, Feb 2, 2010 at 8:23 AM, A.D. Tejpal <adtp at airtelmail.in> wrote:
> ? ?Members of this forum are requested to kindly indicate the application used by them for Emails and NewsGroups.
>
> Best wishes,
> A.D. Tejpal
> ------------
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
--
Gary Kjos
garykjos at gmail.com
------------------------------
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
End of AccessD Digest, Vol 84, Issue 3
**************************************