Recent content by DAVEKELLY

We created Z report based on CN42 - thread closed.

I need a User List transaction ie (CN42) that will display the Creation Date of the Project Definition. Visible in SE16N Table PROJ, Field Name ERDAT and Data Eleemnt ERDAT. Any pointers much appreciated. Thanks

Thanks Skip. I will use and test your code tonight. The code was from Jon Peltier's graphing site and his code is the only code I received by 'googling' for aligning zero on left and right axes. Strange that Jon's code returns incorrect min values on run, but in step mode it returns correct...

Using Jon Peltier's example for aligning axes in Excel 2003 - the code correctly calcluates and aligns the left and right axes for me - however in 2007 it returns incorrect values. If I then run the code in step mode (in 2007) it returns the correct results. Any suggestions? Many Thanks

As a post note to this - if you are looking at Milestones off projects and want to classify them in date ascending order ie) earliest date MS1, next date to MS2 etc for use in for example 'project traffic light' reports, I changed the WHERE to: WHERE (((Table1.MS_Date)>=[N].[MS_Date]))...

Duane - Thank you so much. For completeness of this question - the SQL is listed below: As can be seen I added an INNER JOIN. SELECT Table1.Project, Table1.MS_Date, "MS " & Count(*) AS MS FROM Table1 INNER JOIN Table1 AS N ON Table1.Project = N.Project WHERE (((Table1.MS_Date)<=[N].[MS_Date]))...

I have a query that looks at a project milestone table. The query assigns a value to each Milestone (ie MS 1, MS 2 etc). There are a max of 4 Milestones on each project. SELECT Table1.Project, Table1.MS_Date, (SELECT "MS " & Count(*) From Table1 N WHERE N.Project = Table1.Project And...

Article 'Using DAO to Export Data to Microsoft Access' from MS describes exporting from Project data to Access. Defining the Access Table: projtable.Fields.Append projtable.CreateField("Start", dbDate) and Exporting the data: ![Start] = task.Start This works fine, but I am having difficulty...

Of Course. Fixed the code to read Task.Text1 and it works as designed. Cheers

I am copying Project 2002 data accross to Excel. These work without any problems. xlCol = (Asgn.Start) xlCol = (Asgn.Work) Can someone explain why I can't get (Asgn.Text1) to copy Text1 contents accross? What's the fix? In Step mode,Text1 shows contents as "". Yes - Text1 does contain...

Has someone got an answer to making the Gantts in PS, in particular CNS47, presentable. I need to change font sizes and the calendar bar at a 'user' level, or do I have to set it up in Configuration? I need User type functionality similar to MS Project etc. and I can not find literature to assist.