Is "DataReport" in VB 5 or just VB 6

[DougP]

I have never used it. but am going to start<br>
I saw posts here about it.<br>
I do have VB 6 and it is in there.<br>
I told someone about it but they have VB 5 and could not find it.<br>
Of course I don't have VB 5 anymore.<br>
<br>
TIA<br>

 

[GWhiz]

Yo, DougP!<br>
<br>
I stepped up to 6 from 4. Must've started DataReports with 6.<br>
<br>
Still can't figure out how to assign different value to .Caption property on labels before a DataReport is printed.<br>
<br>
Won't let you add TextBox to report header -- only Labels allowed. Seems that you could set .Caption when report opens (in Activate or Initialize events) -- but doesn't recognize installed Label as a valid object.<br>
<br>
Program bug? Or a screw loose in the programmer?<br>
<br>
Not so confident of my programming skills that I can insist that it's a program bug.<br>
<br>
But it doesn't seem like too much to ask to be able to do what I want to do simply and quickly...

 

[DougP]

Well if it's like other &quot;NEW&quot; releases then that feature may have been left in the &quot;Recycle Bin&quot; too long.<br>
You know when some new feature or program comes out there is something it won't do. Thats why we have Version 2,3,4,5 and 6 of VB.<br>
I looked at it briefly, your Thread and found the same problem. Can't change label Caption programmatically<br>
<br>
I tried several things<br>
DataReport1!label1.caption = &quot;TEST&quot;<br>
and<br>
label1.caption = &quot;TEST&quot;<br>
<br>
DID not work. I get error 438 <br>
<br>
Also not allowing a TEXT box in the Header is not very flexible. I use Text boxes in Headers all the time in MS Access '97 and '2000 to show which type of report it is.<br>
<br>
I guess we'll have to wait for a service patch or something.<br>
There is a place in Microsofts WEB site to add things (Wish List or something)<br>
<br>
I use Access more than VB now days. It will do everything VB will do cause VBA in Access is as powerful as VB6.<br>
And it handles Data a whole lot better.<br>
Add a table, make a query, create a form, find data. Click, snap, bang I got a whole app up in hours instead of weeks with Reports grouped and sorted or whatever.<br>
Bring in data from 6 sources using the Import and Linked tables. Cut and paste code from VB to Access with minor modification if any.<br>
I have both on my machine and can even add .OCX controls to Access.<br>
I use the &quot;common dialog box&quot; a lot<br>
<br>
Really the only thing I use VB for is Serial port communcation. And now that I think of it the MSComm control is an .OCX too.<br>
<br>
Drawbacks to Access<br>
1. Need a Pentium II or III to make data look up instant.<br>
2. To get help on .OCX's you need to go to VB cause Access dose'nt have it.<br>
3. Need Access on all clients, cause you can't make a .EXE out of it.<br>
<br>
<br>

 

[GWhiz]

Jerrycurl offered a solution that worked like a champ: the &quot;path&quot; of the Label to be .Captioned needs to be more detailed.<br>
<br>
That is:<br>
<br>
DataReport1.Sections(&quot;Section1&quot.Controls(&quot;Label1&quot.Caption = &quot;Desired Caption&quot;<br>
<br>
A long &quot;address&quot; for the Label to be .Captioned -- but it works perfectly.<br>
<br>
Which makes &quot;sense&quot; within the context of the programming conventions that I have become used to -- but, boy, I sure wish that the Help files had spelled it out a bit more.<br>
<br>
Sure, &quot;Swim!&quot; is a valid answer to the question &quot;How do I cross the river?&quot; But I really needed to know how to swim!<br>
<br>
Some VERY smart (and helpful) people on this forum!<br>
<br>
Yeah -- Access IS pretty powerful. A little creativity and you can do a LOT of what VB can do.<br>
<br>
I DO need to make .exe's for the projects I'm working on, and Access doesn't really allow that.<br>
<br>
Thanks for you help...