Jeff
> trying to lift a brick chimney by the column of smoke
Never heard that before. I like it.
Regards,
Bill
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of jpjones23@centurylink.net
Sent: Wednesday, May 22, 2013 1:57 PM
To: MS Access Professionals
Subject: Re: [MS_AccessPros] Re: No Data when split form opens
Sometimes it amazes me at how much clarity can be realized in the 6 inches between one's mouth and one's ear. I suspect that the effort to put whatever the problem is into actual words rather than just thoughts is the culprit. All too often I see people busy listening to their own thinking more than to another's words, including myself. Therefore, even when I am alone, verbalizing a problem can cut through the haze so that I'm no longer trying to lift a brick chimney by the column of smoke.
I strongly recommend, based on 30+ years development experience, that that 6 inch path between mouth and ear be traversed frequently!
Thus endth my 02 cents,
Jeff
----- Original Message -----
From: "Liz Ravenwood" <liz_ravenwood@beaerospace.com <mailto:liz_ravenwood%40beaerospace.com> >
To: "MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com> " <MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com> >
Sent: Wednesday, May 22, 2013 4:27:03 PM
Subject: RE: [MS_AccessPros] Re: No Data when split form opens
YES! I was just yammering on about something I fixed to someone out loud and realized I'd forgotten something else. If I hadn't verbalized it, I would have left the bug in.
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%40yahoogroups.com> [mailto: MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com> ] On Behalf Of Bill Mosca
Sent: Wednesday, May 22, 2013 1:21 PM
To: MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com>
Subject: [MS_AccessPros] Re: No Data when split form opens
Doyce
Same thing happens to me. Sometimes I just have to verbalize a problem and I get the "ah-ha!" moment.
Bill
--- In MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com> , "dnwinberry" <winberry.doyce@...> wrote:
>
> You're welcome Bill. It happens often that right after I send a request for help, I think of something else to try that often works. :-) Perhaps just stating the problem helps my brain come up with a solution. Thanks to all you pro's who are out there helping us!!
>
> Doyce
>
> --- In MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com> , "Bill Mosca" <wrmosca@> wrote:
> >
> > Doyce-
> >
> > Thanks for letting us know you solved the problem.
> >
> > Bill
> >
> > --- In MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com> , "dnwinberry" <winberry.doyce@> wrote:
> > >
> > > I think I've solved my own problem. I put Me.requery in the forms load event and it works as I want.
> > >
> > > Doyce
> > >
> > >
> > > --- In MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com> , "dnwinberry" <winberry.doyce@> wrote:
> > > >
> > > > Hello all,
> > > >
> > > > I have created my first split form. I'm using Access 2010. This form is based on a query that filters records by the date in a text box on the form with the default value of Date(). However the form opens without showing any records and I'd like for it to open with records dated today. In the after update event of the date text box, I have Me.requery which populates the form with the correct records. I just can't get it to open with today's records even though the text box opens with today's date in it. Please help. Here is the SQL of the form's record source:
> > > >
> > > > SELECT tblUntaggedUnits.UnitID, tblUntaggedUnits.CustID,
> > > > tblUntaggedUnits.BuildDate, tblUntaggedUnits.InspectionComments,
> > > > Customers.[Cust Name] FROM Customers INNER JOIN tblUntaggedUnits
> > > > ON Customers.[Cust ID] = tblUntaggedUnits.CustID WHERE
> > > > (((tblUntaggedUnits.BuildDate)=[Forms]![frmUntaggedByDate]![txtD
> > > > ate]));
> > > >
> > > >
> > > > Thanks,
> > > > Doyce
> > > >
> > >
> >
>
------------------------------------
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.
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (9) |
Tidak ada komentar:
Posting Komentar