Pages

Search

Microsoft CRM - CRM Database Schema

Microsoft CRM - CRM Database Schema

CRM Database Schema

Posted: 04 Jun 2004 08:05 AM PDT

Matt,

Thanks.

I can see the main links when I put them into EM but I need a higher level
overview and field explaination. Some are obvious but others are not, at
least to me. One thing in particular I am trying to figure out is just where
things are kept. For example, where is the "body" of an activity?

Thanks,

Walter


"Matt Parks" <com> wrote in message
news:com... 
between 
Microsoft 

HOWTO: Customizing CRM - include auto-number field?

Posted: 03 Jun 2004 08:49 PM PDT

Watch out for deadlock and transactional issues around this though. Don't
follow the original MSDN callout documentation that shows a call directly
back into the platform during the callout - use the more recent MSMQ-based
version. You'll have yourself a lot of hassle in the long run.

"John O'Donnell" <com-nospam> wrote in
message news:phx.gbl... 

MSCRM time out?

Posted: 03 Jun 2004 08:11 PM PDT

Using this type of access would be a violation of the EULA for MS CRM. Legally,
the licensing is tied to a person, not an AD login.

As for the timeout, since the app uses integrated security and does not use the
session, there is no timeout functionality.

Matt Parks

----------------------------------------
----------------------------------------
On Thu, 3 Jun 2004 23:43:08 -0700, "Mark" <microsoft.com>
wrote:

Thanks, but I think you're referring to adding a user to
the system, I was asking if I had 2 people who use the
same login to the domain and same login to the CRM system
and who access the system at the same time, will one of
them receiver an error message?

Btw, you have any idea bout the time-out functionality if
its supported? ThanksAgain
 
directory. This means 
your first user, 
a second user. You 
licenses among users. 
message 
to 

Reports list view isn't displayed

Posted: 03 Jun 2004 03:37 PM PDT

No for both. Report list view mentioned here are from
sample database. there is no customized report involved.
Looks like not pure user privileage issue, since login as
administrator(domain) results in the same error.

Thanks for your response.
 
Knowledge Sync installed? 
message news:17ea201c449bb$5c1d69c0$gbl... 

Unexpected Errors sending email

Posted: 03 Jun 2004 02:21 PM PDT

Mark,

Check the registry on the CRM server. Under the local
machine\software\microsoft\mscrm key there will be an entry for the Exchange
server. Verify that the URL appears valid. Also, check to see if you have SSL
installed on the Exchange server for OWA.

Matt Parks

----------------------------------------
----------------------------------------
On Thu, 3 Jun 2004 14:21:56 -0700, "Mark DiMartino" <com>
wrote:

I have just installed CRM.

I am having problems sending email from it.

When I set the DevError on the config file to on it
states:

An unexpected error occured. An error occured attempting
to dispatchthe email: HTTP Status: 404 Nor Found. URL may
be invalid. Error Number 0x80040216.

Source d:\crm\build\3297
\src\platform\include\proxy\proxyutil.h

Line 47

Query String //Activities/Email/edit.aspx

Can anyone shed any insight on this?

Thanks in advance.

CRM Usage - Question

Posted: 03 Jun 2004 12:36 PM PDT

just to clarify. If you use outlook crm client you can only view reports
while online. Once you are offline etc you cannot view reports.
"Per Geert |Nielsen" <microsoft.com> wrote in message
news:17f0501c449ca$420a4fd0$gbl... 

Question: deleted user in active directory before deleting in crm

Posted: 03 Jun 2004 10:36 AM PDT

Hi,

In what tables there is need for delete depends on how
much the user has worked with the system. Therefore look
through what data you don't want to lose. For instance
the user might be an account owner etc.

If you try to delete the user (in the SystemUser table)
it starts telling you what table will be inflicted. You
go to this table and try to delete that record/s. And so
on until you are allowed to delete the user. It's risky,
but so is life...

I know, I know last time I wrote about this I got
complaints. Microsoft will not support this blah blah
blah. But if there is someone who can tell me an easier
way out of this you're more than welcome.

Monika
 
please tell us what 
message 
back 

Global Replace

Posted: 03 Jun 2004 09:30 AM PDT

Yes, you would just issue a command like

update LeadBase
set CFPfield1 = NULL
where CFPfield1 = 2

This is assuming the underlying value for "no interest" is 2.

Matt Parks

----------------------------------------
----------------------------------------
On 3 Jun 2004 22:58:46 -0700, com (Lee) wrote:

