Pages

Search

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...