Export to Access

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Project
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - Enterprise Customer Fields Why is it that when I enter the following formula, found in the Server 2003 Application Configuration Guide, I get an error on any schedule that doesn't have a baseline set. I would expect to get a "No baseline" message returned instead I get a #Error. Switch(Len(CStr([Baseline Finish]))<3,"No baseline",Projdatediff(Baseline finish],[Finish])/480>=5,"Late by more than 5 days",ProjDateDiff([Baseline Finish],[Finish])/480>0,"late",True,"On Schedule") Tag: Export to Access Tag: 92742
  - 2
    - Unable to create an xml file in Project 2003 I am trying to create an xml file from Project 2003 using the visual basic editor. I copied the code supplied for project 2002 from microsoft but there's an "Automation error" for the "FileSaveAs" command, app.FileSaveAs FormatID:="MSProject.XMLDOM", XMLName:=XMLdoc. The code that I am using is pasted below, can someone figure out why this error message is popping up??? Also, is there an easier way to grab certain reports (critical tasks, completed tasks, etc) from Project 2003 and put it on an html page?? Dim app As New MSProject.Application Dim htmlFile As String, xsltFile As String Dim XMLdoc As Object, XSLdoc As Object 'Create an XML DOM document and save the project to it. Set XMLdoc = CreateObject("MSXML2.DOMdocument") XMLdoc.async = False app.FileSaveAs FormatID:="MSProject.XMLDOM", XMLName:=XMLdoc Tag: Export to Access Tag: 92741
  - 3
    - MS Project formatting question In MS Project, can I format text in cells to display at the bottom of the cell? Tag: Export to Access Tag: 92736
  - 4
    - Date Range Report For my project, I select the filter: Date Range, to show me everything between 10/24 thru 11/11. There is one task that has a start date of 11/11 and falls on this date range report. Is this filter designed to pick up end dates that are the same as the start date? Tag: Export to Access Tag: 92735
  - 5
    - unit hours How do I get rid of the "h" that appears in every cell? Tag: Export to Access Tag: 92734
  - 6
    - Reminders in Outlook Hi, I have followed the instructions for creating reminders for Project tasks in Outlook i.e. select tasks - tools - workgroup. However, in the tools drop down menu I do not have workgroup listed. I have gone into customise toolbar and added the set reminders button to my toolbar. However, this is greyed out and I cannot use it. Does anyone have any ideas where I am going wrong? Thanks. Tag: Export to Access Tag: 92732
  - 7
    - Project-changes to baseline work should update totals I want to be able to make changes to baseline work and have all of the appropriate totals re-calculated. Using Microsoft Project 2003. Help in this version clearly states that although the baseline work field value can be changed, the totals will not be re-calculated and they are not. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/community/en-us/default.mspx?mid=79baceb8-b6d1-4d3b-b9af-bc41ecb701e2&dg=microsoft.public.project Tag: Export to Access Tag: 92730
  - 8
    - Turn off Column Resizing on Reports When running standard reports in MS Project (Who does what), the Task Name column resizes to the size of the text in that column. How do I fix this column to not resize? -- Larry Tag: Export to Access Tag: 92722
  - 9
    - Cannot open project files - Doesn't anyone have a solution? I am using Project 2003 Pro SP2. I have a bout a dozen inserted projects using a common resource pool. Yesterday whe I was shutting down (File/Close) for the day Project prompted me to save the individual inserted projects as normal and I selectected "Yes To All" as usual. However when the files were done saving the master project did not close. After a couple of tries it finally closed. This morning I came in and opened the master project and it opened normally however two inserted projects (about 200 tasks each) will not open. I get a "File cannot be found" message. So I tried opening them up individually from Project and I get a message that "Project cannot open the file". So I tried opening them from Explorer and get the same "Project cannot open the file" message. I checked with the project manager and he did not have the file open, and no one else did either. I really need to recover this file as it contains actual and accounting information. Is there any way to do this? I have read the replies to folks with the same problem and no one seems to have a solution. I read a posing on "File Bloat", but the solution will not work for me as I cannot open the files at all to be able to save them in the database format. Please help!!! Tag: Export to Access Tag: 92721
  - 10
    - Rate Column Good day all Can anyone shed some light on how to add an extra column in Resource Sheet to give Night Rate in Cost per hour like $20.00/hr. From what i can see there are already two types in Standard rate and Overtime rate but i would like to construct another as Night Rate but i am failing miserably, is it not possible? Thanks Tag: Export to Access Tag: 92719
  - 11
    - Problem starting up Project 2000 - runtime error When I attempt to start up Project 2000, I get the following error msg: Microsoft Visual C++ Runtime error - winproj.exe This application has requested the Runtime to terminate it in an unusual way. When I click the OK button, Project shuts down. I've tried reinstalling Project and reinstalling Office 2000 Pro incase that was linked to it, but this hasn't stopped the problem. Help! Thank you. Tag: Export to Access Tag: 92718
  - 12
    - Help with creating a filter for Notes field - test/value to use to check for presence of content Hello, I would like to create a filter that checks the Notes field and determines if there is any kind of content in the field. Haven't been able to figure out what Test and Value pair to enter. Anyone know how to do this? Tag: Export to Access Tag: 92715
  - 13
    - Remove link lines from tracking gant When using a tracking gant I find that if I go to the chart wizard and remove the link lines from view (so that I can print without them showing) my tracking gant disappears and in fact re-formats sitself into a normal gant chart. This situation is not reversed by switching the lines on again. I then have to go to Format / Bar Styles and reformat all bars, settings and criteria to regain a tracking gant. Has anyone else had this problem and is there a fix? Tag: Export to Access Tag: 92714
  - 14
    - can't get presentation to pack and go office 2000 windows xp does anyone know why I can't get pack and go to pack presentation to D:\ drive as done presentation but just says drive not in use, drive working as tried it with other functions Tag: Export to Access Tag: 92713
  - 15
    - how do i turn on the virus scan protection November 2, 2005 I have Windows XP Program. When I go to Security Center to check for Firewall Protection, Automative Updates, and Virus Protection. Everything is turned on except Virus Protection. I tried turning this on in the Contol Panel but I am unsuccessful. what do I do? Tag: Export to Access Tag: 92708
  - 16
    - Status Indicator doesnt display as Proyect field Hi, I have created a status indicator with this formula> "IIf([Etapa]="AnÃ¡lisis y DefiniciÃ³n" And ([Estatus del Proyecto] ="Detenido" Or [Estatus del Proyecto] ="Cancelado"),"Verde",IIf([Etapa] ="DiseÃ±o" And ([Estatus del Proyecto]="Detenido" or [Estatus del Proyecto]="Cancelado"),"Amarillo", IIf(([Etapa]="Desarrollo" or [Etapa]="Pruebas") And ([Estatus del Proyecto]="Detenido" or [Estatus del Proyecto]="Cancelado"),"Rojo"))) " If I create this in enterprise text field it works, but when I try to create this as Project Enterprise Text Field doesnt work any idea? Thanks in advance -- Pit Tag: Export to Access Tag: 92696
  - 17
    - 20 Hours over 5 days In my schedule there are many more days in my schedule than hours of required work. for example... I've allowed 5 days to complete task 1 but the actual hours required to get the work done is 5. I can't seem to get the duration to ignore the beginning and ending dates as it always reports 40 hours. This is happening throughout my plan, where I allow more days to complete a task and for a particular day may only work on the task for 2 hours. Thanks for any help. Tag: Export to Access Tag: 92695
  - 18
    - need better way to view resource availability over many projects I am working with team members who are working on several different projects. I need a way to view their time against many different projects. Also, all of these projects can't and won't be made into an MS Project document, they are too small to do this. Can you recommend anything? Tag: Export to Access Tag: 92692
  - 19
    - Finsh No Later Than vs. Must Finish On Hi, According to my bible, the following definitions apply Finish No Later Than - A constraint that sets the completion of a task to fall no later than a specific date. Must Finish On - A constraing that forces a task to finish on a specific date. My questions than is - what's the difference between the two? I don't see it but there must be one... thanks much, bethany -- Bethany Schoenick, PMP Tag: Export to Access Tag: 92690
  - 20
    - File Format for importing multiple resources per task I am trying to build a project from another source. I can build the WBS structure and am trying to populate it with resources. There are multiple resources for each task but only one resource is imported for each task. Tag: Export to Access Tag: 92688
  - 21
    - how do i get complete listing of fields and descriptions I was wondering if there was a way to get a complete listing of project fields and custom fields out of projects and into excel Tag: Export to Access Tag: 92686
  - 22
    - Resources as a Percentage How do you total resources as a percentage? Tag: Export to Access Tag: 92684
  - 23
    - Resources as a percentage I've been asked to total resources as a percent by hour by week. Is this possible? Tag: Export to Access Tag: 92683
  - 24
    - totaling resources as a percent Has anyone created a percentage of employees required by hour and by week? Tag: Export to Access Tag: 92682
  - 25
    - Start of a task Is it possible to have Project start a task at the beginning of the day if it is preceded by partial day tasks? I have full day tasks that start in the middle of the day and then finish with a partial day at the end of the task. Tag: Export to Access Tag: 92679