Unfortunatly I'm no SQL expert. Can you tell me if it is possible to
issue a command like, for example, if custom field 1 is populated with
no interest (from the pick list) then clear the contents of this
field?

If the above isn't possible I assume it would be possible to clear the
contents of custom field 1 for all lead records using a SQL command?

Thanks
Lee
Matt Parks <com> wrote in message
news:<com>... 

Access to Web Client

Posted: 03 Jun 2004 07:49 AM PDT

Gary,

You missed the other option and that is to allow access to CRM w/o SSL. Depends
on whether or not they want the security that SSL provides.

Matt Parks

----------------------------------------
----------------------------------------
On Thu, 3 Jun 2004 16:07:55 -0700, "Gary" <NOSPAM.com> wrote:

Uhmm.........you weren't very clear. I'll assume you want to connect to your
CRM server from the outside? Well there are two ways of doing this. One,
make your IIS accessible to the public via SSL. And two, use VPN.

I've never done the SSL route, but VPN works just fine for us. The way this
works is that the remote client first connects to the internet, then does a
VPN to your network. Then he can access crm via IE just like as if hes in
the office.

As for the SSL way, check out the IG, I believe its explained in
there,.......

-Gary

"Ian" <microsoft.com> wrote in message
news:17bb901c4497a$0344ba10$gbl... 

Can teams OWN objects?

Posted: 03 Jun 2004 12:01 AM PDT

No,

object are only own by employee, users or group. However you can share
information within team (that their purpose)

Antoine


"RF" <microsoft.com> wrote in message news:<179df01c44938$99ac0400$gbl>... 

Installation of CRM Server result in Unknown Error 80040E31

Posted: 02 Jun 2004 11:56 PM PDT

If the server that is running Microsoft CRM co-exist on
the same server as Microsoft SQL Server performance is
likely to be degraded because of "resource competition"
and this could result in the time out.

So if this is the case you might want to install Microsoft
CRM on another server.
 
server on windows 2003 and database server is SQL 2000 SP3
on windows 2003. A new domain was created on a single
server. Installation goes fine for a long amount of time
then at the very end I get the following error.... I have
uninstalled and reinstalled 4 times!!! Please help! 
files from the SQL 2000 server and have also 
but I am running the SQL2000 and the CRM on a same machine
on its own domain. Why would there be a timeout? 

CRM SFO Client: .ost or .pst?

Posted: 02 Jun 2004 05:41 PM PDT

