Avatar of RayT
RayT
Flag for United States of America asked on

Access/Visual Basic Question

I have the following AccessDataSource that returns the following columns

    <asp:AccessDataSource ID="PastWFTPs" runat="server" DataFile="~/App_Data/NSM.accdb" SelectCommand="SELECT * FROM [v_PastWFTPs]">
    </asp:AccessDataSource>
   
    Columns return
    ID                        Number
    WeekOf            Date/Time
    Title                  Short Text
    TheText            Long Text
    Inactive      Yes/No
    RecAdd            Date/Time
    RecMod            Date/Time
   
    How do I modify the following code to returns rows WeekOf within a particular range?
    How do I change this to accept parameters?
   
    For Each aRec As DataRowView In DirectCast(PastWFTPs.Select(DataSourceSelectArguments.Empty), DataView)
     'Do something'
    Next
Microsoft AccessVisual Basic.NET

Avatar of undefined
Last Comment
RayT

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Rgonzo1971

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
SOLUTION
Scott McDaniel (EE MVE )

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
RayT

ASKER
Thanks!  That's what I was thinking.  Thanks again for confirming my idea.
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck