I have a query where the execution plan is showing a table scan with 32%
I have tried to put indexes on pretty much all the fields and still get the
The predicate from the Query Analysers execution plan for this table is:
([@NameChoice] IS NULL OR CASE WHEN
([dbo].[REVIEWER].[LastName]+', ')+[dbo].[REVIEWER].[FirstName] ELSE
CASE WHEN isnull([dbo].[REVIEWER].[FirstName],'')=''
THEN [dbo].[REVIEWER].[LastName] ...Registers Question
Yes, I did the whole tutorial, but some BASICS where never explained in it.
Aside: Did you know that after mentioning Z and ZZ Report thousands of
times, they finally get around to telling you what the hell that is in like
lesson 7 of 10??? What a joke and waste of money. They were just reading
Page-for-page the help file.
In SO Manager/Registers
Maybe I am not understanding this right. I have been PLAYING with one
computer install (besides the MSDE on the server where the database is). I
set up register 1000 at my computer since it will be data entry only.
I set the receipt pr...Microsoft.Crm.ObjectModel.MultiCurrencyPlugin + The given key was
I am working with MS CRM 4.0. I have made a custom entity which is having
some money fields. Everything was working fine. Suddenly while saving the
entity below message coming from applicaton:
"The given key was not present in the dictionary"
If i click ok then entity is not saving. I go to application server event
viewer log and saw below error details. Do any body face this issue, please
let me know, it is getting me too much trouble. I know it is related with
money field. I have to use money field in my entity. I have added some also.
Web Service Plug-in failed in Organiz...OOF question
By default, exchange send out of office message only once to anyone who
sends an email to a user who has set his OOF. Can this behaviour be changed
so that exchange sends email everytime when it gets a message for someone
who has sets his OOF?
Nope. With an Outlook rule, you could do it, though that would be a
bad idea as it could make you vulernable to a mail loop.
On Sat, 28 Aug 2004 13:37:00 +0400, "Imulet" <firstname.lastname@example.org>
>By default, exchange send out of office message only once to anyone who
>sends an email to a user who has set hi...convert DVD to play on Microsoft iPhone Video player
[quote][/quote]Many friends ask me how to convert DVD to play on Microsoft iPhone Video player. I always recommend them Cucusoft DVD to iPhone Converter. It backup convert almost any type of DVD to play on Microsoft iPhone Video player. Moreover ,It?s a powerful DVD to iPhone converter with very fast conversion speed. The output also supports full screen viewing.I think it is very useful and easy to use too.So , I recommend this useful software to convert DVD to play on Microsoft iPhone Video player. Hope it can help you.I download it here: http://www.92download.com/wiki/Cucusoft_DVD...microsoft
...Is Microsoft Visual studio 2005 upgraded version of Microsoft VC++ 6?
I'm in a confusion that some of my apps.exe wont work with VC++6 but
they do work on VS2005.
Is Microsoft Visual studio 2005 upgraded version of Microsoft VC++ 6?
So to install VS2005, prior to that do i need to uninstall VC++6??
ARe there much changes in .dll of VC++6 & VS2005?
> I'm in a confusion that some of my apps.exe wont work with VC++6 but
> they do work on VS2005.
> Is Microsoft Visual studio 2005 upgraded version of Microsoft VC++ 6?
> So to install VS2005, prior to that do i need to uninstall VC++6??
> AR...Microsoft Outlook to Microsoft Entourage
I just got my Mac and started using Entourage (by Microsoft) and cannot seem
to find how to get my PST to Entourage. There is support for Microsoft
Outlook Express but not Outlook...
Maybe export to OE first?
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide)
Author, Google and Other Search Engines (Visual QuickStart Guide)
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com
Join OneNote Ti...Need Query Help
I am new to Access. I built a query which gives me purchase orders and
payments on those purchase orders. However, the query dpes not give me
purchase orders with no payments. I need both: (1) purchase orders with
payments and (2) and purchase orders without payments. How do I go about
adjusting my query to include both?
In your query, select the line that joins your two tables and right-click.
That should bring up a context menu with a choice for Join Properties.
Select that, then select the option that will include ALL records from the
purchase order table ...Microsoft Promo
It says on the microsoft website that "Super Suite Deal. Buy Office
2004 and get Office 2008 Special Media Edition for FREE". I accessed
it before and it said that even if you buy a student and teacher
edition now, you get an Office 2008 Special Media Edition for free.
But then I clicked on this link from apple:
and it says that when you purchase an office 2004 mac student and
teacher edition you JUST get a office 2008 for Mac Home and Student
What's happening there?
Plus, on the mactopia website, the supe...Microsoft XML Core Services 4.0 Service Pack 2 (KB973688)
I have windows XP and this update fails to install tried it various
times..Can anyone help.
Microsoft XML Core Services 4.0 Service Pack 2 (KB973688)
Security updates for Microsoft XML Core Services 4.0 Service Pack 2 may
repeatedly appear in the update list on Microsoft Update or on Windows Update
See <http://support.microsoft.com/default.aspx/kb/941729/> for possible help.
If you can not rename msxml4.dll in normal Windows mode, than boot to
Safe Mode <http://support.microsoft.com/kb/315222>...Report Question 03-26-07
Can anyone explain to me if it is possible to take a text field in a report
to make it simulate columns without changing the page setup options. Any help
is greatly appreciated. Thanks!
Message posted via http://www.accessmonster.com
kbrad28 via AccessMonster.com wrote:
>Can anyone explain to me if it is possible to take a text field in a report
>to make it simulate columns without changing the page setup options. Any help
>is greatly appreciated. Thanks!
Normally this kind of thing is done by using a subreport for
the details. This entails creating a main report q...Diff between microsoft.public.outlook and microsoft.public.outlook.general
Unfortunately, I can't download the "descriptions" that goes with each
newsgroup carried by my ISP. The names of the forums described in the
subject line above sound similar, but there must be a difference. Any idea?
J <email@example.com> wrote:
> Unfortunately, I can't download the "descriptions" that goes with each
> newsgroup carried by my ISP. The names of the forums described in
> the subject line above sound similar, but there must be a difference.
At one time there was, but there is no longer. Just choose one.
Brian Ti...microsoft XL
My version of microsoft office XP (microsoft XL) does not
contain the option of showing negative numbers in
brackets. The format/number command only allows a minus
sign or negative numbers in brackets.
Am I missing some other command?
Am I missing something in your post?
First you say
"does not contain the option of showing [negative numbers in brackets]"
then you say
"The format/number command only allows a minus sign or [negative numbers in
regardless the format looks like this
or do you mean
Peo Sjoblo...Button Parameter Query
I am a COMPLETE NOVICE struggling with designing a database... Have Mercy!
I need my user to be able to select from a drop down list of queries from
which the user can then further choose a a single or combination of 7 regions
as the final criteria.
I believe I would need a drop down list of existing queries, for example,
"All Active By Region#", and then allow the user to choose which region(s)
they need to generate the report from a set of buttons on a parameter query
The reports will provide Region#, Name, Id#, address, phone numbers, e-mail,
and teachable qualif...Is Microsoft POS (not Microsoft POS 2009) PCI compliant?
Is Microsoft POS (not Microsoft POS 2009) PCI compliant?
This is a multi-part message in MIME format.
1.0 is not, 2.0 and above are. For a list of compliant applications, =
Check Point Software
Search this newsgroup -- http://tinyurl.com/2lmk4w (Stolen from DRS)
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3...Sum of Descriptions Query
I have a Query that has a WorkID and a Work Description:
1 Go to work
2 Come home
3 Eat Dinner
I want to compile the Descriptions into a single description:
Go to work, Come Home, Eat Dinner
Can I do this & if so how?
can you tell us a bit more - what happens after you put 'Go to work, Come
Home, Eat Dinner' together? Do you have a table with lots of entries like
this that you need to concatenate in the same way?
"Jazflux" <Jazflux@discussions.microsoft.com> wrote in message
news:A8A57FEC-802D-4B54-BFD7-9...Use SQL to delete record from underlying query
I have a form that is a main and subform. The subform uses dlookup to
find multiple values that are used as defaults for the current record.
This process is complex and ends up using code to modify bound fields.
This works great until I want to cancel the update.
If the user wants to add a record, this form is loaded and all of the
prior settings from the underlying tables are brought in. If I then
click Cancel to close the form and not complete the new entry, the
record is saved anyway. I understand why the record is saved by
I wanted to delete the just added record as a roundabout ...Question on single product key and home wireless network
Operating System: Mac OS X 10.5 (Leopard)
I just want to clarify how a single product key/license works when installed on desktop and laptop. It seems that I can use both, but it won't work when Office detects itself on another computer on a local network. What exactly does "local network" mean? I have a wireless network I use at home; does this mean that if I am working at home, I can't have run Office on both computers? For example, if I needed to send something to print from my desktop, I would need to close Office on my laptop first? Just t...Which version of Microsoft Office #2
I've just bought a PC with Windows XP. I need to upgrade Microsoft Office (I
had Office '97). Can anyone confirm that to have a version that will run and
send/receive emails I'll need Office 2003? Can't get a straight answer from
the shop I go to and I don't want to make a mistake.
To answer your question, and not try to steer you to options you did NOT
inquire about, yes, Office 97 is a qualifying product for Office 2000
You may want to look at 2003 as it is the latest version of Office and has
the longest support available. Offic...Microsoft Office 2004
I have been using the microsoft office 2004 on an ibook G4 on panther
for the last 6 months.
Recently, it is refusing to read some of the excel and powerpoint file
created on a PC under the Office 97. I can see the file name but not
the icon next to it when I look under Finder. When I click on the file
name, the file disappears from view completely. At first I thought it
was a software issue so I re-install the Microsoft Office 2004, but the
Has anyone encountered this problem? Any suggestions to solve it would
be much appreciated.
Thanks in advance,
In artic...Synchronizing 2 x Microsoft Outlook 2007 #2
I have MS outlook 2007 on two different PCs. How Can I synchronized the
Calendars from boot Outlooks.
...newbie Create new column question
I want to create a new column "D" which is column "C" + 100.
I can enter in cell D1 the forumla : =C1+100
which does the trick for D1.
But how do I propagate that for all column "C" cells?
This video http://www.woopid.com/video/1355/Create-a-Formula explains how to
easily take a formula in one cell, and have it applied to mulitple cells.
"brucer" <firstname.lastname@example.org> wrote in message
> I want to create a new column "D" which is column "C&qu...microsoft outlook and microsoft project
I install MS Outlook 2003, and also MS Project 2007. When I online MS
Outlook, any time when there is message come in my mail box. Window display "
Microsoft config gathering ms project information"
Is it an installer window or a project dialog box?
If installer, the Microsoft installer program is corrupt. Try Detect and
Repair in Outlook or Project to stop it or just let it run and complete.
If it's a project dialog box, you have some addin doing it.
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Need Help with Common Tasks? http://www....microsoft money loosing VAT content in split catogory withdrawl
I have money 2000 and file VAT returns with the information it provides.
I just discovered that if I have a split catogory withdrawl the VAT
component is blank (greyed out) and is not in report.
Can any one help with this problem