As tony mentioned .ost is the offline folder. As for the interaction between
CRM-SFO and the pst/ost folders, well.........there is none. You just need
the exchange profile (don't think you can even install it without this). The
pst/ost folders are of mere preference in wether you want to archive or
maintain offline retrieval.

-Gary
"Dave Carr" <microsoft.com> wrote in message
news:1722701c44903$93a414b0$gbl... 

new crm reports

Posted: 02 Jun 2004 12:25 PM PDT

I installed the enhancemensts off of the cd for crm and I
installed 9.2.2.634 Pro from the crystal cd. The path I
took to get to the reports is:
C:\program files\microsoft crm\crystal
decisions\enterprise 9\FileStore\Input
I opened one of the folders until I got to the report, I
made some changes, and saved it to this folder.

Crystal isn't registered since this is my test environment
and I don't have access to a printer or the internet. I'm
not sure if there is a problem using Pro9 to create the
report and saving it in enterprise9 directory. I also
tried creating a report from scratch and saved it at the
root of input. The report works when I run it from within
crystal, I just can't figure out how to get that report to
be an option in crm under the report section.

Thanks for all of your help,
Jen
 
integrating your customized reports. Take a look to the
White paper for Reports on Microsoft web site 

IE and bandwidth use

Posted: 02 Jun 2004 09:27 AM PDT

Thanks Gary, that was great info

 
8&c2coff=1&safe=off&threadm=eJJwpM2IEHA.940%
40tk2msftngp13.phx.gbl&rnum=1&prev=/groups%3Fhl%3Den%26lr%
3D%26ie%3DUTF-8%26safe%3Doff%26c2coff%3D1%26q%3Dbandwidth%
26btnG%3DSearch%26meta%3Dgroup%253Dmicrosoft.publi c.crm 

SQL server eval copy has expired on new CRM demo

Posted: 02 Jun 2004 07:48 AM PDT

MS KB says move DBs, uninstall SQL, and reinstall.
That would be insane amount of trauma.

I rolled back the date on the box a month, and SQL quieted down.
VPC picks its date up from the host box. My VPC is on a test box, so who
cares what date it is....
Not sure if this will work, but so far, so good.

-Bill

"Edwin Garst" <epconsystems.com> wrote in message
news:%phx.gbl... 
the 
step 

Microsoft Word - checkerboard patterned lines on page in Word2010 64 bit

Microsoft Word - checkerboard patterned lines on page in Word2010 64 bit

checkerboard patterned lines on page in Word2010 64 bit

Posted: 02 Sep 2013 02:47 PM PDT

All of a sudden my page displays a checkboard/line pattern on the whole page. it shows up on all documents I open or new documents I create.  it is not related to the content of the page, as I can select text on the page and it doesn't affect the strange line pattern.  I don't understand where this came from, showed up suddenly.  Is this some type of bug from an automatic update of the software?   What do I do to fix this?

Using Word in Office Professional Plus 2010 64 bit, ver 14

on OS: Win 7 Ultimate 64 bit

Phantom text cursor

Posted: 02 Sep 2013 01:54 PM PDT

Using Office 2013 x64 on Win8, I see a phantom text cursor at times. Why/how to fix?
The typed text appears in the correct place. Just the blinker switches between correct and offsetted position, here-there.
Take a look at this screencast: http://www.screenr.com/b1mH  Word 2013 (15.0.4517.1003) 64-Bit on Windows 8 Pro x64.

"Lost" text in Office 2010 "web layout" view

Posted: 02 Sep 2013 01:05 PM PDT

For a few weeks now I've be noticing that in Web Layout view I have been 'losing' some text at the indicated page break line.  Here is 2 views of the same document. The only thing that has changed is that the first one is full screen and the other forced redraw because it was not full screen. The cursor was not moved, zoom level was not changed, only the document was "unstuck" from top of the screen which forced full screen view

<comment> Well, that sucks! Now I can't insert pictures. For some reason the "Upload" dialog only shows the heading and a blank 1 line space below it ...  FireFox 23.0.1  </comment>

<edit> OK, I logged in to IE and image upload works ... <sigh>, they are playing games again </edit>

<edit> <sigh> when I went to document not being able to upload images in FF, it now works. go figure </edit>

 

Note: in this first screen capture (app window not maximized to full screen) the body text goes from Point 12 to Heading 2 Item 4

 

 

This next screen capture shows exactly the same document at an indicated page break "jumping" from point 12 to several lines down into the Heading 2 body text, with no sign of the heading.


The images I was going to post show that without changing anything other that forcing a redraw, show that in one SEVERAL lines of body text are "lost" in the page break.

Cursor always flashing and loading

Posted: 02 Sep 2013 10:40 AM PDT

I am using Microsoft Word Starter 2010 and my cursor seems to always be flashing and loading. But nothing is loading. It runes quick and smooth. But this cursor is really annoying. Word is the only program I have this problem with. Any suggestions?

Word 2010 Docx Missing - Windows 8

Posted: 02 Sep 2013 10:24 AM PDT

I'm been working on a 2010 word docx all day. I've been periodically saving my work in 'My Documents'. The docx was being a little strange asking if I wanted to rewrite it each time I clicked 'save' but it did appear to be saving. Because of this to be safe, I also saved the file under a different name at the end of the day, then I closed word.

Now when I open the original file none of today's work is saved. And the renamed file is present in the 'recent' list (also saved in My Documents) but when I click on it, it can't be found!

Have I lost a days work or is there a trick to getting it back?

Any help would be fantastic

Over 99 Bullet Points text is indented..

Posted: 02 Sep 2013 10:21 AM PDT

I have reached 100 numbered bullet points in a document and the text on this bullet point and subsequent ones becomes indented.

Is this what is to be expected or is there a way around this problem?

Can not select mailmerge in tools

Posted: 02 Sep 2013 09:44 AM PDT

I have used mail merge hundreds of times to create labels. Just recently when I drop down the tools options, I click on mail merge, and nothing happens.
The rest of Word is functioning except the tool bar.
I tried the Detect and Repair.
Mail Merge is selected in the View / Toolbar selection.
I am using Windows 7.

I tried uninstalling Office 2003. I then used C Cleaner to tidy up the registry before re installing Office 2003.
Nothing changed.

Any ideas???

Thanks,

Dennis

How do I rid large gutters when they are set at 0 and "Multiple Pages" is set at "Normal"

Posted: 02 Sep 2013 09:40 AM PDT

I have 0 setting for Gutters and "Multiple Pages" set at "Normal", but can't get rid of large gutters.  They suddenly appeared after a computer re-boot. 

Vertical scroll bar in Word 2013 does not work

Posted: 02 Sep 2013 08:19 AM PDT

In Word 2013, the vertical scroll bar does not work properly.  The problem occurs when you click on the arrows or try to drag.


For example: you move the onscreen arrow to the bottom of the vertical scroll bar and left-click.  The document scrolls down, as expected.  Wait ten seconds.  Left-click again.  The document should continue to scroll down, but nothing happens.  You have to move the arrow with the mouse or touch pad, at least slightly, to "wake up" the scroll function.

This happens to me with Office 2013, in a Windows 7 environment.  I had been using Office 2010, with Windows 7, for a long time, and never had this problem.

This has been posted before, as early as March 2013, but though the thread is marked "Answered" the problem has not been solved.  Other users have reported the problem as recently as yesterday.
http://answers.microsoft.com/thread/e00af15d-6b41-405d-ac6d-f42290e02982

Microsoft, are you listening?  Thank you.

Mark

How does one nest EQ fields? e.g. {eq \o(\s\up11({eq \o(¯,e)}),{eq \o(_,a)})}

Posted: 02 Sep 2013 07:42 AM PDT

Hi,

This nested eq field works correctly in word 2007, but produces an Error! in word 2013.

{eq \o(\s\up11({eq \o(¯,e)}),{eq \o(_,a)})}

 

Is the 'eq' field deprecated? if so, what will give the same functionality.

e.g.

Allow one or more characters to be overlaid one over the another &

Allow one or more of these composed characters to be printed/displayed one above the other as in a fraction but with no solidus.

 

Regards Julian.

cannot open word documents on new computer

Posted: 02 Sep 2013 05:57 AM PDT

I bought an Acer - it has windows 8 on it.  I have word 2013 and cannot open any of my older word documents.  I tried this:

  1. In Windows Explorer, make a copy of the file and use the Rename command to change its extension from .DOC to .DOCX. (Probably the recovery program was written before Microsoft invented the .DOCX extension, so it used the .DOC extension instead.) Try opening that file in Word 2013.
  2. In  Word 2013, go to File > Options > Trust Center > Trust Center Options > File Block Settings. Uncheck all the boxes in the Open column and click OK in each dialog. Then try to open the file.



NOTHING WORKS AND I AM GOING CRAZY!


please help

missing 365 apps on windows 8

Posted: 02 Sep 2013 05:51 AM PDT

I am missing 365 apps (ie word excel etc) on windows 8 start can open files ok tried everthing any suggestions

capitalisation

Posted: 02 Sep 2013 05:39 AM PDT

In microsoft office home and student 2007

 

When I type somebodys name into a novel that I am writing ,instead of what I want it as Ged , word keeps changing it to all uppercase so that it ends up as GED . I cant find a way to stop it happening.

Can I use BLOB images in a Word 2010 Mail merge?

Posted: 02 Sep 2013 05:28 AM PDT

BACKGROUND

I have an application which recovers signature images via a PDA as BLOB (Binary Large OBject) files and saves them to a database.

Later the application allows a Word Template document to be used to create one or more documents.

I can add VBA to the Word Template without the application getting grumpy.

There are no "hooks" into the applicatiuon which allow me to insert code / modify behaviour directly into the application. The application just populates a Word document from mailMerge fields.

 

THE PROBLEM

I need to insert the signature gained by the Engineer on his PDA into a Word document.

 

The field name (as available to Word's Mailmerge function) is "CallCustSignature".

 

When I insert the name into the document as a MailMerge field, I just get text, which presumably is Word's "best guess" at interpreting the data as text.

 

I can't find a way of telling Word that CallCustSignature is a BLOB image, and should therefore be displayed as an image.

 

As I have access to VBA during the "resolution" of the documant, I could probably write VBA to import the "image" from the database, if only I knew how! (I'm reasonably competent with VBA and VBS.)

 

Can any kind soul point me in the right direction?

Any help would be gratefully appreciated.

 

Word document protection.

Posted: 02 Sep 2013 05:06 AM PDT

Hi all,

 

How would I set up a word document so that it can be used but not over written.

 

I have a word document and its a form, it will be used a lot. I would like so it can be filled in but when they save it automatically makes them 'save as' keeping the original.

 

So when they click save it saves a new document and keeps the original un edited.

 

Does this make sense?

 

Thank you.

 

windows 8/windows live mail can send e-mail from MS Word

Posted: 02 Sep 2013 03:28 AM PDT

Hi

I have recently (much to my regret) had to upgrade to Windows 8.

Having just got used to Windows Live Mail, now I find I can't send mail from MS Word.

 

I want to send an MS Word 2007 document via e-mail.

When I click on "Send" the "e-mail" box is greyed out.

I used to be able to send like that using Windows 7, but as usual Microsoft have taken another giant leap backwards with their new Windows.

 

How can I get Windows Live Mail, MS Word and Windows 8 to talk to each other?

 

Regards

Conditional Content Control Dropdown List

Posted: 02 Sep 2013 03:03 AM PDT

Hi,

How to create conditional ContentControlDropdownList?

Eg: First list box will have names of companies, second list box will have bike names. Here bike names should be displayed based on selected company.

I tried a lot, and also searched online but no answers found for "ContentControlDropdownList" field.

The same can be achieved using "Legacy Form > Drop-Down" but I don't use it because I have to end-up restricting my self from editing other parts of word doc.

Regards,
Anand

Can images on cover page or watermarks be saved into a doc template?

Posted: 02 Sep 2013 02:05 AM PDT

Hi,

I wanted to create a document template with a cover page having an image and a watermark on the other pages. I couldn't find any means to do so. Did I miss something? Is it possible at all?

Thank you!

Julia

How to allow form fields plus other content to be editable?

Posted: 02 Sep 2013 02:04 AM PDT

Hi,

I have Drop down(combo box) fields in the word doc and other content, because the Editing restrictions is enabled to 'Allow only this type of editing: Filling in Forms" I am unable to edit any other content in the word doc, so how do I make other word content to also be editable while 'Filling form' restriction is enabled?

Thanks in advance.

Regards,
Anand

Password protect first page only in Word 2010

Posted: 02 Sep 2013 01:46 AM PDT

Hi,

I hope someone can assist me with this.

Recently we underwent a major internal document rebranding process and had to insert a logo in the bottom footer and top left corner of the header on the first page of each document. The graphic designers are the only people who may modify the branding, since they are the experts on the company's corporate identity.

We made templates for my company's academic department who has to create exam papers with questions and whatnot. We have to restrict editing of the header and footer on the first page ONLY, because the people who will be setting up the exam papers have to be able to insert their own footer from the 2nd page onwards. We're not using a header for the 2nd page onwards. We cannot put the 2nd page footer content outside the footer, because they will move things to undesirable locations.

So, 1st page header and footer must be locked. 2nd page footer must be editable.

How do I go about this? Is this even possible?

I tried to use continuous section breaks, but the 2nd page footers still stay locked after I specified which sections to protect and which to leave unprotected.

Any help would be massively appreciated!

Microsoft Office 2010
Windows 7 Professional Service pack 1

Word won't open downloaded .docx files.

Posted: 02 Sep 2013 12:12 AM PDT

I am using Office 365 and Windows 8.  When I try to open a downloaded .docx in Word, the Word logo pops up and loads forever.  It never actually opens the file.  The downloads I am trying to open are documents posted by my professors on an online campus called Canvas.  I can email the files to myself and then they open in Word just fine.  It's not the documents that's the problem, it's something with Word.

office keeps crashing

Posted: 01 Sep 2013 11:40 PM PDT

Help! Since I have installed Office 2013 my computer keeps crashing when I am using it. This is the message I'm getting:

 

Problem signature:

  Problem Event Name:                        BlueScreen

  OS Version:                                          6.1.7601.2.1.0.768.3

  Locale ID:                                             3081

Additional information about the problem:

  BCCode:                                               50

  BCP1:                                                    FFFFF900C1EAC000

  BCP2:                                                    0000000000000001

  BCP3:                                                    FFFFF96000092364

  BCP4:                                                    0000000000000000

  OS Version:                                          6_1_7601

  Service Pack:                                       1_0

  Product:                                               768_1

Files that help describe the problem:

  C:\Windows\Minidump\090213-22120-01.dmp

  C:\Users\DeeJay\AppData\Local\Temp\WER-77891-0.sysdata.xml

 

Please help I have no idea what any of this means

Is it possible to have two different level of numbers on same line, like 1. a) or 1. ii)

Posted: 01 Sep 2013 10:11 PM PDT

Sometime I want format like this in Word, is it possible using Numbering / Bullets, I can set it manually but want some better solution.

1. a) or 1. i)

