Help!!! To Export Acess Report To Rich Text Format Through Vb6.0
Dear friends
I am creating a project in which i want to export access report to rich text format through vb. Is there any way to day that.
Plz!!! help its urgent
Thanks in advance
shivpreet2k1
View Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
Rich Text Box = Acess Report Impossible?
Hi, i asked this question before........in a diifferent way...i got the answer...but still i am struggling with it..all i want to do is make a Rich text box look like an acess report like this...........
this is the code i am using .........
Dim Textlen as integer
With RTB
.Text = " Report"
.SelStart = 0
.SelLength = Len(.Text)
TxtLen = Len(.Text)
.SelBold = True
.SelItalic = True
.SelFontSize = 20
.SelColor = &H800000
.SelLength = 0
.Text = .Text & vbCrLf & vbCrLf
.Text = .Text & " Date " & " Student Name " & " Time " & vbCrLf & vbCrLf
.SelStart = TxtLen
.SelLength = Len(.Text) - TxtLen
.SelFontSize = 13
.SelUnderline = True
.SelLength = 0
' it works up to here
TxtLen = Len(.Text)
.Text = .Text & " 11/12/ 2001 Deane 9:00 am "
.SelStart = TxtLen
.SelLength = (Len(.Text)) - TxtLen
.SelUnderline = False
.SelFontSize = 10
.SelColor = vbBlack
.SelItalic = False
.SelBold = False
.SelLength = 0
End With
it works up to a point but when it it passes it, it goes all bazzar.......i don't see any flaw in the code.....
mabe u will.......please give this a try.....i have been struggling with this for a great lenth of time......
i am almost at the conclusion that this is impossible.......is it?
thanx a trill
*Challenge* Rich Text Format In Crystal Report Viewer
I am actually writing my text data in the Rich Text Box of VB6. I have given buttons to do some formatting like 'Bold', 'Tab' etc. for the Rich Text Box data like MS WORD. The data is then saved in the Access Data Base in RTF format. When I retrieve the data from the Access data base to VB6, it is OK. But when I retrieve the same data in Crystal Reports 8.5, then CR is not able to interpret the data correctly. The text is OK but the formatting is disturbed.
Failed To Export The Report, Error In MS Excel Export Format DLL
Hi,
I have a little problem with Crystal Reports (CR 8) :
I try to export one of my reports from a VB program. When I try to export it in "Comma Separated Values" format everything is ok (except this is not the format I need
). When I try to export it in excel format it works, on some PCs but not on others ?
VB code sample :
rpt.ExportOptions.FormatType = crEFTExcel80Tabular
rpt.ExportOptions.DestinationType = crEDTDiskFile
rpt.ExportOptions.UseReportDateFormat = True
rpt.ExportOptions.UseReportNumberFormat = True
rpt.ExportOptions.DiskFileName = txtExportDirectory.Text & ExportName
rpt.Export False
I tried all the excel formats (crEFTExcel50, crEFTExcel50Tabular, crEFTExcel70 ...) but on some PC's I always get the "Exporting Records" window for a second and then the error "Failed to export the report, Error in MS Excel Export Format DLL".
Can anyone help me out ?
Thanks !
Crystal Report Export To .RTF Format
While exporting report from crystal to .rtf format in MS Word, It exports the text boxes also to the .rtf file..Is there any way to avoid this and only plain text shud get exported to the rtf file rather text with text box.
To Export Crystal Report In Excel Format
Hello friends,
I made an application in vb 6 to generate crystal reports but i don't want to use export button of crystal report and want to add my code in vb which will automatically convert it into excel or pdf format. Also if possible it shld automatically send mail to my id without using outlook express....
waiting for responses,
varsha
Export A Crystal Report To PDF File Format Through VB
Hi,
when i export a crystal report to PDF file format through VB i did not get a file PDF file format . but if i goto crystal report and from the preview i can export PDF file format. Can you guys pls give me a suggestion ,
Thanks,
kirupaj
Export-Contents Of Rich Text Control To Word 97
Hi All,
I am trying to export the Contents of the Rich Text Box to Word 97.
The content of the Rich Text box is a formatted Text with multiple fontsize,
fonts foreground color and background color. On clicking a command button the
contents of this rich text box should be exported to Word 97(with the same
format)
Thanks & Regards,
Kamalamba
Data Report Problem (export Format Messed Up)
Hello all,
I needs some help here before I pull out all of my hair. I wrote a program in vb6, that use an access db and data reports. The problem is that when I view my reports in the preview, everything is perfect, all formatting is where it should be, but when I export the file (txt or html, tried both) and save it to my computer and open it again, some the formatting is out of wack. Some parts skip over a few spots and some print on the line beneath it. Why is this doing this?
Help anyone.
Thanks,
Data Report Problem (export Format Messed Up)
Hello all,
I needs some help here before I pull out all of my hair. I wrote a program in vb6, that use an access db and data reports. The problem is that when I view my reports in the preview, everything is perfect, all formatting is where it should be, but when I export the file (txt or html, tried both) and save it to my computer and open it again, some the formatting is out of wack. Some parts skip over a few spots and some print on the line beneath it. Why is this doing this?
Help anyone.
Thanks,
creggio
Adding Text To Rich Textbox Without Changing Format Of Existing Text?
Hello all. This is my first time working with RTB's, and I'm having a little trouble getting started. I'm sure it's some little problem of syntax/semantics, but I can't figure it out. A little help would be greatly appreciated!
I have a RTB to which I am trying to add texts of different formats. When I add each string, the entire box text takes the most current format. This makes perfect sense to me, as I am essentially rewriting the ENTIRE textbox (I am using the ".Text = .Text & "NEWTEXT" format that I am accustomed to using for textboxes.
What am I doing wrong? Thanks!
VB Code:
'1. Create a new form.'2. Add a button named butGo.'3. Add a RTB named rtbText.'4. Cut & Paste the procedure below. Private Sub butGo_Click()Static Counter As IntegerCounter = Counter + 1With rtbText Select Case Counter Case 1: .Font.Size = 16 .Font.Bold = True .Text = .Text & "This is a test..." Case 2: .Font.Size = 12 .Font.Bold = False .Text = .Text & "This is only a test!" Case 3: .Font.Size = 6 .Font.Italic = True .Text = .Text & " Can you see me?" End SelectEnd WithEnd Sub
How To Know The User Selection Export File Format Based On Microsoft Data Report
Hi all,
i am using microsoft data report in VB 6 , how to i get the user selection file format (open the export file dialog box) he or she wish to export the file for example to EXCEL. or is any window API to detect the file selection from the file dialog box.
after when the user select *.xls for export i wish to do other application processing , therefore is there any other to detect or know the file format selection from the file dialog box ?
Private Sub DataReport_Initialize()
rptDemo.ExportFormats.Add _
Key:="ExcelReport", _
FormatType:=rptFmtText, _
FileFormatString:="Excel (*.xls)", _
FileFilter:="*.xls"
End Sub
Private Sub DataReport_AsyncProgress(ByVal JobType As MSDataReportLib.AsyncTypeConstants, ByVal Cookie As Long, ByVal PageCompleted As Long, ByVal TotalPages As Long)
Dim iCount As Integer
Dim i As Integer
'iCount = rptDemo.ExportFormats.Count
'
'For i = 1 To iCount
' Debug.Print rptDemo.ExportFormats(i).FileFormatString
'Next
End Sub
Rich Text Format
Hi There,
I have search all over the internet to find code to format a phrase but I haven't had much luck. Most of the code is for formatting keywords.
I finally got this code:
Code:
Public Sub RTBFormat(RTB As RichTextBox, sWord As String, sBold As Boolean, sItalic As Boolean, sColor As ColorConstants, intIndent As Double)
Dim i As Long
Dim p1 As Long, p2 As Long
Dim Text As String
Dim sTmp As String
Text = RTB.Text
p1 = InStr(1, Text, sWord)
Do While p1 > 0
RTB.SelStart = p1 - 1
RTB.SelLength = Len(sWord)
RTB.SelBold = sBold
RTB.SelColor = sColor
RTB.SelItalic = sItalic
RTB.SelIndent = intIndent
p1 = InStr(p1 + 1, Text, sWord)
Loop
End Sub
The only problem with this code is that everything is in the same formatting!!
For example if I have the sentence "Hello World" and I tell it to have hello red and world blue the whole text is in blue.
I am trying to use this code in a chat program I am making. Could some help improve it so it only modifies the phrase I want.
Thanks in adance,
James
Rich-Text-Format
Problem-Description:
I wrote a Macro which saves E-mails on HardDisk. I have two selectable Formats : *.msg & *.rtf . so i got the problem , that the Part with the rtf-Format doesn´t work proberly. Based on the fact, that i suppose that the (vba-outlook) - saveAs - Method- Call is correct it must depends on the content or (and) the file-appendix.
Does anybody knows more about it ?? ! !
THX NEXUS
Edited by - NeXuS_ONE on 11/4/2003 1:36:12 AM
Rich Text Format
I looking a sample about how to paste a BMP from
clipboard, I tried this
rtfVista.OLEObjects.Add , , , Clipboard.GetData()
rtfVista.Refresh
I tried to get the RichText.vbp, which is located in
the VBSamplesCompTool directory of the Visual Basic
CD-ROM, but I couldnt find it, anybody will help me?
Thanks by your help
Alfredo
Rich Text Format
I am facing a problem where the .rtf file in rich text box are not in A4 size and this make my alignment are not in the right manner. Is the rich text box don't have a function where we can set the paper size as A4 or it only have a maximum size? Another problem is how can I load the table or line in winword and display in rich text box? Hope to get a sample program for the problem! Thanks...
Mail From Rich Text Format
Hi!
I would like to send a formatted email from a Rich Text Box from my own application.
I don’t want to send the RTF-text as an attach file, but as a formatted text witch appear formatted directly in the arriving mail.
How do I tell my application that I should send the mail as RTF format?
I use the Winsock control.
Is this possible?
Best regards
Magnus Pernsved
Rich Text Box Format Problem
I'm having some trouble with the RichTextBox. On the computer I developed the application on, it works fine, but all others that I've installed the app, it doesn't work properly. Somehow, when I'm hiding the form with the richtextbox, it looses it's bold, italic and superscript formatting (if any exists) and this is triggering the change event. The result is the user is asked if they want to save changes before they continue, even though no changes have been done. I've made sure that both machines are using the same version of RICHTX32.OCX. Has anyone seen this before? Is this a flaw in the control?
Thanks,
Scott
Access Records Export In Text Format
I want to export access database records to delimited comma seperated text format.
Please guide me it's very urgent.
Thank You
Rahul
<rahuldoshi@hotmail.com>
Funky Format Of RTF Rich Text Boxes
I have a VB5 app using rich text boxes to display data from RTF files. The files were created in Wordpad. At home the data displays correctly in the boxes both during development and when run. In work, this morning, I discover a right margin (?) in the box (so it appears) is causing the text to word wrap and mess up the format. Yet RightMargin is set to zero. Any clues?
AS WRITTEN (and displayed at home)
Plastics
Thermoforming is a process by
which a flat sheet of plastic is...
AS DISPLAYED
Plastics
Thermoforming is
a process by
which a flat
sheet of plastic
is...
Saving A File In Rich Text Format?
Hi,
I'm currently making a program which is much like Word, and I have decided to save all of the documents as a RTF file. I have worked out the common dialogue bit for saving, but when I paste a picture into the Rich Text Box, and save it, the picture isn't there! and the font that I have selected isn't there! It's always Courier New!!
Any help would be greatly appreciated,
Chris
Parsing Rich Text Format Files
I was wondering if anybody has ever tried to do this?
I'm trying to decide which way works the best. Either taking each rtf file and saving it in text format, then parse out the data...
-or-
Add a Microsoft Word reference to a vb project, open the file, read and parse out the data...
Any suggestions would be greatly appreciated!!!
Sending A Mail With Rich Text Format
Hi Guys,
I am trying to send mail from the code below. what parameters do i need to change to such that mail can be decrypted in the correct format. The attached file is the description of the mail i get.
************************************************************************
Public Function SendMail(strTo As String, strCC As String, strBody As Variant, strSubject As String)
Dim oItem As Outlook.MailItem
Set oOutlook = New Outlook.Application
Set oItem = oOutlook.CreateItem(olMailItem)
With oItem
.To = strTo
.CC = strCC
.BodyFormat = olFormatRichText
.Body = strBody
.Subject = strSubject
.send
End With
End Function
************************************************************************
Can anyone help me on this..
thanks
Text Encryption In Rich Text Format
How can i get ascii text encryption to work with a rich text box. An example i found such as this(below) will not work with a richtext box. Anyone have any ideas or examples to show me?..Working out of a rich text box and a password:
'Encrypt text
Private Function EncryptText(strText As String, ByVal strPwd As String)
Dim pwdpos As Integer, c As Integer
Dim strBuff As String
#If Not CASE_SENSITIVE_PASSWORD Then
'Convert password to upper case
'if not case-sensitive
strPwd = UCase$(strPwd)
#End If
'Encrypt string
If Len(strPwd) Then
For pwdpos = 1 To Len(strText)
c = Asc(Mid$(strText, pwdpos, 1))
c = c + Asc(Mid$(strPwd, (pwdpos Mod Len(strPwd)) + 1, 1))
strBuff = strBuff & Chr$(c And &HFF)
Next pwdpos
Else
strBuff = strText
End If
EncryptText = strBuff
End Function
~~~Thanx
Rich Text Box Format To Text File
I want to be able to save the contents of a Rich Text box to a text file so that the formating looks the same as the way it displayed on the screen. The rich text box does wrap the words correclty but when you save the text box conents, it's just one long string. Any ideas?
Export A MS Acess Table To Excel Throug VB
I have some data in msacess table which i have to export to a excel file from VB 6
Can I do that
Their is be excel in the user pc but thy dont have MS acess
Can u help me to expot a Table
It might be a recordset which has be created by Select Statement
Covert Rich Text Content To HTML Format
I have some formatted content in the Rich text Box. Is there any way to convert the contents to HTML so that i can display it in Outlook email message window.
My requirement is to format some text contents to be included before sending an automated email through MS Outlook
Help Please....
Rich Text Box Usage For Read-only File (RTF Format)
Hi, I'm working on opening a Rich Text Box to display a file that will be read-only for a .RTF file. I'm trying to get it so that the cursor doesn't appear in the box, and have a scroll bar appearing on the right hand side. I think I can do it using the enabled function set to false, and using a vertical scroll bar, but I'm not quite sure how to. I know how to use scroll bars, but I just don't see how I can code it to scroll up and down the text in a Rich Text Box. Can anyone help?
Mapi And Rich Format Text In Message Body ???
Hello
I am trying to send email using MAPI controls and i want the text of Body to be in Rich Format.
I tried this with RichTextBox but no result.
does anyone have any idea ???
thanks
Sending A Mail With Rich Text Format -Correct
Hi Guys,
I am trying to send mail from the code below. what parameters do i need to change to such that mail can be decrypted in the correct format. The attached file is the description of the mail i get.
************************************************************************
Public Function SendMail(strTo As String, strCC As String, strBody As Variant, strSubject As String)
Dim oItem As Outlook.MailItem
Set oOutlook = New Outlook.Application
Set oItem = oOutlook.CreateItem(olMailItem)
With oItem
.To = strTo
.CC = strCC
.BodyFormat = olFormatRichText
.Body = strBody
.Subject = strSubject
.send
End With
End Function
************************************************************************
Can anyone help me on this..
thanks
Text Format In Rich Text Box
i've got richtext box and i've set the font and size, ok, but when you copy and paste from another app into it, the font and size from the copied text is used. anyone know of a way to use the font and size i am using?. The only way i can think of is to select all the text in the rich text box and reset the font immediately after new text is added.
(please excuse the crap typing, got one arm in a sling after a nasty squash accident)
cheers
john
Crystal Report 9 Export To Text
Im trying to export reports in Crystal Report. There seems to be no problem in the main report's txtfile output but in the subreports labels and data are misaligned. So the report looks distorted. Thanks Extreme people.
Preparing A Report Using Rich Text Box
i have a code generating variable size of data according to user, and i want to prepare a report of that data on a rich text box by runtime through code, i want some lines have different font size and name
is it possible to do it with code?
below is an line by line example of what i want to do;
TITLE
File : blah.blh Date : xx-xx-xx
Price: xx$/kg Capacity : 1000kg
Materials Price Min Max
_______ _____ ____ ___
Variable1 xxxx xxx xxx
Variable2 xxxx xxx xxx
.
.
.
.
.
.
.
______________________________________
Feed Min Max Mixture
____ ____ ___ _______
Variable(x) xxxx xxx xxxxxx
.
.
.
.
.
.
.
.
Something like that, i want some lines have different font style and size
and code have to generate this variable sized table on RTBox
if it is possible how can i do that, the RTB examples i have searched are user dependent
How To Get Rich Text In Data Report ?
How to get the Rich text in the Data report.. as the data is present in memo field of Table and I need to show the same in report.. can anybody help me..
Sarma ..kvsarma@yahoo.com
Export From Crystal Report To Text File.... Help ?
Dear
I use a command like that Report.Export to export from crystal report ( CRViewer ) to text file.
Than i choice Format = Text and Destination = Disk File
with name = "test.txt".
When I open it, some object can't export from Crystal Report to Text file ( i use a text object ) and if it's field object it can to be export ( field object ).
I have try but still not work. So anyone can help me........
Best Regard's
Long
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
Data Report Question And Rich Text
I am printing a data report and one field in the report is in Rich Text Format. I need to keep it RTF because of the formatting, etc. Currently it comes out on the data report like this :
{
tf1ansideff0{f0fnilfcharset0 MS Sans Serif;}}
viewkind4uc1partlang1033fs17
par Procedure: Sample procedure
par
par Method: Sample method here
Obviously not very appealing to the end user. Is there any way to get the data report to print out Rich Text without the other stuff? I am printing this stuff in a label on the data report.
Thanks in advance. You guys always come to the rescue when I have one that holds me up.
Shannan
Data Report - Displaying Rich Text From DB
Hi -
My question is: How do you display rich text (italics, underlines, bold) from a database on a Data Report?
I have written Rich Text from the MS Rich TextBox to a memo field in an Access Database.
I now need to display the text from the DB on a Data Report. When I bind the memo field to a RptTextBox field on the Data Report, it displays the data, but not the formatting. In fact it displays all the ASCII codes for the formatting that was in the MEMO field.
The data is being displayed like this:
{
tf1ansideff0{fonttbl{f0fnilfcharset0 MS Sans Serif;}}
viewkind4uc1pardlang1033f0fs17 Record 4: i ITALICi0 , ul UNDERLINEDulnone , BOLD0 , REGULAR
par }
THANKS!!
Export Landscape Data Report To Text File
I can display and print a data report in landscape mode, but cannot get the report written to a text file without receiving the dreaded "Report Width is Larger than the Paper Width" error.
I've tried: filename1.ExportReport rptKeyText, with and without setting the paper orientation to landscape for the printer, but I still get the above error message. Any other suggestions?
Ms Acess And VB6 Date Format
I get error when I try to insert a DTPicker value to MS access table
I use the following codes
"insert into data(date) values (#" & Format(dtp1.value, "mm/dd/yyyy") & "#)"
It gives an error
plz help
Crystal Report - Export Selected Page Range To Text File. Please Help.
Hi!
I'm using CR 8.5 & VB6.
I have a multiple pages (19 pages) crystal report previewed within my vb application.
Exporting this report to text file is quiet possible as far as i know but is it possible to export this report with the defined page range? Shall i say export page 10 to 19 only, is it possible?
Please help.
Or any suggestions please...
Thanks in advance!
Ms-Acess Report
hi
i've to create one report in ms-acess. there it requires to the grouping in run time. i think there is one function called CreateGroupLevel . But how to use this . ???
could u please explain this with clear example
thanxs in advance
rgds
sanju
|
TRACKER
