About
Pricing
Community
Teams
Start Free Trial
Log in
RayT
asked on
3/14/2017
Access/Visual Basic Question
I have the following AccessDataSource that returns the following columns
<asp:AccessDataSource ID="PastWFTPs" runat="server" DataFile="~/App_Data/NSM.a
ccdb" 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.Selec
t(DataSour
ceSelectAr
guments.Em
pty), DataView)
'Do something'
Next
Microsoft Access
Visual Basic.NET
3
2
Last Comment
RayT
8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Rgonzo1971
3/14/2017
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 )
3/14/2017
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
3/14/2017
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