Index headings at top of each page?

Posted: 01 Sep 2013 10:00 PM PDT

I have some index headings with subheadings that go on for pages. Is it possible to have the main headings appear at the top of each page? Otherwise the reader has to search backwards to see what the main heading is.

Is it possible to create a continous index in word 2010 using TOC?

Posted: 01 Sep 2013 08:43 PM PDT

Hi,

 

Is it possible to have continous index in Word 2010.

 

For e.g.

 

My data is as follows

 

Page No 2 :- ABC

Page No 3 :- ABC Contd..

Page No 4 :- ABC Contd..

 

After this I have applied the headings 1 style to above three. And when I create an Index using TOC the answer is as follows.

 

ABC..........................2

ABC contd.............3

ABC contd.............4

 

Instead of this I want :-

 

ABC...............2-4

 

Kindly help.

 

Thanks & Regards,

Gaurav

Do I need to purchase it if I want to install Vietnamese language in Windows 7 Pro?

Posted: 01 Sep 2013 07:57 PM PDT

HI,

I need to install Vietnamese language in Windows 7 Pro. May I know how can I get it?

I've read http://support.microsoft.com/kb/972813/en-us, but I dont find it in the windows update.

OS: Windows 7 Pro
MS Office: Word 2007

Thank you.

i cannot open word 2010 on my pc, listed in programs, click on open, does not work

