Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: DAVEKELLY
  • Content: Threads
  • Order by date
  1. DAVEKELLY

    Project Definition - Creation Date (PS)

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

    Align Chart Axis

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

    Cross Tab MS Jet * does not * etc

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

    Exporting resource data to Access

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

    xlCol = (Asgn.Text1) Not Copying Contents

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

    Project Systems - making gantts presentable.

    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.

Part and Inventory Search

Back
Top