- Next
  - 1
    - MPP shouldn't allow 0d milestones on resource calendar holidays. In MS Project, please do not allow 0d milestones to fall on days marked as holidays in resource calendars. Currently they do... this renders milestones useless as some of the most important project checkpoints fall on days when the office is closed! ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/community/en-us/default.mspx?mid=2eeef5d8-17b4-4018-b5bd-8ed02481614d&dg=microsoft.public.project Tag: Export to Access Tag: 92678
  - 2
    - viewing complete baselines in Project I am working on a project that is completely cost driven. I'm not sure Project is the best place to do this but its what the company wants. They asked that I build a baseline at original, 80% and 100%. In one workbook, the original and baseline were built, and when working on the 2nd workbook, I revised the workbook so its easier to use and view. I'm now wondering if there's a way to view the complete baseline so I may copy it into a different workbook As well, I'd like help with a custom view and/or report. I would need to view about 6 columns from each (baseline, baseline 2 and basline 3) together in one view. When I try to customize the columns required aren't options to pick. Anyone?? Help please? Tag: Export to Access Tag: 92677
  - 3
    - How do I reset the priorities to 1, 2 & 3 We would like to set priorities to 1, 2 & 3. Does anyone know how to change this? Tag: Export to Access Tag: 92676
  - 4
    - Monthly Reports Another question. We have been on this project since July and yesterday the client sent an email wanting us to do this spreadsheet by month to show progress going back to July. I can't seem to get a report out of project that will show budget, actual time, percentage complete, ect by month. When I try to sort by date the July comes out ok but then Aug just add July and Aug numbers. Is there a way to get this information for prior periods of time? Tag: Export to Access Tag: 92668
  - 5
    - Budget, Actual Time, Percentage Completion I have been reading some prior posts but just want to try and clarify. Example: We have entered our budget and have actual time. One of the tasks we have was budgeted for 255 hours and we have 66 hours in it. However, this task is at 100%. We wanted to change the completion percentage to reflect that but when we do it changes the actual hours to the budgeted hours. Is there a way to keep it from doing this? We have to give reports from project to the client to reflect our progress including tasks that are 100% and in progress items, ect. Thanks for any help you can give on this subject. Tag: Export to Access Tag: 92667
  - 6
    - Master project I am breaking a large project down into subprojects. When I publish these projects to the server and delete the original project, will I lose any of the "actuals" information from PWA? Tag: Export to Access Tag: 92664
  - 7
    - Duration, Actual Work and Remaining Work I have set up my base project. example duration is 2 days, Remaining Work is 32hrs for 2 people. The actual Work is 60hrs. Question: How do I show that the hrs went over the estimated hrs? Tag: Export to Access Tag: 92662
  - 8
    - Totalling Resources as a Percentage I need to create a management level summary containing total resources needed by hour by week. The current plan has eash individual resource listed and I haven't located any formula or filter option where I can total these resources. Thank you. Tag: Export to Access Tag: 92659
  - 9
    - Grouping Tasks Some more help needed for a novice new to Project The project I am managing has grown into a large number of individual tasks, and I need to associate each task with the department in the organisation who will take prime responsibility for the task. So, I need to flag each task with the responsible department. Later, I would, for example, want to print the tasks belonging to a selected department, and perhaps divide the main project into one sub-project for each department. Any help would be much appreciated â?? as ever! Jim Jones Botswana Tag: Export to Access Tag: 92655
  - 10
    - Hour control of how else ? I'm trying to enter the hours of which a task starts and finishes, is there any other way to control resources and cost accuratly? Tag: Export to Access Tag: 92654
  - 11
    - print a grapf of material resources demand for all project duration Good evening! Please? help me: How can i print a grapf of material resources demand for all project duration? Thanks Tag: Export to Access Tag: 92653
  - 12
    - Enforce Maximum hours per week constraint Hi, I have 3 resources which may be allocated to other projects, hence i am given only about 5 hours of working time a week from each of them. Is there a way that i may enforce this constraint? I've set the calendar to 5.00 hours in a week but this appears to have no function what so ever. I'd also like to enfore a constraint where-by they may only work up to 2 hours a day. If MS project can't do this, I fear it is largely useless :-( Tag: Export to Access Tag: 92648
  - 13
    - Calendar during overnight working Good Morning or Afternoon as it applies. Could anyone please tell me how to assign duration in the "change working time" part of the calendar to reflect working times that begins at 18:00hrs to 06:00 next morning, meaning that the shift has a duration of 12hrs starting say monday evening 6pm and conclude Tuesday morning 6am. This is necessary as i have a job that is being worked on 5 days a week for several months that has that working pattern. Whenever i assign the times of working it return an error to say that the start time can't be after the comence time, which is clearly not what i was saying olr want to say. Thanks all Tag: Export to Access Tag: 92646
  - 14
    - Flagging Group By Summary's When you use the 'flag' in MS Pro, is it still possible to flag group by summary's? For example if I group by Project, Resource Initials and Outline Code, would I be able to Flag 'Project' or 'Resource Initials'? Or perhaps there is another way? Thank you so much! :) Tag: Export to Access Tag: 92644
  - 15
    - ICT Roadmap I am developing an ICT Roadmap for a large Governement org in Australia, which looks forward 3 years and maps out a range of tasks (each a multi-million project) towards a desired future state. The total gantt chart is a master project made up of 5 sub-projects I want to colour code the three different types of tasks. 1) Approved and funded tasks (typically year 1) 2) Approved but unfunded tasks (typically year 2) 3) Tasks which are not yet approved (typically year 3) A critical path is not required for colour coding purposes I tried to make a single field, with entry 1,2,or 3 in it, but was unable to make that work, either for filtering (I did not perservere) or for bar colouring. I did achieved the goal with a clumsy set of three fields (flag1, flag2, flag3), which have yes/no against each, which can then be used in Bar Types to set colours. I must have 2 no, and 1 yes, which is a manual process, and is subject to change over time as we roll the roadmap forward each year (or quarter) and project status changes. Can anyone suggest a more elegant way of achieving this ? Tag: Export to Access Tag: 92641
  - 16
    - Can not access public documents I'm receiving the following message when I try to access the public documents section of Project Server 2003. ----------------- Microsoft JScript runtime error '800a01a8' Object required /ProjectServer/doclib/DocLibMain.asp, line 154 ----------------- Can someone tell me what I need to do to fix this? I think this started after I entered the public documents area and tried to delete a subdocument folder. Any help is appreciated. Thanks in Advance. Tag: Export to Access Tag: 92633
  - 17
    - Creating a Project with VBA (MS Project 2003 Pro)? We are currently using Peoplesoft Projects and trying to integrate the data in Peoplesoft to MS Project. There seems to be problems with the delivered code and not much help from the Peoplesoft Community. My thought is to use VBA and access the Oracle data thereby creating the project, tasks, start/end dates, etc. I can't find anything anywhere that basically shows this sort of a thing. I would appreciate any help/direction. I have even looked through several books and can't find much on the VBA side of MS Projects. Tag: Export to Access Tag: 92632
  - 18
    - Filter with compare of Cost field and number field In Project 2002 I tried creating a filter that compared a Cost field and a number field. I got a message window stating that couldn't be done. I resorted to doing the equivalent thing with VBA and setting a flag that I could then filter on. Did I miss out on a way of doing this without resorting to VBA? Tag: Export to Access Tag: 92629
  - 19
    - Historic Resource Costs I am not sure if I should be posting here or on the developers discussion group but here goes. I am having some trouble with historic and current resource cost rates. I need both in my project as the project spans multiple fiscal years and salary changes occur between and during fiscal years. We use the project import wizard to update our employee (resource) information. The excel file contains employee name (which become resource name in MSP) and cost rate (which becomes standard rate in MSP) along with some other info like phone #, etc. This file is generated from our corporate server which updates employee rates weekly. We have 75-100 employees. We update the resource portion of the project file quarterly. (This is due to the fact that our salary information for some of our staff can change every 3-4 months). What I would like to do is perform the import from excel using the same file described above, but when I import I would like to be able to set the Effective Date for the resource cost rates equal to the day that I perform the import. Then I would like the cost rate I am importing to be the new standard rate for present and future tasks. As it is now, when I import the data I can either override all of the past employee salary rates (so I get the new cost rates applied to both past and future tasks) or I can keep the employee cost rates the original values entered initially (so the old rate is applied to the present and future tasks). What I want is to be able to tell project â??For all tasks performed in the past keep the employees rates before the import date and for this day and after use the new rate that I am importing.â??. I know I can do this manually by going into the cost tab and typing in the Effective Date and its corresponding rate but for 75+ employees that would be very tedious to do every quarter. Does anyone know if there is a way to do this? I know some basic VBA so if any one has any suggestions or could point me in the right direction I would really appreciate it. TIA! Tag: Export to Access Tag: 92627
  - 20
    - HTML Calendar View Also, is there not way to save as HTML in the calendar view? Thanks, G. Tag: Export to Access Tag: 92622
  - 21
    - HTML Task Views Hey All, I was hoping the HTML output would match my current task view, but, that does not seem to be happening. I was hoping to be able to create my view by collapsing or opening certain regions of the project, then, saving that to HTML. Wouldn't it be cool if it would create a web page where you could have collapsing regiions so it kind of works like the program?? G. Tag: Export to Access Tag: 92620
  - 22
    - How to create a link between a task and a recurring meeting? I have a Board that only meets twice a month (every 1st and 3rd Thursday), so I created a recurring task. However, I do not want my project to come up at every Board meeting. I want my project to be on the agenda of the next available Board meeting after a certain task has been completed. For instance, Task A was scheduled to be on the 11/4 meeting, but the timeframe changed so that Task A is not scheduled to be completed until 11/7. I wanted Task A to be scheduled on the 11/18 meeting, instead of the 11/4 meeting. I tried doing a Finish to Start link between Task A and the Board meetings, and Project scheduled the Board meeting on the day that Task A is scheduled to be completed on (11/7), instead of the next schedule meeting (11/18). In Project, is there a way to tell the calendar to do this? Thanks Tag: Export to Access Tag: 92619
  - 23
    - Find overallocated tasks when resource availability > 100% I am trying to perform manual resource levelling using Microsfot Project 2003. First, I display the resource graph (or resource sheet) to see which resources are overallocated. Next, I display the project as a Gantt chart, then filter using a resource name. Then, on the Resource Management toolbar, I click the "Go to Next Overallocation" button. This works fine for resources whose maximum unit is 100%. It does not find the overallocated tasks for resources whose maximum unit is greater than 100%. To make the example concrete, I have a team whose maximum resource unit is 400% assigned to a series of tasks. I can see from the resource graph that the resource allocation reaches 500% in some periods. But, I cannot use the "Go to Next Overallocation" button to find which tasks contribute to that overallocation. Is there a way to find which tasks cause the overallocation in the case that the resource has a maximum units greater than 100%? --Tracy Tag: Export to Access Tag: 92618
  - 24
    - Why are tasks being assigned to non-working days? I am a Project beginner, so please forgive me if this is elementary. I've set up a simple project with linked tasks, durations and resources. At the beginning I "changed working times" on specific holidays and identified them as non-working days. Those days show up as greyed out on the gantt chart just like weekends, but the system still schedules tasks to complete or begin on those days instead of skipping over them like it does the weekends. What am I doing wrong? Or am I anticipating that the system will do something it does not? Thanks for any insight! Tag: Export to Access Tag: 92616
  - 25
    - PWA back me the home page!!!! Hello!!. In my PWA when I want to always accede to another Link of PWA it returns me to the home page. I apply sevice pack 2 but this not corrigio the problem. Tag: Export to Access Tag: 92615