Posted: 01 Sep 2013 06:30 PM PDT

Word listed in my programs, click on word and will not open?

Microsoft Word 2013 Documents keep opening in Word Starter 2010

Posted: 01 Sep 2013 05:49 PM PDT

Hi,
I installed Office 2013 Home & Student earlier today. It worked fine until I saved a document and tried to re-open it only to find that the document opened in Word Starter 2010. I had Word Starter 2010 before Office 2013 and now all my Word 2013 documents open in Word Starter 2010 by default. I have tried setting my Office programs as the default programs but this appears to have no effect. I am not sure if uninstalling Word Starter 2010 will fix this but I am worried that I may lose all my documents if I do so. Also, Word Starter was part of Office Starter 2010 that also came with Excel Starter. What should I do?

How do I change my language preferences in Word?

Posted: 01 Sep 2013 05:32 PM PDT

Everything is in Korean but I want it to be in English (Canadian).  Please help me!

Word 2003 clipboard recovery

Posted: 01 Sep 2013 03:30 PM PDT

Is there any way to recover the last clipboard when the computer crashes?  I suspect there isn't, but there is no harm in asking.

Word 2003 clipboard recovery

Posted: 01 Sep 2013 03:30 PM PDT

Is there any way to recover the last clipboard when the computer crashes?  I suspect there isn't, but there is no harm in asking.

