Visual Basic :: Display A Form Control's Text/caption To A Data Report Control

What Control To Display Data As A Report ?
I need to display data from database like a report but I don't know what control is the most useful ? If I use MSFlexGrid, how to insert data after select from database ? Thanks for help.

Need A Control To Display Text File Contents In Editable Form
Hi all,

     I need to display the contents of a .txt file on interface in an editable formate.
                Also want to store those edited contents in a .txt file.
                Could some one suggest me a suitable control for this purpose.

                Thanks

sachin

How To Control Data Report From Another Form?
Hi,
I need to change the value of a "report text box" in a report called datareport1, and the text box called text1.text,
i have a form where i enter a student info , so i need to build a report with these info, so how can i modify the report?
thanks in advance,

Caption For Data Control
I have a form with a bunch of fields. Now i have a add new button. Now when the user clicks the add new button i wnat it to display the new record in the data caption. So if their were 4 records and the user clicked add new it would show 5. Right now it just shows the last record in the record count????

Data1.Caption = "Record: " & (Data1.Recordset.AbsolutePosition + 1)

Get Text From Caption Control
Hi!

As you know, GetWindowText api doesn't work for Caption control, so any other way to get text from caption control?

Data Control's Caption Won't Work
I have the following code with the data control named: datPrimaryRS

Code:
Private Sub datPrimaryRS_Reposition()

datPrimaryRS.Caption = datPrimaryRS.Recordset.AbsolutePosition + 1 & " of " & datPrimaryRS.Recordset.RecordCount

End Sub

But for some reason when I go to the next or previous record it will not change the absolute position number at all.
ALSO:
The above is showing under Object - (General)
The above is showing under Procedure - (datPrimaryRS_Reposition)

Please help

Thanks

Stephen

Setting The Caption For A Form Control
I have a button in my worksheet that has been added via the "Forms" toolbar (Thus allowing you to set the text frame margins, which I couldn't work out how to do via a "Control" Button).

My problem is that I want the caption to change when the button is clicked, so before hand it says something like "click to do A" and after it says "click to undo A"...

I have set the name to my button so that I can reference it in my vba code as follows:

Code:
With ThisWorkbook.Worksheets("Name of Worksheet").Shapes("Name of button")
If something = 1 Then
'We have shown the row, so set the button text to "Do A"
.AlternativeText = "Do A"
.DrawingObject.text = "Do A"
ElseIf something = 2 Then
'We have hidden the row, so set the button text to "UnDo A"
.AlternativeText = "UnDo A"
.DrawingObject.text = "UnDo A"
End If
End With

My problem is that I can't set the DrawingObject.Text or Caption properties because I get the error message: Run-time Error 1004 :Unable to Set the TEXT/CAPTION Property of the Button Class.

Does anyone know what I'm doing wrong?

Thanks,

mpk

Form 2.0 Control - Commandbutton1.caption From
Greetings to all,

I have a simple question for you. I added microsoft forms 2.0 controls. After adding commandbutton1 on the form when i try to change the caption through the code it does not change. for example

Code:private sub commandbutton1_click()
commandbutton1.caption="Enable"
end sub
does not change the caption at the same time when I use the standard command1 button it changes the caption. Is there anything I am missing or is the code incorrect?

Please advise.

Thanks a lot

AneeLiyo
THAILAND - Land of Smiles
------------------------------------------------------------------------
"I may disapprove of what you say but will defend to the death your right to say it".

Edited by - Aneeliyo on 11/1/2005 5:40:46 PM

Text (caption) In Image Control?
I need an image control with the possibility of a text (caption) property.
Anybody knows an OCX or another solution?

Thanks.

Can VB Data Report Display Rich Text?
I need to display rich text in a VB data report. Can the data report display rich text? I can only get it to display the rich text with all the formatiing that goes along with it.

Thanks in advance,

Shannan

How To Display Large Width Report By CRviewer9 Control
I met a problem about crystal report prewiew by CRviewer9 Control in VB:
I have one report that width is large, so I set printer setup to "Maximum 11.7*17.7". Unfortunately, when I use CRviewer9 control to display that report, I only can see half of that report. Moreover, there is no horizon scroll bar.
I am looking forward your answer.Thanks.

How To Control The Data Report Control!!!!
Dear all expert,

Are any body know how to control the data report control??

such as the image control? i have been try many time but it still coming out the error message with "object or control does not support this matter"!!

code is :

datareport1.section(3).controls(1).picture = "c:1.jpg"

but i can received the name of the control but i can control it.

a = datareport1.section(3).controls(1).name

Please help me to solve the problem. i will very greateful that your assist!

How To Display The Content Of Text File In The Data Report?
Hey dude,

I want to to show the content of the text file in the data report. Can you please let me know that how can show the text file stuff in the data report.

code snippets will be prefered.

Thanks I am eagerly waiting for your reply.

please. help me.

Thanks

Kamlesh Gujarathi
kamlesh@itshastra.com

Fly always to the SKY. You can do anything if you TRY. ;)

