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...edit paycheck in M2000 cannot enter transfers?
In Money 2000 Deluxe, I am trying to edit an existing paycheck in the Setup
Bills and Deposits section to include a transfer to a 401k account. The 401k
account exists in the account list. However when I try to edit the split
details, it won't let me enter any transfer categories. The category
dropdown list contains regular categories and special category containing
Credit card payments. The transfer categories are not visible. If I try to
manually enter the transfer using "Transfer To : Account Name" it does not
Is this a known bug in Money 2000? Anybody else seeing...Adding a long integer question
Hey guys -
Just a quick question here about adding very large integers together.
I'm trying to add say: 148991+ 76561197960265728 - within a vbscript
routine and my result is: 7.65611979604147E+16. Is there anyway to get
that to print out the full solution rather than the shortened version?
Thank you very much in advance.
btw I shouldn't have said shortened version (sounds ignorant). What I
meant was is it possible to show it out of scientific notation.
I don't know whether this will help, but
it may be of interest: When I try...
CDec(148991 +...A2K format
Have a form which after the user has completed all data input can invoice
I have a command button:
Private Sub InvoiceBtn_Click()
Dim InvoiceResp As Integer
InvoiceResp = MsgBox("Are you sure you want to mark this record for
Invoicing ?????", vbYesNo)
If InvoiceResp = vbYes Then
Me.Invoice = 1
Me.WeekNo = Me.DateDel
What I would like to have happen is that before it updates Me.Invoice, it
checks that the [PackStatus]=6 (6=Pack is Delivered).
So if the criteria doesn't match then di...Question Re: Slide Numbers
I created a template but a slide number doesn’t always get inserted when I
add slides. It’s there when I look at the Slide Master, so I'm wondering
what I've done incorrectly. Thanks in advance.
On the slide, if you insert (or draw) an object that is "above" the slide
number place, you won't see the slide number
"Kathy" <firstname.lastname@example.org> a �crit dans le message de news:
>I created a template but a slide number doesn't always get inserted when I
> add slides. It's there when ...Question #4
Recently a person wrote to me with a problem, this was the problem:-
He had a doc-view application based on CFormView and had a button on the
view, clicking which the frame needs to get hidden and the what needs to
remain on the screen is the client area, which is the View.Also the
view-area shouldn't increase/decrease in width/height when the button click
operation takes place. I wrote out a piece of code and sent it over to him.
But since this was a bit unusual , I wanted to know the opinions of guys
here on solving this problem.
I will post the answer which I gave later, if mine ...Macro security question
I just moved from W98 to XP Pro. I brought along my spreadsheets with macros
I wrote. When I open the workbooks in Microsoft Office Excel 2003 running
under XP Pro, I get a message that the macros are disabled and some guidance
on how to lower the security from Very high to High and then ..... Well I
followed the guidanc and found that my security was already set at High and
then the rest of the guidance didn'ty work. I tried help but couldn't find
anything that makes sense. Can some one tell me how to tell the software
that my macros are ok?
Ray, lower it to medium...Compacting Design Question
I am using the following code in the on close event of my form:
CommandBars("Menu Bar"). _
Controls("Database utilities"). _
Controls("Compact and repair database..."). _
I have heard that you should use the compacting event from a command button.
Can someone give me the reasons that you should only do this on command
rather than every time the form closes? Thanks for your feedback.
Why would you want to compact that frequently?
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele...AOL and Microsoft on an exchange question
I hope someone might know the answer to this problem. I have a customer who
uses AOL. I use Outlook 2007 and am on an exchange server. My customer has a
problem when he forwards me an email from anyone outside of my office. The
original email comes to me in the form of an attachment, even tho there were
no attachments used. For example, A sends an email to my customer. That email
has no attachments. My customer forwards me the email. When I receive the
email A's email to my customer is in the form of an attachment. It looks like
an envelope. Can we make the forward come to ...Date on X-axis question
I have Dates on the X-axis of a chart. I would like the markers or ticks to
be the actually dates. But the way it is now it has the major unit as 7 so
it is showing every tick every 7 days. But if the data skips a couple weeks
I would not like it to show the ticks inbetween. So I just want the dates
on the x-axis
Does this make sense?
Any ideas of how to fix this?
Excel has detected a time series; you want to tell it to treat dates as
simple category values.
1)Right click chart; use Chart Option form popup menu
2)Open the Axis tab; under X-axis, click the Category option box (e...Two questions for MS Money Plus, Please help
1). I have read the statement, said the support for MS money only available
in United States and Japan. I am living in Australia, does that mean MS
Money Plus is not supported for Australia, or simply just do not have money
support center in Australia?
2). I am using MS Money 2007 Home & Business editiion, can I just upgrade
it to MS Money Plus 2008 Delux edition? That means from higher edtion of
older version to lower edition of newer version.
Thanks in advance.
Money is very heavily localised to take account of the fiscal rules in the
regions where it is sold. So a U...tricky send question
I didn't get any responses when I first posted this so I'm
trying again, Help, please!!
I've got a problem that I just can't solve. I'm using
WinXP, Outlook XP (2002), Zonealarm, and McAfee. I've
already scanned (and rescanned) the whole pc for MyDoom,
it's clean. Here is what is happening...
I have an e-mail which is incoming only (pop3, no smtp), so
outgoing goes nowhere. Everytime I send/receive, even
though my outbox is empty, there is an attempted send from
my e-mail. This, of course, fails, and there is no history
of it anywhere, not in the outb...Newbe question about licensing
Hi, I am a complete MS exchange newbe so i apologize in advance. I
want to install some version of exchange for a small office with about
10 people without breaking the bank. They all have outlook on their
work stations and will need email accounts for all. I am considering
purchasing "Microsoft Exchange Server 5.5 Standard Full Version" and I
am wondering if this will permit all users to have mail boxes. The
business is currently using an outdated postoffice program with no
support so I would like to get a little closer to the 21st century and
have more flexibility. Do I need a...Date/Time Question
I have a start date and time which is inputed to a form in the format of
I also have a total time which is in decimal hours. Like 25.61.
How would I create an expression in a query to take the start date/time, add
the total time to it, and get the result in the date/time format.
If possible I would also like to exclude the hours between midnight and 5 AM.
Thanks in advance,
You are, to some extent, mixing apples and oranges -- both of your items are
somewhat related to dates, but not related directly to each other.
If you have a Date/Time value...Graphing Question
I'm trying to graph a 2005 company trend showing dollars and numbers.
The dollar amount is in the millions and the number amount is in th
low 100's. How can I graph both lines on the same chart? When I tr
to graph them as separate series the number trend basiclly lies on to
of the x axis. I'd like to be able to see both of them on the sam
petevang's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2503
View this thread: http://www.excelforum.com/showthread.php?th...M2000 to M2005
I've been using M2000 (Canadian edition) for the last 6 years and have been
happy with the features. Base currency set to USD.
I have now purchased (in the UK) a new laptop (Win XP SP2) which came
bundled with Money 2005. When attempting to convert the M2000 file xx.mny,
M2005 states that conversion is not possible because of a version
incompatibility. I guess this is a problem with Canada vs. UK (or Europe? -
the currency in M2005 appears as euro: perhaps because my regional settings
currency is euro.
Any suggestions on how to force a conversion (including all settings -
How do you subtract, example: A2:G2
> How do you subtract, example: A2:G2
To subtract A2 from G2 enter the formula =G2-A2 into a cell
I don't want to subtract just G2 from A2. I'd like to subtract A2 thru G2
> "Richard" wrote:
> > How do you subtract, example: A2:G2
> To subtract A2 from G2 enter the formula =G2-A2 into a cell
How about this:
(remove nothere from the email address if mailing direct)