Trial version expired after 1 day Microsoft Project

Trial version expired after 1 day Microsoft Project

Trial version expired after 1 day

Posted: 04 Nov 2004 03:02 AM PST

Thanks Gerard, that worked. :)

Jim

"Gerard Ducouret" wrote:
 

Variables in Filters

Posted: 03 Nov 2004 10:59 PM PST


pratta,
I started out playing with filters but quickly decided that although
there might be some clever filter that will work, a VBA approach is much
easier. The following code should do what you need.

Sub ThisMonthStatus()
OutlineShowTasks expandinsertedprojects:=True
MonDates = InputBox("Enter Month Start Date and Month Finish Date " &
Chr(13) & _
"separated by a comma (e.g. MM/DD/YY,MM/DD/YY)")
MSD = CDate(Mid(MonDates, 1, InStr(1, MonDates, ",") - 1))
MFD = CDate(Mid(MonDates, InStr(1, MonDates, ",") + 1))
For Each t In ActiveProject.Tasks
If Not t Is Nothing Then
t.Flag1 = False
If t.Summary = False Then
If t.Start >= MSD And t.Finish <= MFD And _
t.PercentComplete > 0 And _
t.PercentComplete <= 100 Then t.Flag1 = True
If t.Finish >= MSD And t.Start <= MFD And _
t.PercentComplete > 0 And _
t.PercentComplete <= 100 Then t.Flag1 = True
If t.Start <= MFD And t.Finish >= MSD And _
t.PercentComplete > 0 And _
t.PercentComplete <= 100 Then t.Flag1 = True
End If
End If
Next t
FilterEdit Name:="MS", taskfilter:=True, create:=True,
overwriteexisting:=True, _
FieldName:="flag1", test:="equals", Value:="yes", showinmenu:=False,
_
showsummarytasks:=False
FilterApply Name:="MS"
End Sub

