Search results for query: *

What I'm trying to do is to have flexible decimal places, so to speak. I want excel to show however many decimal places I type in (or none), but that it always has comma separators. Thanks.

Hi all, Is it possible to format cells in Excel to have comma separators for numbers but not have to specify the number of decimal places? Thank you.

The query is kind of long, but it looks like: SELECT DISTINCT AGENCY_ID, PROGRAM_ID, ACTIVITY_ID, ... DESCRIPTION FROM AGENCY, PROGRAM, ACTIVITY, ... WHERE ... I used DISTINCT to get unique values. The text value in the DESCRIPTION field es truncated. Without DISTINCT the query returns 3...

Hi, I am using Access 2003 and one of my queries returns truncated text -- truncated from the front. I use DISTINCT in my query. When I remove DISTINCT the texts look fine. Has anyone seen this problem before? Thank you!

Hi, I am using MS Access 2003. Is it possible to format a text field to make some characters superscript or subscript? Thank you.

We are in the process of getting Office 2002. Thanks for your input!

Hi, I protected a worksheet and unlock some cells for editing. When I do that I cannot sort or use data filtering of the worksheet. Is there any way around this? Thanks.

Hi, Does anybody know what this error mean? An incorrect structure was found in the pdf file. It happens when I try to delete or replace a page. Thank you

Hi, Is it possible to configure MS Outlook to read my ____@msn.com emails? Right now I use MSN Explorer, but would prefer Outlook. Thanks.

Thanks for your replies. I used Word Art and selected the desired rotation. I am curious as to how to invert regular text.

Hi, Is there a way to invert text in Word, i.e. turn it upside down? Thank you

Hi, I share a folder, which contains two files, on my computer with a few people in my company. Is there a way to have Windows send me a message when one of these two files is modified? Thanks.

Correction on my post. The datatype is CLOB, NOT BLOB. Sorry.

Thank you for your input! I will try them.

Hi, Is there a way to convert a table column from BLOB to VARCHAR2 while keeping the data? I inherit a database, and of the tables has four columns of type BLOB, but the data in them is just text. I want to turn those BLOB columns into VARCHAR2 but preserving the data. Thank you.

Hi, I have an Access 97 database that I want to share with others on my network. Is it possible to share it so that other users can only open one object, a form in this case, and nothing else? Any ideas appreciated. Thank you!

This site is excellent. Thank you!

Thanks for all your replies. Pushing "memo" to CLOB works!

Hi, I have a question on how to get data from a "memo" field in Access 97 to Oracle 8.1.6. I created the Oracle database, make an ODBC link to that database from Access 97, and copied the data over by: insert into oracle_table1 select * from access97_table1 and get the error...

Thank you very much! The utility works.