Data Control Display?
I have just learned how to use a data control to change info for my football pool program. Primarily the weekly schedule of games, yet I don't know how toomake the controls' text display the week # that i've switched to. I would like it to display "'Week 2" when I change to that week. What am I missing here?

Data Display In The DataReport Control
Hi,

I have a DataReport control that I use to show certain records on a Recordset, which has a field with boolean (true-false) values. On a regular Access database, this would be -1's and 0's. So what I need to do is not to show the -1 and 0's but to show something instead of that. I mean, something like "This is true" instead of -1 and "This is false" instead of 0. How can I do this?

Thanks,
- Lucas

Data Display Using Control Array
Hi All,

I have a backend Access 2000 database. The front end is in Visual Basic 6.0.
Using a standard form I have retrieved records from the access database based on a specified condition. The data retrieved is displayed in the form using control arrays ( mainly labels ). But the problem is that some part of the data which does not fit in the form is not displayed.

Can the above problem be solved using vertical scrollbars? Please do not suggest using data reports because my requirement is using a form.

Any help in this regard will be highly appreciated.

Thanxs in advance.

How To Display Data In DataGrid Control
please tell me how to display data in DataGrid control, the simplest way to do it. please this is very urgent to me

Simple Data Display Control?
I’m trying to coerce the DataGrid control into displaying output from my application – there are no databases involved; I just want to display (8) columns of output with headers in an orderly fashion so that it can be viewed and printed. Is there an MS control that’ll do it simply? The help system is, as usual, as helpful as the proverbial chocolate teapot - or perhaps I'm just too thick to ask the right questions .....

Dave

Data Control To Display Only Certain Records
i have a subroutine that prompts the user for a case number; if they type in 000000 i need all the cases w/ 000000 to show up in the form and the user can click the arrow on the databound control to go through only the records with a case number of 000000

also how could i show all these records using a grid; i need a number they input to pull up a grid w/ all the records relating to that inputted number; like the 000000. So every case number w/ 000000 would appear in the grid. It needs to be exchangeable though depending on what number is entered by the user.

Need serious help!!!!

Thanks

Setting A Picture On Data Report At Runtime Using Report Image Control
Hello Everybody,
I got a very geniune problem I would like to share it with you all. Actually, I am developing a database software in VB inwhich program ask for name of student for which it should build a report personal report taking a data from the student database. The Problem is database also hold the picture of each students as one field. And when it generate a personal report discuss above it should also display his photo on the report. so, that when report is printed, it should print both picture and data.

till now what I have tried is placing the report image control on the data report during design time and then tried to chage the picture property of it during run time. But,a it gives error like method or property not supported.

So, do any body have idea to solve this problem

Lobpal

There Is A Control That Can Display Text OR Image?
Can't seem to get labels/picture/image control to do that, command buttons can havea image or caption, but I dont what it to buldge(sp) out like a button, it needs to look like a label...

Looking For Control - Calendar To Display Text
I am looking for a calendar control which I can display text for each date. Does anyone know of such a control? I have searched without success...

I am looking to display hours worked by date to the user, a graphical way depicting which days have not been entered...

Hai How To Display Text In A Calendar Control
Hai ,

I am using Microsoft Calendar Control 11.0 in my form, the size of the Calendar is made bigger nearer to the A4 size.

When the user select the Month or Year from the ListBox in the Calendar control
then i will check the database for the date for example

if the user choose Dec and 2005 from the control then I will check the DateField in my Database whether any date is available in the month of December and in the Year 2005, if it is present (12/28/2005) then i need to mark the Date and show the user in the Calendar Control.

The size of the Calendar control is big - so it will have space

i need to write the corresponding name of the Plant from the field PlantName in to the cell
28 in the Calendar Control.

kindly tell me how to work this.

Thankyou,
Chock.

Display Of Tabular Data--Control Needed.
Hi,
I am trying to display a set of tabular data which sometimes can
run long.At present I use Heirarchial Flex Grid and it does not
provide a gud User Interface and the readability is poor.I am
thinking of displayin them in a HTML page in the VB application
itself with some good GUI(Say like hyperlinks, etc.).So please
suggest a method to acheive the same ASAP.
Thanks in Advance.

