Migrating from MS Access
I have this query, which I need to make work in MS SQL Server
select job.[CAM File],FIRST([material]), FIRST(job.[description]),
FIRST(job.[programmer]) from job where job.[CAM file] <> ''
group by job.[cam file] order by 3
The "first" is my problem.
I can translate most of into
select job.[CAM File] from job
where job.[CAM file] <> '' group by job.[cam file])
Now I need to add the first row - for each cam file - how?
Next, I need to read something like this:
select top 1 job.[CAM File],
job.[material], job.[description], job....Office 2000 & Office 2007
Just got a new laptop with windows 7. Had purchased office 2000 for my old
pc, can I updgrade to Office 2007 or do I have to buy it all over again. Is
so how ?
"Kevan McArthur" <Kevan McArthur@discussions.microsoft.com> wrote in message
> Just got a new laptop with windows 7. Had purchased office 2000 for my old
> pc, can I updgrade to Office 2007 or do I have to buy it all over again.
> so how ?
You can upgrade to any upgrade edition of Office 2007. You will need the
installation dis...How do you use the Livescribe smartpen with MS Office products?
I just received a Pulse Smartpen as a gift and I love it. I am curious about
how other users of Office products utilize their smartpen features with Office
...Working with Office Live Workspace
Operating System: Mac OS X 10.5 (Leopard)
Does Office for Mac work with Office Live Workspace?
...Out of Office settings 2007 outlook
Out of Office settings cannot be displayed, because the server is currently
just had Exchange service pack 2 installed and hot fix KB970892
I did a Test E-mail AutoConfiguration test all ok
You are best directing this too an exchange or outlook group
"Dave" <Dave@discussions.microsoft.com> wrote in message
> Out of Office settings cannot be displayed, because the server is
> 2007 office
> just had Exchange service pack 2 instal...Office 2007 ultimate and Outlook 2007 Installation
I currently have Outlook 2007 on my PC. I will be installinf the complete
ultimate suite. Do I need to uninstall the current outlook 2007 first?
If I don't and install over it, will I loose my emails and folders?
I would prefer to install all of the office suite in case there are files or
links that could be omitted if I choose not to install outllok from the suite.
Thank you for your help
Which Office 2007 version do you have installed at present
Please Reply to Newsgroup for the benefit of others
Requests for assistance by email can not and will not be a...Office 2008 Setup Assistant Repeatedly Crashes
Installed Office 2008 via Remote Disc to a Macbook Air. When launching Office Apps, Office Setup Assistant opens but when I attempt to continue it crashes. Here's the error report
Microsoft Error Reporting log version: 2.0
Date/Time: 2008-02-16 12:00:46 -0800
Application Name: Microsoft Office Setup Assistant
Application Bundle ID: com.microsoft.setupassistant
Application Signature: MosA
Application Version: 12.0.0.071130
Crashed Module Name: EntourageLegacy
Crashed Module Version: unknown
Crashed Module Offset: 0x000e921f
Blame Module Name: Ent...Letter Writing Assistant won't recognized MS Word IS installed
When I go to Reports/Letter Writing Assistant, I get an error message that
"Microsoft Word must be installed on the machine to use the Letter Writing
I running XP on a networked client notebook with full Office 2003 installed
(SP2) and I'm using GP 9.0
Has anyone else had this problem? Got a solution?
I faced this before when i installed Great Plains first and then followed by
If your case is same as above, then you need to uninstalle the client
version first then i reinstalled office followed by Great Plains Again.
I suggest in your case try to rei...Reintstalling Office 03 on a new machine, Excel does not appear
Had to put a new hard drive in my notebook, and reinstall XP home and all my
software. Reinstalled Office from original disks, and most of it works. Word
is fine. However Excel does not appear in Start/All Programs or anywhere
else. Tried three times. What's up?
Try Start>Run excel.exe
When you re-installed was it a "typical" or a "custom"?
Start>Settings>Control Panel>Add/remove programs.
Scroll down to Office 2003 and change/remove.
Follow your nose from there and you can see if Excel has been installed.
Hav...MS Money and Quicken
As I try to be an realist, I bought today Quicken to be able to work
in future with a money management, as I did for nearly 15 years very
satisfied with money.
I am new to quicken and very experienced with money and I think, money
was the simplier to use money software.
The price updating worked mostly fine and free of charge. In Quicken
here in Europe, you have to pay for the update service, if you like to
uodate international stocks, 2 =80 a month. And the updating lasts much
I hope I will get used to Quicken, but I would prefer Money, if they
decide to make the updating process avai...Office 2003 rollout
I am trying to roll out Office 2003 using an MST file - deployed from System
Center Essentials. The installation is successful on the workstation, and
SCE reports the installation as successful. However upon reboot the
workstation says that it needs the Office install again.
I pretty much accepted the defaults in creating the MST file using the
Resource Kit's Custom Installation Wizard. I did make a few changes to the
product features, but that's about it.
Initially I did have the MST configured to remove any prior versions of
Office but suspected that this could...Office 2003 #3
I installed Microsoft Office 2003 and cannot create, reply
or forward email. I am receiveing the error message "The
messaging interface has returned an unknown error. If the
problem persists, restart Outlook. I have applied all of
the updates for Office 2003.
I'm having the exact same problem...same message. I tried
uninstalling and reinstalling, as well. No help!
>I installed Microsoft Office 2003 and cannot create,
>or forward email. I am receiveing the error message "The
>messaging interface has returned an unknown e...Microsoft says I don't get an Upgrade to Office for Mac 2008
In October 2007 I ordered Microsoft Office 2004 for Macintosh from Amazon under an advertised Promotion that allowed an upgrade to the already announced Office 2008 by filling out the "Microsoft Ofﬁce 2008 for Mac North America Technology Guarantee Redemption Form". I would have never ordered a 4 year old product that was going to be discontinued without this promotion. In December 2007, I mailed to Microsoft the now available redemption forms along with the required copy of the sales receipt and "The ORIGINAL product box top with the product name and barcode clearly ...what is the function in ms access like ""sumif""in ms excel?
what is the function in ms access like ""sumif""in ms excel?
islam labib <islam firstname.lastname@example.org> wrote:
>what is the function in ms access like ""sumif""in ms excel?
=Sum(IIf(condition, value, 0))
MVP [MS Access]
...Student Office for Mac Woes.....
First, thanks in advance to all those who help
Next, I must admit, Mac is TOTALLY different. I'm being straight forward
about this, Mac is tough for me to get use to in order to help my daughter
since I'm so use to Windows etc.
We installed Student Office for Mac in her new laptop she bought last week
for college. We did NOT uninstall the Demo, thanks to M$ being so inept by
not providing a pop up warning of some sort during install.
What must we do now? She installed her college Student Office for Mac, used
it before she learned about the required deletion of the Demo version?...How can I restore Mailboxes from an old .edb file in MS-Exchange 2
I need some help in showing me how can I get or restore users
mailboxes just by using .edb file i copied from the server b4 i format it &
install the windows & exchange from scratch; but i didn't take the .stm file
If there is any way to restore the mailboxes plz inform me ASAP.
my e-mail is : mullder at hotmail.com
Mob. : +(20)10-5566357
On Fri, 19 Nov 2004 20:19:03 -0800, "Just an Exchange that needs
HEEEELPPP!!!" <Just an Exchange that needs
&...Out of Office Subsequent Rules?
Hi, I've created a couple of Out of Office rules (Exchange 2000 Server and
Outlook 2003) and am having trouble with the subsequent rules action. I need
to have mail that is sent to me when I'm out of the office forwarded to my
Blackberry phone (yes, I know there is a Blackberry server to do this but
for just one user that's over the top) APART from when messages contain
So I have created the first rule in the order list that says when any mail
arrives that has attachments, move it to a specific mail folder (so I can
deal with it later) and NOT TO PROCESS SUBSEQ...HTML Email templates in MS CRM 1.2
In MS CRM version 1.0 there was the possibility to include HTML in an email template. When you would include some table, link or image html tags in the email they would be converted and diplayed as html.
Our problem is that version 1.2 doesn't seem to support this any longer.
Is this true or is there another way to do this. If it is remover, why has that been done.
Yes this is a removal in v 1.2 to disallow scripting via the editor.
Priya J...office 2003 install question
I just purchased a new HP laptop that does not have an optical drive. I have
Office 2003 with my product key and want to know if there is any way to
install this on my new laptop without an optical drive. Any help is
"freddy" <email@example.com> wrote in message
> I just purchased a new HP laptop that does not have an optical drive. I
> Office 2003 with my product key and want to know if there is any way to
> install this on my new laptop withou...Office Icons - tweaking and saving
The icons provided when installing Office leave, shall we say "something
left to whish for" ... Which leaves me with the task of editing them. I make
several toolbars, global and local, full of macros, each one with a separate
icon (no text - takes to much space). In order to successfully separate these
icons I need to make if not unique at least different. It’s tedious and
mundane, but once done - I'm happy again. That is until the computer
Is there not a program, or something, that lets me save and by all means,
retrieve these icons?
I use the...Reporting on MS Project Server in java
I am trying to use MS Project server PSI in java.
I could create java stubs by using the wsdl.
Now if I want to see all the projects, I couldn' find any API in the Project
I couldn't find any help related to the same.
Is there any way where I can get list of Projects availaible in MS Project
Server or do I need to go through the reporting database route?
I wanted to use the WEB SERVICE route as I dont have to worry about the
Any help would be appreciated.
Thanks in advance,
The correct place to ask developer questions ...MS Excel 2003
Does anyone know how to change a line to a bar in a chart? I'm plotting a
chart with four sources; I would like three to be bars (primary axis) and the
forth to be a line (which is on the secondary axis). Does anyone know how I
can change the lines to bars in the chart?
Make Column chart with four series
Right click on one data series in the chart
Use Chart Type form the shortcut menu
Bernard V Liengme
Microsoft Excel MVP
remove caps from email
"Eileen" <Eileen@discussions.microsoft.com> wrote in me...Integration between MS CRM 3.0 and OA2007
Have you heard of any tool that provides integration between MS CRM 3.0
and OA2007? Recently, it seems that a number of people are looking
forward to have this tool.
In line with this, we are currently developing a connector between
Microsoft Dynamics CRM 3.0 and Microsoft Office Accounting 2007, and we
are looking for CRM users, small business specialists and interested
professionals who are willing to be advisors for this endeavor.
Advisors will have the chance to influence the features of the software
we are building and will get to evaluate pre-release versions of our
applicatio...Why does it MS Publisher print Head-to-foot for double sided proje
When I create a MS Publisher project that is double sided it prints
head-to-foot ( tumble) so the back page is upside down. How do I resolve this?
That may be a setting of your printer.
MVP Microsoft [Publisher]
How to ask a question
"jvaile" <firstname.lastname@example.org> wrote in message
> When I create a MS Publisher project that is double sided it prints
> head-to-foot ( tumble) so the back page is upside down. How...HELP MS WORD AND EXCEL thanks for the help
I have a table in Word that has many rows and cells with text in it.
I have a column of text in excel.
I would like to get in excel the information from the work document of just
the text that is found in my excel column.
I tried vlookup but the document in word may have a sentence in it and vlook
look at a whole cell not part of it.
Thanks for the help very much.
Example: word docuement has "table four is next to table three"
in excel I have a column