troubleshooting Question

Access/Visual Basic Question

Avatar of RayT
RayTFlag for United States of America asked on
Microsoft AccessVisual Basic.NET
3 Comments2 Solutions141 ViewsLast Modified:
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
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 2 Answers and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros