Question about Paste Special
Hi, I have a problem sometimes with the paste special options when goin
from one excel workbook to another. For example, sometimes when I cop
data from one workbook and then paste special into another, I get th
options that include: All, formulas, values, formats, has the option t
transpose the data and paste link among other options. And the
sometimes I try and paste data to another workbook and I end up th
paste special options: Bitmap Image Object, picture, bitmap, and I als
lose the ability to paste link. Well you can do it, but it puts it i
as an object.
What I want is the first past...IE8 privacy question
I am running XP-Pro SP3 and considering upgrading from IE7 to IE8.
I have read all the feature and benefit articles from MS, but have one
question that remains unanswered.
In IE8 there is mention of being able to restore previously viewed websites
or something to that effect. I think this is on a drop down menu somewhere.
1) Does In-private viewing prevent this?
2) Does manually deleting your complete browsing history clear this?
3) Is there a registry entry that can prevent this action?
4) Is there a group policy change that can prevent this action?
In essence for privacy pur...IF AND question
I need a function that can provide one of three answers:
1 2 1 1...
3 3 4 4...
? ? ? ?...
If A1 = 1 and A2=3, answer 106; but if A1=1 and A2 = 4, answer 104; but if
A1=2, regardless of A2, answer 95.
The next function for column B is the same, except the answer is dependent
on the value delivered from the column A function. E.g. A3 + 6 or A3 +4 or
Any help would be most appreciated.
Use the below formula for your first query.
...Microsoft Query question
I am trying to use Microsoft Query to get data from my SQL 2000 databases.
The problem is that I have a few columns with names that conflict with
keywords (like Identity). (Yes. I kow that keywords should be avoided but it
is done and cannot be changed.) This is causing a keyword syntax error
within the Query application.
Oddly enough, even if I do not select the column the error still appears.
And when you look at all the columns available, the keyword named column
shows up in boldface.
When I am doing queries in other programs I put square ("[ ]") brackets
around column and table...Question
Why did the chicken cross the road?
Dr. Stephen Hopkins, MD
"Dr. Stephen Hopkins, MD" <DrStephenHopkinsMD@discussions.microsoft.com>
wrote in message news:B8434E21-DDA3-44D7-B39B-CD5A8C33A7BD@microsoft.com...
> Why did the chicken cross the road?
> Dr. Stephen Hopkins, MD
To collect her email, why else?
You should be ashamed to put such a title on an idiotic off topic post !!
MS-MVP. MAIL. [DTS] UK.
> "Dr. Stephen Hopkins, MD" <DrSte...OWA Question #16
Quick Question regarding OWA. We are about to finalize migration from 5.5 to
2003. We have an existing web presence already in DNS a www.mydomain.com.
and running on existing web servers. With 5.5 natrually, to access OWA, it
This will not be possible now since OWA runs off of the Exchange server
instead of relying on our web server under 5.5. What's the easiest way to
If you can afford the extra license, you'll probably want to run a front-end
server so no one is connecting directly to the Exchange database s...Text Box Question
I have been using Visio for years, however, something has happened and I
can't figure out how to undo it. Basically up until today when I added a
text box and entered text, the text went horizontal as it was typed. Today
when I add a text box and enter text, the text goes vertical. How do I get
back to the old behavior?
using text container shape adjusting tool (text block tool), make the text
container shape wider horizontally.
Have you used Asian text font recently?...check help for "vertical text"
"Ray Batig" wrote:
I just started a 401K at work and I'm wondering how to deal with it in Money.
I've got my paycheck split into different categories currently and now I
have to put the 401K amount into a category as well. I didn't see one
specifically for this. What do other people use?
Should I start using the 401K Manager? I haven't gone through it yet I'm
just wondering if it works well and how much benefit I'll get from it.
Thanks in advance!
You will want to create an investment account for the 401(k) and TRANSFER
your contributions from your checking account to the...VBA//Oracle Interfacing Question
I have been able to correct to my database but I have one question
Within objSession I want to list all available tables and all
How exactly is this done?
Set objSession = CreateObject("OracleInProcServer.XOraSession")
Set objDatabase = objSession.OpenDatabase("", "User/Pass", 0)
On Nov 16, 12:05=A0pm, jason <jason.mell...@gmail.com> wrote:
> I have been able to correct to my database but I have one question
> Within objSession I want to list all avail...Newbie to Outlook
I finally made the jump to Outlook (Outlook 2002 from Office XP in this
case) from Outlook Express and I have some questions, please.
1) Where do I make a setting so that I will automatically start a download
of my mail when Outlook starts? Currently I a) can wait the 5 miuntes for
the next send/receive to happen or 2) I can initiate it manually when I
2) I have 2 phyical hard drives on my system. I want to move my entire
Outlook profile to a folder on my second HDD.
3) Can I have multiple identities/profiles with Outlook, to keep my personal
mail, contacts, and calendar s...IIF function question
I have this function in my query: URG_IN:
IIf([MCAUTH_URG_IN]"",N,[MCAUTH_URG_IN]). The MCAUTH_URG_IN field can be
many letters of the alphabet, but if it is blank I want it to be an "N". Can
someone tell me what is wrong with this query?
You omitted the equal sign and quotes around the 'N'.
Build a little - Test a little
> I have this function in my query: URG_IN:
> IIf([MCAUTH_URG_IN]"",N,[MCAUTH_URG_IN]). The MCAU...ostream question, help please!!!
Can anyone tell how to reset an ostream object? I used .flush() but it
what i want is "s2" but not "s1s2", how to solve it ?
Any help will be appreciated!
by the way, can't create a new ostream object due to the special
requirement, and ostream is the type i have to use.
thanks in advance!
> Can anyone tell how to reset an ostream object? I used .flush() but it
> doesn't work.
> e.g...VLOOKUP Question/problem
I am trying to use VLOOKUP to populate a cell in an invoice.
It looks to a second page with the prices, and they are designated by a #
then a letter, like 1A, 1B, 2A, 2B in column B. Column C is a description,
then the values I want returned are in column D.
My formula is =VLOOKUP(B11,Prices!B4:D82,3) where I enter say 1A into B11
then it should find 1A in the range and return the value from the 3rd column
in the same row as the value 1A.
Problem is, it works on some and brings up the wrong value on others. I am
just trying to get cell B11 to work properly. Why would it bring up the
I am not sure if this should go in here or the VBA group but I have 2
I am using Powerpoint 2007
Is there a way in VBA to delete all the footer and date placeholders
in the slide master og my prsentation. I do not use them and I have a
lot of slide master slide in the presentation
Also is there a way in VBA to format all pictures in my presentation
so that they use the "soft edge rectangle" format and the "rounded
Rectangle" picture shape. I have a full day presentation so it is a
lot of pictures to change
Code here should help
I'm implanting a graph control in my program, if ill use ms graph/chart
control will it have any legal issues connected to it? any problems in
selling? distributing and etc.?
It depends upon the company selling graph/chart control. You will need to
contact them. Typically its all spelled out in the license agreement that
you got when you purchased the control.
Ajay Kalra [MVP - VC++]
"fima" <firstname.lastname@example.org> wrote in message
> I'm implanting a graph control in my program,...very general mail question
Hi, I just tried to send an e-mail after copying and pasting the e-mail
address from a Contact (from Outlook 2007, Vista Home Premium, SP1). The
message could not be sent. There were no error messages and I had no idea
why this message could not be sent.
For some reason the address was enclosed with single apostrophes .....
I tried copying the same e-mail address again and this time those
apostrophes did not appear and the message was in fact sent.
As a test I tried sending my self a message by enclosing my own valid e-mail
address with enclosed with si...Requey Question?
On my Switchboard [frmMain] I have a Combobox [cmbTaxWarning] it shows
clients through a query which Clients have not been taxed
My problem is when I go to my Clients form and change him to No Tax then go
back to frmMain my combo box dose not show the change unless I close the DB
and open it............Any Help Please.....Bob
"Bob V" <email@example.com> wrote in message
> On my Switchboard [frmMain] I have a Combobox [cmbTaxWarning] it shows
> clients through a query which Clients have not been taxed
> My probl...Question about antivirus for Exchange 2003
I currently use Mcafee groupshield for exchange 5.5 and while it does
block infected attachments, it still sends the email message to the
user which generates alot of complaints. I am ugrading to Exchange
2003 and this time I want to get something that is a little more
flexible and can block not only the attachment, but the message too.
I will look into the latest Mcafee solution, but wanted to hear about
the experiences of others on this NG.
I'm using McAfee GroupShield for Exchange 2003. For your
information, the software still behave exactly as you
mentioned in...MDI, beginner questions
Im trying to find the best way for me to implement multiple mdi child
windows with dialog layout.
My application will need several dialog windows with different layout
(sort of like photoshops toolbar windows). All windows will only occur
once so there is no need for any new/open/save functionality. I only
need MDI to keep all windows organized.
Could someone please help me with a simple code example? I've read a
bunch of usenet posts, but I still can't figure out a suitable
approach for my type of app.
> Im trying to find the best way for me to implement ...IMageView Question
How to display this in a MFC SDI app environment?.
Sent by techquest from fastmail in field fm
This is a spam protected message. Please answer with reference header.
Posted via http://www.usenet-replayer.com
there is a function CreateBitmap
of class CBitmap
that should do the trick
but you will need additional info
other than a byte pointer
firstname.lastname@example.org (email@example.com) wrote in message news:<firstname.lastname@example.org>...
> BYTE* ImgBuf;
> How to display this i...SetTimer() question
I'm using the timer function 'SetTimer()' and 'KillTimer()' function to
start and stop the animation. The problem is, the animation pauses during
the call to the Sleep() function or call to a function that takes a long
time to complete processing. What can I do so that the animation does not
Put the long process in a seperate thread. Or Pump messages in between your
You can also change your sleep to do something like this
void CMyApp::Wait(DWORD HowLong)
DWORD Start = GetTickCount();
while (Start + HowLong > GetTickC...peltiertech question
I'm attempting to create colored vertical bands on a chart using directions
I can't get multiple bands (the last step at bottom of the webpage). I end
up getting what looks like steps- I can't get them to extend the whole length
of the graph. Any ideas?
What's the data look like? How are the steps oriented?
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
> I'...Calendar Archive Questions
I have more than 10 years of data in my Outlook calendar which makes it
very large. I sneakerware the whole calendar from office to home on a
regular basis so that both are up to date.
I would like to archive, say five years, on a one time basis so that I
didn't have to carry that portion but could access it at any time from
either computer. I would just carry the more recent data.
Could someone explain how do to a "one time" archive of a calendar. I am
somewhat confused by the information in the help file and don't want to lose
Is it possible to create Internet Account Files (IAF)
automaticly, based on an SQL database for example? So you
don't have to setup the accounts manually?
The question came up when I, owner of a hostingcompany,
had problems with a client that wasn't capable to set up
...M07 Budget Question
Does M07 still use annual percentages to calculate spending and income for
each month, or have they changed it so that it shows true income and expense
for the month in question?