I.T. Discussion Community!
-Collapse +Expand
VB Classic
Search VB Classic Group:

Advanced
-Collapse +Expand VB Classic Store

Prestwood eMagazine

June Edition
Subscribe now! It's Free!
Enter your email:

   ► MB LobbyVisual Basic Classic BoardVB Classic Other Topic   Print This     

Help on DataEnvironment-VB 6

Help on DataEnvironment-VB 6 in VB Classic Other topic (part of our Visual Basic Classic group).

Quick Search: DataEnvironment   DataEnvironment   DataEnvironment VB  
jenEcis
-- USA
im having a problem with data environment

im supposed to generate reports using data environment and data reports wherein i can set specific dates using DTPicker,i came up with this codes:


DataEnvironment.Commands("Command1").CommandText = "SELECT DISTINCT POHead.PONumber, POHead.PODate, POHead.EmployeeName, POHead.POStatus, Suppliers.SupplierName, POHead.PODeliveryPlace, PODetail.RMTotal
FROM Suppliers, POHead, PODetail
WHERE Suppliers.SupplierNumber = POHead.SupplierNumber AND
POHead.PONumber = PODetail.PONumber and POHead.PODate BETWEEN #" & DTPicker1.Value & "# AND #" & DTPicker2.Value & "# "

Set DataReport.DataSource = DETables

DataReport.Sections("Section2").Controls("lblTO").Caption = Me.DTPicker1.Value

DataReport.Sections("Section2").Controls("lblFROM").Caption = Me.DTPicker2.Value

DataReport.Show vbModal

the problem is after i generate a report and then change the DTPicker Values the generated report remains the same from the previous report

im thinking that Data Environment command text isnt being refreshed or something.. or is it something else?

need help badly im just a noob in programming...thanks guys
 Posted 14 years ago (Thread Starter)
Comment Quote
About jenEcis -Collapse +Expand
Visit Profile
Membership pending.
Member subscribes to this thread but email is NOT VERIFIED.
Email Not Verified!
Once email is verified, we will review and approve the account.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Post ID #11348, 3 replies
Thread Started 11/9/2005 3:29:00 PM
View Counter=7858
Last Reply Posted 12/8/2006 11:46:00 PM)
Location=-- USA 
Joined=14 years ago   MB Posts=1  
casterqa
 (Inactive)
Philippines
hello good day, anyway im new here in this website, did you already try the sql command under the dataEnvironment Object? not in native code? i think you can solve you problem regarding with your project.
 Posted 14 years ago
Comment Quote
About casterqa -Collapse +Expand
Visit Profile
Inactive member.
Member does not subscribe to this thread.
Email Not Verified!
Once email is verified, we will review and approve the account.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Post ID #11378 (Level 1.1)  Reply to 11348
Thread Started 12/18/2005 8:56:00 PM
View Counter=2
Location=Philippines  
Joined=14 years ago   MB Posts=2  
casterqa
 (Inactive)
Philippines
do you have email address? so you i can send my sample source code regarding with your project.

thanks

Caster Beazar
Philippines
 Posted 14 years ago
Comment Quote
About casterqa -Collapse +Expand
Visit Profile
Inactive member.
Member does not subscribe to this thread.
Email Not Verified!
Once email is verified, we will review and approve the account.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Post ID #11379 (Level 1.2)  Reply to 11348
Reply Posted 12/18/2005 8:58:00 PM
Location=Philippines  
Joined=14 years ago   MB Posts=2  
Most Recent Post
heera
mp

Originally posted by jenEcis:
[QB] im having a problem with data environment

im having a problem with data environment

im supposed to generate reports using data environment and data reports wherein i can set specific dates using DTPicker,i came up with this codes:


DataEnvironment.Commands("Command1").CommandText = "SELECT DISTINCT POHead.PONumber, POHead.PODate, POHead.EmployeeName, POHead.POStatus, Suppliers.SupplierName, POHead.PODeliveryPlace, PODetail.RMTotal
FROM Suppliers, POHead, PODetail
WHERE Suppliers.SupplierNumber = POHead.SupplierNumber AND
POHead.PONumber = PODetail.PONumber and POHead.PODate BETWEEN #" & DTPicker1.Value & "# AND #" & DTPicker2.Value & "# "

Set DataReport.DataSource = DETables

DataReport.Sections("Section2").Controls("lblTO").Caption = Me.DTPicker1.Value

DataReport.Sections("Section2").Controls("lblFROM").Caption = Me.DTPicker2.Value

DataReport.Show vbModal

the problem is after i generate a report and then change the DTPicker Values the generated report remains the same from the previous report

im thinking that Data Environment command text isnt being refreshed or something.. or is it something else?

need help badly im just a noob in programming...thanks guys
--------------------------------------------------------------------------------
Posts: 1 | Registered: Nov 2005 |

casterqa

Rank: Cadet 1st Year
Member # 4960

Rate Member posted 18-12-2005 09:56 PM
--------------------------------------------------------------------------------
hello good day, anyway im new here in this website, did you already try the sql command under the dataEnvironment Object? not in native code? i think you can solve you problem regarding with your project.
--------------------------------------------------------------------------------
Posts: 2 | From: Philippines | Registered: Dec 2005 |

casterqa

Rank: Cadet 1st Year
Member # 4960

Rate Member posted 18-12-2005 09:58 PM
--------------------------------------------------------------------------------
do you have email address? so you i can send my sample source code regarding with your project.

thanks

Caster Beazar
 Posted 13 years ago
Comment Quote
About heera -Collapse +Expand
Visit Profile
Membership pending.
Member subscribes to this thread but email is NOT VERIFIED.
Email Not Verified!
Once email is verified, we will review and approve the account.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Post ID #11543 (Level 1.3)  Reply to 11348
Reply Posted 12/8/2006 11:46:00 PM
Location=mp  
Joined=13 years ago   MB Posts=1  

Revive Thread!

Add a comment to revive this old thread and make this archived thread more useful.

Write a Comment...
Full Editor
...
Sign in...

If you are a member, Sign In. Or, you can Create a Free account now.


Anonymous Post (text-only, no HTML):

Enter your name and security key.

Your Name:
Security key = P1242A1
Enter key:
Icon: A Post    Thread    Idea    Important!    Cool    Sad    No    Yes    Includes a Link...   
Thread #11348 Counter
7858
Since 4/2/2008
Follow PrestwoodBoards on: 


©1995-2019 PrestwoodBoards  [Security & Privacy]
Professional IT Services: Coding | Websites | Computer Tech