John
Project MVP

How do I change yes/no to numeric values?

Posted: 03 Nov 2004 09:48 PM PST

Echoing Julie re the appropriate group. But as an FYI, Access, VB, and SQL
use 0 for False and consider any non-zero value to mean True. If one
converts a boolean (Y/N) field to an integer data type or changes its
display attribute in the field properties, you'll find that it's stored as
signed integers where "Yes" values are -1. As to the weighting values, the
simplest seems to be to add a field for a weighting multiplier as part of
the master question parameter definitions (you do have the datasbase
normalized to the point that there is a separate table containing the
question pool and their parameters do yout not?) A query then that
muliplies the value in the boolean field by the weighting and totals the
result is easy-peasy.
--
Steve House [MVP]
MS Project Trainer/Consultant
Visit http://www.mvps.org/project/faqs.htm for the FAQs


"Lisa Frick" <Lisa microsoft.com> wrote in message
news:com... 

Can't open Project 2000 files in 2003

Posted: 03 Nov 2004 02:23 PM PST

HI, Here's an update. I can open the file in Project
2002, but still won't open in 2003. I tried using the
suggestion in FAQ #43, but didn't work. I opened and
immediately saved in 2002, but 2003 will not open. Any
other thoughts? 
message de 
None 
2003 
any 

MS project - how to hide rows or columns

Posted: 03 Nov 2004 01:37 PM PST

Hi,

Hide Columns: select the title, hit the delete key (you can always re-insert
them)
Hide rows: use a filter. Project, Filtered for...

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/index.htm
32-495-300 620
"earl-j" <microsoft.com> schreef in bericht
news:com... 
and 
to 
are 
i 

General question about use of MS Project

Posted: 03 Nov 2004 01:01 PM PST

Definitely loaded questions! I just wanted to get a feel for whether
its worth proceeding. I think it probably is...I realize there's a
learning curve, and I want to start climbing up. Our organization
really needs this structure, even though it might be a little painful
at first.

I appreciate your comments and think its helpful.


Rob Schneider <net.net> wrote in message news:<phx.gbl>... 

Cash Flow

Posted: 03 Nov 2004 12:24 PM PST

SuttonT --

If you are printing the Cash Flow report and wish to show costs as dollars
only, you can click Tools - Options - View and set the Decimal Digits value
to 0 temporarily. Just a thought.

--
Dale A. Howard [MVP]
Enterprise Project Trainer/Consultant
http://www.msprojectexperts.com
"We wrote the book on Project Server"


"SuttonT" <microsoft.com> wrote in message
news:com... 

Export Line items from project 2003 to outlook tasks 2003?

Posted: 03 Nov 2004 10:32 AM PST

Ok, Thanks! This is what I thought, but I wasn't sure.



"Dale Howard [MVP]" wrote:
 

open a project 2002 file using project 98

Posted: 03 Nov 2004 07:29 AM PST

Hi Sunil

you need to save the project in 2002 down to a 98 version (file / save as
.... change the save as type) ... before you can open it in 98 ... however,
please note, that you may "lose" anything that is not supported in 98.

Hope this helps
Cheers
JulieD

"Sunil mathai" <Sunil microsoft.com> wrote in message
news:com... 

See non working time

Posted: 01 Nov 2004 06:01 AM PST

Hi Jan

I had a look on your website but wasn't able to find the macro.

We have a VB programmer whose can help me.

Can you give me more information to find this macro.

Thank you very much.

"Jan De Messemaeker" wrote:
 

problems in reports

Posted: 30 Oct 2004 10:32 AM PDT

Hi Rob
Thanks for the answer, I will try your advice soon.
Franz

"Rob Schneider" <net.net> schrieb im
Newsbeitrag news:e%23TVX%phx.gbl... 

Printing Problem: Network Host Is Busy Microsoft Office for Mac

Printing Problem: Network Host Is Busy Microsoft Office for Mac

Printing Problem: Network Host Is Busy

Posted: 29 Apr 2008 03:10 PM PDT

Hey Bob

This morning I launched I-Tunes and was alerted to the opportunity to install 11 various updates. Upon doing that, everything worked.

To your question, what I know about Bonjour you can write on a post-it note. When I brough my Mac home in January, I plugged it into the router and mostly everything worked. As I said in my post, the printer worked just fine.

