Visual Basic Forum for Visual Basic Programmers VB

[xtine_m]

Hi! I am a VB newbie please help!!!

I am making a database. I ask for help months ago and someone helped me. My next problem would be, I have this sqlcommand and to be able to look up certain dates I will have to edit "DateFrom.text" to the date I want to show up. Is there anyway that I can connect a textbox to this so instead of going to the script and playing it, so I can edit the #11/04/04# & #12/30/04# while the program is in play mode?

SELECT Item_Code, SUM(Quantity) AS QTY, Description, SUM(Total) AS
Expr1
FROM Purchase WHERE Date BETWEEN #11/04/04# AND #12/30/04# GROUP BY
Item_Code, Description ORDER BY Description


Please help!!! Thanks!

[VB_Developer]

Hi,
Could you please elaborate your issue bit more.

Thanks

[xtine_m]

Hi! I use data environment to do the datareport. So in the dataenvironment properties I typed this command:

SELECT Item_Code, SUM(Quantity) AS QTY, Description, SUM(Total) AS
Expr1
FROM Purchase WHERE Date BETWEEN #11/04/04# AND #12/30/04# GROUP BY
Item_Code, Description ORDER BY Description

and I connect this to the datareport. But my problem is I can't compile the program since I will have to edit the dataenvironment properties so that I can specify the dates (#11/04/04# AND #12/30/04# ) everytime I want to make the datareport. If I'll compile it then I can't touch the dataenvironment properties anymore. Ryt?

if you want I can send you my program. Just PM me for your email. Thanks!