Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Is "DataReport" in VB 5 or just VB 6
- Thread starter DougP
- Start date
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...
<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...
- Thread starter
- #3
Well if it's like other "NEW" releases then that feature may have been left in the "Recycle Bin" 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 = "TEST"<br>
and<br>
label1.caption = "TEST"<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 "common dialog box" 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>
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 = "TEST"<br>
and<br>
label1.caption = "TEST"<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 "common dialog box" 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>
Jerrycurl offered a solution that worked like a champ: the "path" of the Label to be .Captioned needs to be more detailed.<br>
<br>
That is:<br>
<br>
DataReport1.Sections("Section1"
.Controls("Label1".Caption = "Desired Caption"<br>
<br>
A long "address" for the Label to be .Captioned -- but it works perfectly.<br>
<br>
Which makes "sense" 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, "Swim!" is a valid answer to the question "How do I cross the river?" 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...
<br>
That is:<br>
<br>
DataReport1.Sections("Section1"
.Controls("Label1".Caption = "Desired Caption"<br><br>
A long "address" for the Label to be .Captioned -- but it works perfectly.<br>
<br>
Which makes "sense" 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, "Swim!" is a valid answer to the question "How do I cross the river?" 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...
- Status
Similar threads
