Search results for query: *

Object.TextBoxn.Text = Worksheets("Sheet1").Cells(1, 3).Value With this the formatting gets lost. These strings are formated with multiple fonts. I have to preserve the formatting.

I am trying to select the formated text in a cell in Excel and paste into a RichText Box. I have tried selecting the cell. Worksheets("Sheet1").Cells(1, 3).Select Worksheets("Sheet1").Cells(1, 3).Copy But then when I paste I get the frame around the text. I need to select...

Well since I have an app that paste these strings into word successfully I tried pasting it into word and then copying it and pasting into Excel. It works...it's ugly but it works. Still would like to know why it will not paste directly into Excel?????

I thought of that, but the greek symbols are not the only problem. Some parts need to be itallics, some bold. It gets to be a mess. It seems simpler to use the richtext. Plus there is a list of ~4000 of these to reformat would take days. I have an app that uses these strings to build Word...

I have a set of chemical names I need to store in my SQL database. The problem is a lot of them have a greek symbol in the name. ie...L-(greek alpha)-Glycerophosphorylcholine (cadmium chloride adduct) So I need to use one font for the greek symbol and one font for the rest of the name. I have...

Interpret the RichText string as Formated Text ie.. {\rtf1\ansi\ansicpg1252\deff0{\fonttbl{\f0\fnil\fcharset0 Times New Roman;}{\f1\fnil\fcharset2 Symbol;}}\uc1\pard\lang1033\f0\fs24 L-\f1 a\f0 -Glycerophosphorylcholine (cadmium chloride adduct)} as L-(greek alpha)-Glycerophosphorylcholine...

Yes Copying the formated string from Word(^C) to Excel(^V) manually works. I changed the code. I am now poulating a Rich Text Box with the Rich Text string from my db. I then Copy the string from the RTB to the clipboard and paste it to Excel When I Get/Put to the clipboard I am using Rich text...

No, ^V does not work with Excel but does with Word

Tried Application.CommandBars(1).Controls("Edit").Controls("Paste").Execute It still fails. It seems to be related to the way the data is written to the clipboard. After the app crashes I can open word and paste the formatted string. I can open Excel and it will not paste...

I am trying to paste Rich Text strings into Excel. I can copy to the clipboard and paste into Word just fine. I copy them to the clipboard with this Public Sub Paste(sRTF As String) 'sRTF represents the rich text formatted string to paste into Word RTB1.TextRTF = sRTF 'Copy the...

I have a db with Rich Text strings in it I need to paste into Excel. I can copy to the clipboard and paste into word just fine. Public Sub Paste(sRTF As String) 'sRTF represents the rich text formatted string to paste into Word RTB1.TextRTF = sRTF 'Copy the contents of the Rich Text to...

I am trying to run a query (ODBC) on a Paradox v3.5 Database from vb6. My query is SELECT * FROM TABLENAME where FIELD1 = '77417' FIELD1's data type is number in the Paradox table. I am getting an error "Data Type Mismatch in criteria expression" Is the format of my query wrong? Thanks!

I have a dos app that writes to a Paradox db (ver 3 or 4) Users input a greek alpha by typing alt + 224. When I open the db in Paradox 8 or 10 the alphas display as # symbols. When I display the alphas in a vb app the display as a lower case a. What the heck is going on here?? Any thoughts...

I have data in an old Paradox db (v3 or 4??)(text data type). When I pull data into a vb text box the ascii codes of the characters have changed. ex.. In the paradox db I have a greek alpha (ascii 224) When it is displayed in a text box it has been converter to ascii 97 (lower case a). Anybody...

This is ugly too, but it works. 1. Select the form in Project explorer 2. rename the form in the properties window 3. right click the form in project explorer and save as new name 4. change the name back to the original name in properties 5. right click the form in project explorer and save as...

I am trying to figure out a way to display product names that contain the greek letter alpha Look at http://www.avantilipids.com/ProductInfo.asp?prodnum=830072 For an example. in VB. I have data in an old Paradox database and in SQL Server that contain the character, but when I write the string...

I have got a Paradox table, probably version 3 or older, that I need to run SQL queries on via VB. What would be the best approach? I found a method to link the Paradox table to an Access DB, but this seems messy. Is there a way to run queries directly on the Paradox table? Thanks, db(cruzmsl)

I have got a Paradox table, probably version 3 or older, that I need to run SQL queries on via VB. What would be the best approach? I found a method to link the Paradox table to an Access DB, but this seems messy. Is there a way to run queries directly on the Paradox table? Thanks, db(cruzmsl)