Excel 2008 color issues
Operating System: Mac OS X 10.5 (Leopard)
Recently, when opening existing excel files saved to my computer, the colors change - usually making the background black and the font white. I am not sure if is because I had updates recently. Why is this happening? and how do I fix it?
...Win98 SE, Office 2000: ODBC from Excel behaves strangely on one computer
When I create an ODBC query from another Excel workbook, using query wizard,
then usually after I select the workbook as data source, in wizard's next
window all available tables (defined non-dynamic named ranges in this
workbook) are displayed, ans I'm asked to select columns. The source
workbook remains closed.
Now in one single computer, after I select the workbook as data source, this
workbook is opened and recalculated automatically, and only after that the
wizard continues with next window. And when I open some workbook, containing
such ODBC query, or when I try to refresh s...Filtering issues
I have an excel sheet full used as a mailing list. The
list is over 8,000 records. I need to filter the
duplicates out, problem being that they came from 8
different XLS tables, which were all formatted
differently, so even duplicate records usually differ
slightly. How can I select two columns as criteria for
filtering the whole list?
A two step approach should work.
Move the two columns so that they are next to one another.
Then Data|Filter|Advanced Filter
Under Action select Copy to Another Location
Set the two columns as the List Range
Leave Criteria Blan...Odbc #2
I have created a spreadsheet to extract data from Sage accounts usin
ODBC. My accounts package is multi-company so there is a separate dat
source for each company. These data sources contain exactly the sam
fields but different data.
I would like to use the same spreadsheet with a new data source
probably by making a copy of it and somehow pointing the existing quer
to one of the other data sources. Can this be done or do I just hav
to start again
Message posted from http://www.ExcelForum.com
...Exchange Domain issue
I have a domain in windows 2003 named "abc.com" which has a AD and DNS
itself inside my company,all the users are logging to this domain,but
my email and wesite is as "xyz.com" which is outside our network.Now we
are planning to install a new server with exhange 2003 inside our
network,can anybody tell what is the best way to install exchange.
I planned to install the exchange as member server of the domain
abc.com as mail.abc.com but when i told my ISP to route the mx record
to my mail server inside the company ,they told that our server
configuration is not correct. ...Color printing issues
Operating System: Mac OS X 10.4 (Tiger)
Processor: Power PC
I have an unusual printing issue with Word (and Excel for that matter). Graphics and colored text print out very faded or with incorrect colors. <br><br>When I print the very same graphics from Photoshop, they print fine. Which suggests to me that the printer is NOT the issue. The printer has new cartridges, all drivers are current, and it has been cleaned. <br><br>I have the same issue printing on a Windows machine. <br><br>I am using RGB colors. <br><br>Any ideas?...odbc
instead of converting from excel to access, and cut and
paste. Is it possible to make an ODBC connection to an
ACCESS database that has many calculations
Um, doesn't it depend on how the calculations are done? If there are queries
that include user-defined functions, you're not going to be able to use them
Doug Steele, Microsoft Access MVP
"david epsom dot com dot au" <david@epsomdotcomdotau> wrote in message
> "Daina" <firstname.lastname@example.org> wrote in...Issue with Money 2004
In Reports Gallery under Investments, the Investment
Performance and the Investment Accounts option do not
calculate the total buys and income for the the correct
date ranges. The All to Date selection and the Date for
current year give the same grand total. I feel that if
someone were looking at a report for a specific year with
a specific date range the figures should reflect there
In microsoft.public.money, <email@example.com> wrote:
>In Reports Gallery under Investments, the Investment
>Performance and the Investment Accounts option do not
>calculate the t...eConnect Issue
I am using eConnect to do Bank Transaction Receipt but it's giving me an
error message, which is "Connot insert the NULL into colum PERIODID, table
TWO.dbo.GL10000; column does not allow NULL". Therefore, I change PERIODID
to allow NULL and it creates transaction without any error. However, I am
not sure this is correct way or not? because from Microsoft GP database
design, it set PERIODID to "Not Allow NULL".
Anyone knows how to resolve, please let me know.
If the field is set to not allow NULL then you should provide a value for
tha...Outlook 07 Printing Issues
Ever since we upgraded to IE8 a few of the clients have been having issues printing full emails on one page.
Example: one email has a paragraph, and below it is a table that continues further to the right than the text does. When you print the document, it cuts off everything to the right of where the (paragraph) text ends. half of the table is missing.
Also, the whole document is sized down and only takes up about 1/4 of the page, and is shifted to the top left hand corner of the paper.
How do I change settings to allow outlook to auto-resize to fit everything on one page, and act...compaq NC3120 fast ethernet NIC lan card driver issue in windows 7
Hello, My name is Nasir...And I like to ask for compaq NC3120 fast ethernet
NIC driver for windows 7... And is it compatible with windows 7.
Thanks & Regards
On Nov 23, 6:25=A0pm, Nasir <Nasir @discussions.microsoft.com> wrote:
> Hello, My name is Nasir...And I like to ask for compaq NC3120 fast ethern=
> NIC driver for windows 7... And is it compatible with windows 7.
> Thanks & Regards
> Nasir Mahmood.
This is a Windows Server "grade" network adapter. To look for
official driver, look on www.hp.com.
However, s...Database Issue
I have a machine which was working fine. We have an excel spreadsheet which
is linked to an access database. The machine is running windows 2000 with
all the patches and office 2000 with all the patches.
When they open the spreadsheet they recieve the following error:
[Microsoft][ODBC Microsoft Access Driver] Unknown. They also have problems
with Autocad 2005 opening point database files, I believe it is from the
same problem. Autocad 2000 works fine. In autoacd the error is: Error
creating point group database. This error occurs when they try to open or
create a project in autocad 200...email issue using OL 2003
I have office 2003 installed.
I use OL 2003 as my email program.
I use Word 2003 as the email editor.
When I reply to someone's email the original is quoted as per the set up
under email options.
The issue is that when I reply an email sent from a MAC or Apple PC, the
original message is not included unless I uncheck to use Word as the email
editor in the email options.
Any suggestions are appreciated.
The default format in Outlook is Rich Text. Only other Outlook users can
read Rich Text. If that's the format you're using, try switching to HTML...Scanning/keyboard issue
Hi! A few days ago my scanning issues started .At first I thought it was the
keyboard that was dying so I switched and it still froze, ie the keyboard
rendered useless but RMS was up. So then I though it was the keyboard port
that was dying so I bought a PS/2 to USB splitter but the issues continue.
This has rendered my main register useless. Of course I am remote right now
and am able to stay in business by using the second register. Now, does this
sound like a PC issue or is the Metrologic scanner having issues? I guess
that I will find out when I put the second register's scanner...odbc
I've got a problem with inserting image to database.
I've got a CByteArray m_pic and CFile file:
file.Open(filePath, CFile::modeRead | CFile::shareDenyNone);
How can I send it to database now?
If I want to update record in database i usually do it like that:
SQL.Format("update TABLE set FIELD='%s' where id=%u", newFieldValue,
if(!DB.DBConnect()) return -1;
...Lost Connection to Public Folders
I think I just shot my self in the foot and set the "Everyone" usr
permissions to DENY on my Public Folders. Now I cannot view my Public
Folders Tree within the Exchange System Manager. Is there any way I can
reverse this so that I can view my public folders again.
Pls run Forestprep and Domainprep in your exchange server again!If you are
Windows 2000 DC Domain it will reset Exchange permission!
Or you can using ADSI , find the public folder object and reset the
Currently can't find a more specific place to post this message, so...
I'm trying to troubleshoot an ODBC error and I haven't worked with this in a
very long time.
We have several Windows 7 64 bit PCs that generate errors when trying to
configure User DSNs. When I highlight any of them (I.e. MS Access Database)
then click Configure I get the following two errors (and I'll use MS Access
in this case):
"The setup routines for the Microsoft Access Driver (*.mdb, *.accdb) ODBC
driver could not be found. Please install the driver."
I click OK then:
...Moving from 5.5 to 2003 - only 2 mailboxes with issues
I am wondering if someone can help me on this issue. We are in the
process of moving around 2000 mailboxes from mutlipule Exchange 5.5
Sites to a single Exchange 2003 site. At present we have moved around
800 without any problems.
But here is the problem, we have 2 mailboxes that error when moving
with the following error:
<summary isWarning="false" errorCode="0xc1031741">Cannot complete the
operation because the object 'MODglobalaccounts' does not have the
attribute 'msExchMailboxGuid' set or because you do not have
permissions to read i...Appointment Issues
When we schedule an appointment in CRM, we get an error message: General
failure in scheduling engine. However, we can still save it as an appointment
after clicking 'Ignore and Save'. What's up with this error message? Also, it
takes a few minutes to sync with Outlook. Thoughts?
Sounds like installation issues. Have you searched the Service Packs? Have
you called support on this one? It might be worth the one time $245
Anne Stanton, MVP-CRM, MBA/ACC
President, The Norwich Group
"circulent" <firstname.lastname@example.org...ODBC Pass-Through Queries
Is there a way to pass parameters to a server via ODBC Pass-Through queries
Doing a "select * from ThisTable" on a certain table in Oracle 10g at work
(or linking to it via Access) produces errors when viewing the table. Namely
the error in question is "Insufficient parallel query slaves available".
This can be easily fixed in a native Oracle session by issuing the following
ALTER SESSION SET PARALLEL_MIN_PERCENT=0;
SELECT * FROM ThisTable;
This changes the session so that if there aren't enough parallel query
slaves available to...Prompt receiving clerk to issue shortages when they come in
Please add a prompt after receiving items in on a purchase order to issue
shortages to MO's.
Maybe a new window you can open after all receiving is done for the day that
will pop up and show you all MO's that have short parts that have come in
that day, and let you pick which ones you want to issue to.
Microsoft responds to the suggestions with the most votes. Click the "I
Agree" button to vote to have this fixed, THANKS!
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote ...Footer issue...
I'm using Word 2007. The margins of my template are 1". I think that's
plenty of room to insert a footer but the text in the footer is super small.
The curser is super small too. I think it's in the size 3 font. I've
adjusted the font size. Deleted the form controls but nothing. When I print
the document, everything shows up just fine. How can I fix it so I can see
what I'm typing in the footer on the monitor?
Thanks for the help!
Modify the size of the font in the Footer Style
Hope this helps.
Please reply to the newsgroup unless you w...Powerpoint chart issue
I am trying to create a stacked in 3D column chart that displays 2 sales
numbers. I want the bottom axis of my chart to list the regions and the side
axis to list the dollar amounts.
There are 4 regions in total and each region is comparing 2008 to 2009.
My issue is that I want each region to show 2 stacked columns (08 vs 09),
then I want to see a space and then the next region is listed...and so forth.
I can't seem to figure out how to get this stacked column to work. Any
how to c...Another issue in my MFC app
I am trying to execute another program with variable parameters within my
I cannot see any way of using CreateProcess with variable parameters.
Is it possible.
prog.exe -f=test1.dat c:\tmp\test2.bin
Execute prog.exe with -f=test1.dat as 1 param and c:\tmp\test2.bin as param
But the test1.dat might be test2.dat or anything.dat and c:\tmp\test2.bin
might be different also.
How do I run CreateProcess with variable parameters.
Sorry if I am getting annoying with my questions ;)
I am trying to do things the right way.
> I am trying to execute ano...Paste issue with Excel 2008
Operating System: Mac OS X 10.6 (Snow Leopard)
I have used Office 2007 (on my PC) & iNumbers (on my iMac) to do the following - copy large amount of data and paste them into Excel with no problem. The data paste into columns so I can used the information as a worksheet. These are daily credit card transactions data I get from a secured website. <br><br>When I do the same operation for Excel 2008 all the data paste in a single column. What am I not doing correctly. <br><br>Thanks in advance for your help.
Have you tried us...