Having done some reading, I gather that Bonjour is worth doing something with. So as not to much up this thread, I won't ask any questions here.

But to be clear, yesterday I restarted everything : routers, computers, printers, everything. I also uninstalled and reinstalled the printer drivers. I reset the printing options. I reset the disk permissions on the MacBook Pro.

MSN Messenger-VideoConferencing

Posted: 28 Apr 2008 08:32 PM PDT

Hello,
Messenger for Mac 7.0 has been released! You can download the product
from
the following location:
http://www.microsoft.com/mac/products/messenger/default.mspx

There's a blog on it at:
http://www.officeformac.com/blog/Messenger-for-Mac-7-is-Now-Available/

-Eric
MacOffice Testing
Microsoft

"John Lockwood" <co.uk> wrote in message
news:C43CAECA.2C78A%co.uk... 

--
This posting is provided "AS IS" with no warranties, and confers no rights.

MS Mac Newsgroups: http://www.officeformac.com/ProductForums
MS Mac News & Updates: http://www.microsoft.com/mac

OFFICE 2008 12.0.1 update

Posted: 28 Apr 2008 06:50 AM PDT

This particular issue is maddening, because it means that if you customize
your installation (remove the JUNK that is included in the default
installation) the updater will not function properly. I really want to know
what it's looking for so I can at least trick it into doing it's job.

When the MBU said they were helping to support Enterprise by putting things
in a package format, all they did was put things in a package format. This
isn't enterprise support at all.

"com" wrote:
 

custom color

Posted: 28 Apr 2008 05:57 AM PDT

In article <caR9absDaxw>, com
wrote:
 

Since Office uses the system color dialog, you can save it in a palette
just like you can from any other application.


In the system color dialog (which you used to set your CMYK color), once
you have set you color, click the "Color Palettes" icon, choose "New"
from the right-hand dropdown (with the gear icon) to create a new
palette, then click the '+' button to add the color to the palette.

Your palette will now be available in any application (that uses the
system color dialog).

Changing the default setting in MacWord 2008

Posted: 26 Apr 2008 07:44 PM PDT

Hi Monica:

Your question has nothing to do with Word. Post it in a new question so
that we get all your version information, and one of the Entourage
specialists will be along in a minute to help you. They won't see it in a
thread labelled "MacWord" :-)

Cheers


On 28/04/08 2:38 AM, in article caR9absDaxw, "MOnica
Udvardy" <com> wrote:
 

--

Don't wait for your answer, click here: http://www.word.mvps.org/

Please reply in the group. Please do NOT email me unless I ask you to.

John McGhie, Microsoft MVP, Word and Word:Mac
Nhulunbuy, NT, Australia. mailto:name

Word APA referencing bug (or am I using it wrong)

Posted: 25 Apr 2008 07:38 PM PDT

It's not just you.

We are waiting for our resident citations expert to return from her holidays
and help you out.

But basically, the Word 2008 citation styles are currently not quite
correct, and there is work going on to improve them.

Cheers


On 27/04/08 12:11 AM, in article
googlegroups.com, "Ben W"
<com> wrote:
 

--

Don't wait for your answer, click here: http://www.word.mvps.org/

Please reply in the group. Please do NOT email me unless I ask you to.

John McGhie, Microsoft MVP, Word and Word:Mac
Nhulunbuy, NT, Australia. mailto:name

End/Beginning of Document Doesn't Work in 2008 Student

Posted: 25 Apr 2008 10:52 AM PDT

Thanks, CyberTaz. I didn't realize you had to use the command key as well--I was just using the function key. Still, I miss the PowerBook toolbar.

Toolbox Settings

Posted: 25 Apr 2008 06:01 AM PDT

In article <C43A4D3F.1260C%name>,
John McGhie <name> wrote:
 

However, see

http://j-walkblog.com/index.php?/weblog/posts/improving_office_2007/

Document size is too large

Posted: 21 Apr 2008 04:18 PM PDT

Susan, you are NOT having the same problem. Please post a new question so
we get your version information, then we can give you the fix.


On 24/04/08 9:18 PM, in article caR9absDaxw, "Susan
Mey" <com> wrote:
 

--

Don't wait for your answer, click here: http://www.word.mvps.org/

Please reply in the group. Please do NOT email me unless I ask you to.

John McGhie, Microsoft MVP, Word and Word:Mac
Nhulunbuy, NT, Australia. mailto:name
Subscribe to: Posts (Atom)