Rabu, 22 Mei 2013

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@yahoogroups.com] On Behalf Of Bill Mosca
Sent: Wednesday, May 22, 2013 1:21 PM
To: MS_Access_Professionals@yahoogroups.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, "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, "Bill Mosca" <wrmosca@> wrote:
> >
> > Doyce-
> >
> > Thanks for letting us know you solved the problem.
> >
> > Bill
> >
> > --- In MS_Access_Professionals@yahoogroups.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, "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.

__._,_.___
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (7)
Recent Activity:
.

__,_._,___

Tidak ada komentar:

Posting Komentar