Huge Data Display In Listview Control
In my project there is a situation where in i may have to display one lakh to 10 lakh records in listview control.the code i have written takes 5 min to display the one lakh records but the problem the form that has the listview control appears as though it is hung and user cannot do anything on the form.
So i want to display the data in chunks so that the system is not hung and user can actually start seeing the records that are fetched and scroll.(similar to find files dialog where in if some files are found it keeps on displaying and still the search is on and i can still scroll top and bottom)

if anyone can help me i would be glad

Can Data List Control Display More Than One Field?
I currently have a data list control that is bound to a table in my access database. It displays one field for each row in the table. I would like to display two fields of each row. Can a data list control display more than one field in each list item or do I have to retrieve each row and create my own list?

Thanks,
Tracy

How To Display Font Dialog On-form (Not CD Control)
As is done in various programs, such as Word. To be specific, I will be placing it on one particular tab of a Tabbed Dialog Control (SSTab). I assume that this needs to be done with API, but I have been unable to find a match in the API Viewer. Thanks in advance for any help.

Need Suggestion To Display A Form With Calendar Control ! Help Needed
Hai,

Need the Calendar for the current Year to be displayed in the Form When the user click the Next Button the Calendar for the NextYear should be shown in the Form.

Description:

I have to create a Form , the requirement is - when the user click the Command Button a Form shown to the user,in that Form 12 boxes is shown (12 boxes is to display the calendar for 12 month with dates of the Current Year - Just the Calendar for the Year). I am using Access as a Database, If i have the ShtDate in Database for the Current Year, then that dates should be Marked in the Calendar and it should be shown to the user. So to display calendar for the year in one Form what control i can use, is there any control available with this setup.

Kindly suggest me will this output looks good and the way of working will solve the requirement of a user.

Thankyou,
Chock.

Edited by - chs on 6/22/2005 9:02:05 PM

Need Suggestion To Display A Form With Calendar Control ! Help Needed
Hai,

My Requirement is - when the user click the Command Button "View Shutdown Dates" a Form is shown to the user, in that Form 12 boxes is shown (12 boxes is to display the calendar for 12 month with dates of the Current Year). If i have the ShutDown Date in Database for the Current Year, then the dates should be Marked in the Calendar and shown to the user. So to display the 12 box with the dates - what control i can use, is there any control available.

Kindly suggest me will this output looks good.
Thankyou,
Chock.

Display Header/Footer In Rich Text Box Control
I am currently working on a project which converts .rtf file to images eg: .jpg, .bmp. Everything is done. My project converts normal .rtf files (with no header or footer) correctly, but problem occurs when an .rtf file with header/footer comes into focus.

At very first i display .rtf file in Rich Textbox Control and then from there i convert it into image. But the problem is that Rich Textbox Control displays .rtf file but doesn't display Header/Footer, so my applicatoin proceeds with header/footer.

Please help me guys

Best Control To Use To Display Contents Of An ASCII Text Appending File?
Hi,

I have a chemical analyser grinding out results for several process streams. As part of saving historical data, I format the results from each analysis into an ASCII string with timestamp, and then append the string to the appropriate sample file.

What is the easiest way to allow the user to scroll through such files?

For event logging, I have set up a series of text lables (15 say) and the used a vertical scroll bar to dispaly 15 of the last 200 events. The events are stored in a circular buffer, which contains the last 200 events. This works well, as I can color each line to indicate the type of event (yellow on red for error, white on green for result, white on blue for standard..). But the coding is fairly complex and am looking for a simple display of analytical results for a given sample stream.

In the case of the anlysis results, the data is appended, so the file just keeps growing. Presumably, monthly files will be separated and stored.

DAta Grid Using Adodc Control Doesn't Display Sorted Record Why?
Please Help me any coding suggestions...I have a datagrid using AdodcControl as a datasource cant display sorted record but instead the record is jumbled every time I load the form...I have tried using an SQL statement with Order BY [FIELD] ASC but still it wont work...Please can somebody help me about this problem...Thanks...

Data Report Control?
Hi
Could anyone tell me which Ocx or Dll Control the VB Data Report belongs to please?

Problem I have is one machine has been upgraded to XP and when trying to run a report "Error Loading Type Library/DLL" occurs

Thanks

How To Use Data Report Control In Vb6?
I use data environment control and data report control.
but the distance between two data from database is too large.
it print as below:

name age
tom 20

name age
jerry 21

name age
john 22

I want to the result as below :

name age
tom 20
jerry 21
john 22

how to make the result?
Thanks.

Getting The Value Of A Text Control Of A Report (VBA)
I have i project in access and it seems like i forgot how to use Access so what i need is to get the value of a text control (text0) within a report (report1) with code. can someone remind me how?