I need to import MsProject data into an existing Access application to create
specialized custom reports. What is the best way to go about this?

Re: Export to Access by G�rard

Gérard
Wed Nov 02 15:50:32 CST 2005

Hello,

File / Save As... / File Type : Microsoft Access...
HTH

Gérard Ducouret

"JAY-USC" <JAY-USC@discussions.microsoft.com> a écrit dans le message de
news:8C9B60C2-91DC-4842-926D-E75D1F93656F@microsoft.com...
> I need to import MsProject data into an existing Access application to
create
> specialized custom reports. What is the best way to go about this?

Re: Export to Access by John

John
Thu Nov 03 11:56:15 CST 2005

In article <8C9B60C2-91DC-4842-926D-E75D1F93656F@microsoft.com>,
"JAY-USC" <JAY-USC@discussions.microsoft.com> wrote:

> I need to import MsProject data into an existing Access application to create
> specialized custom reports. What is the best way to go about this?

JAY,
Just an adjunct to what Gerard suggested. An export maps works fine for
static data but it will not work for timescaled data. For that there are
basically two choices - either use VBA or and SQL query directly on the
Project database. For information on the Project database structure,
search your hard drive for the following file (or something similar
depending on what version of Project you are using):
projdb.htm

Hope this helps.
John
Project MVP