Search results for query: *

Skip, I still don't get the rtf string that i need. Pasting this in word does not give me the rtf string. One way is saving this document as rtf and loading it to a rich text box and taking the textrtf property of the box but i am planning to manipulate 100,000 records and this route is too slow...

Skip, this is the code i have Sub Get_Cell_Data() Dim Temp1 Selection.Copy Temp1 = clipboard.GetText(vbcfrtf) MsgBox Temp1 End sub It says undefined constant to get the contents of the clipboard. How do I assign the rtf string to variable temp1 in my code. If...

I am trying to get the RTF String of data stored in a cell in EXCEL 2000. I need the rtf string because the data is formatted and it contains symbol fonts, subscripts, superscripts etc Is there a way to get the rich text string directly from the cell. I also tried to send this cell to clipboard...

Yeah sorry, I meant the strings are stored in MS SQL server. If anything can go wrong, it WILL.

I have rich text data stored in sql using the actual RTF strings. I want to edit this data in excel. How can i get this data using the string from SQL into an excel cell keeping the formatting intact? Once that is done, how can I get this string back to SQL, meaning how can I get the rtf...

Also wanted to know if there is any way to get these values in a table or excel format and not a report so I can play around with the data. Thanks If anything can go wrong, it WILL.

Thanks SWA, is there any way to get the unitcosts of the items at that time. we keep changing the unit costs and i wanted to know what the unitcost of the items were at that time. Thanks If anything can go wrong, it WILL.

We are into 2007 but I wanted to know what is that value and quantities of inventory i had on 12/31/06. Is there any simple way to do this in GP? I was thinking of taking current inventory and adding the sales and substracting the receiveing from start of year to come to this value. Pls advise...

What is the best way to convert a PDF file to excel. I have a report in PDF that I want to convert to Excel. Pls help and thanks for your time. If anything can go wrong, it WILL.

David, yes that was it. Awesome. Can you point me to which tables store these autofill values and does it affect all users or each user individually? Pls advise so I can manage these for other users too. Thanks If anything can go wrong, it WILL.

Recently i have noted that when i try to open the item maintenance window, it takes a long time to open up. We do have a lot of items ( almost 40K items ). Any window related to inventory takes long to open up. How can I speed this up? Pls advise thanks Hamza If anything can go wrong, it WILL.

I just purchased a machine with XP Media Centre on it. Media centre does not join a domain. There was a hack i found while searching on google but it doesn't work because I have SATA HDD drive and no floppy drive on the machine. I have WIN XP PRO software but i can't install that also because of...

RAC2, the query doesn't work, I don't think you have understood my questions. SQLSister, These tables are not created by me. They are already existing tables of an ERP software. There is no chance of changing the structure. The frequency won't be too often for this query but I need to run it...

I have a varchar field which contains locations like '45019A' etc. These are our bin numbers Some of these contain multiple locations like '40011A,45011A'. I want to search rows which contain a range of these using between '45277A' and '45288Z' This query works fine when data starts with...

It cannot be Adobe version specific as all my users are on Terminal server and have the same version of Adobe installed. Thanks anyway, Any other ideas? If anything can go wrong, it WILL.

Some of my users cannot open a pdf file attached in the ole. It says "failed to open server application" They do have a pdf reader and they can open PDF files thru their documents. What could be wrong? How do I correct this problem? any help would be appreciated, thanks If anything can go...

Thanks for your feedback. I got the general idea what is involved now. If anything can go wrong, it WILL.

We have 3 yrs history in GP. We want to remove the history but have access to it later on when required. What is the best way to archive data in GP for easy reference in the future when rrquired. Pls advise. Thanks.