thnks

Image Control In Data Report
Hello,
I have an image control on a report. It is in a grouping. I have the filename of a picture in a datafield in the recordset that is being used on the data report.
When running the report, I would like the image control that is in the grouping to be loaded with the picture that is in the picture datafield located in that grouping. This way, each record that is displayed on the report will have a little picture of the item, that record/grouping is describing.

I have no problem loading an image into an image control in code. The problem is for every record displayed, the same pic is showed, not the pic that is saved in that records/grouping picture datafield.
Is this possible?

Thanks ahead for any help.

Aaron

Data Report Fuction Control
hello friends

I m using datareports, and filled the data in the report using coding now a problem arrises that i want to show the aggrigate of each field and also % of each field for which i have created two function rptsum and rptVcount on that field now i want to divide these two function fields pls do help me. How can i mnipulate the function data and save it in third function or any label in data report
Thanks in Advance
Geetanjali

Control Data Report Dialogbox
I want to disable or control printing and export dialogbox of data report tool, as I want to log the printing information and there is no such event to do so or to control the number of copies printed at a time.

Data Report's Control Problem
I have two group header and two group footer in my data report in vb6.0
lets say gpheader1, gpheader2, gpfooter1 and gpfooter2

Now, my header1 contains a rptTextBox that stores the value of opening Balance. Lets say it as rptTextBox1.

My, gpFooter2 contains a rptFun that sums all the amount that comes in detail section. Lets say it as rptFunSum1

The values in detail section comes based on date between query entered by user i.e. start date and enddate.

Now, my gpfooter1 contains one rptTextBox. Lets say it as rptTextBox2 which is required to store the value as :

rptTextBox2=

rptTextBox1(textbox for opening balance)
- rptSumFun (if the summation is of debit amount)
+ rptSumFun (if the summation is of credit amount)

I am getting the value for rptTextBox1 and rptSumFun but how to use this values for doing summation or deduction and storing in rptTextBox2

Activex Control In Data Report
Good day,

How can I use and put an ActiveX control in the Microsoft Data Report Designer?

Thanks

PLEASE HELP!! What Control To Use To Add Crystal Report In A Form
still a newbie in vb here.......can anybody please help me,,,
what particular control should i add in my form to incorporate crystal report in my program???
when i'm adding a crviewer, there are no properties to set.....i can't link my database or the report i made in crystal report 8.
i don't know if i am missing a reference or a component.......please help me! thanks very much!

Call A Control's Method From A Form Launched By The Control's Control? (???)
I've placed control A on an active x control. I have a command button that launches form B. From form B I want to call one of control A's methods. I'm gettting an error stating 'Object variable or With blokc not set'. Can anyone tell me how/if I can access this object from this point in the code? I looked at Friend but that didn't seem to solve my problem. Any help would be appreciated.

How To Make Data Report Without Using Data Control
Hallo Hi...
I want to make a report using DATA REPORT without using DATA CONTROL ( using ADODB - code). Please someone give me a hand to make a very simple example code regarding on that.

My database : mydata.mdb
My recordset: Personal
My fields : Name, Address

Just give me the syntax.

Thanks..

Data Report And Custom ActiveX Control
Hi all,

Is it possible to add a custom ActiveX Object into the VB Data Report?
I tried adding it from the add components menu, select the activeX i wanted to add, but its grey out.

Thanks and Best Regards.

Crystal Report 4.5.. Data Control Refresh
I'm new in crystal report and am currently trying ver 4.5.. I'm having problem refreshing the data to be displayed by the report. I tried using

strsql = "[asd] = 'w'"
report.SQLQuery = strsql
report.Destination = crptToWindow
report.WindowState = crptMaximized
report.Action = 1
but it still displays all the records from the table. Help is much appreciated.. thanks

I also tried using data control and passing the recordsource to the report.SQLQuery but to no avail

Where Is The Microsoft Data Report Control ActiveX?
I read a VB6 book saying that this reporting control has been included in VB5 onwards .. But I couldn't find it in my VB6 components.. Do I have to install it separately ? From where ?

Thanks.

Printing Data Report In VB6 - Control End Of Page
Hello,

Could someone help me with this : I am using a datareport on a supermarket app , to produce the final bill. Everything works fine , but the app always prints the full page , causing the printer to scroll forward on every bill. I did not succeed in any way to define the data report page size to be printed. Any solutions ?

Thanks Alot

How To Hide Control Icons On A Data Report
I have created a data report in VB6. When I run it, it shows a print icon, an export icon and a zoom icon on top.

Can I hide, or disable, the print icon and the export icon but still keep the zoom control working?