Replies

This post has been moved to Non-Outlook email as it should get a response there.

Mike,

The issue you may be having is opening the plans back and forth between 2003 and 2007. If you create the plan in 2007 and then attempt to open it in 2003 (even if you save it to a 2003 file), odds are the visual basic library will be incompatible with the one in 2003 and causes a visual basic error.

Assuming the visual basic editor is installed on all of the machines, when you open the plan, press Alt F11, then select tools, references, and see if it indicates that any libraries are missing. If so, scroll down through the list and select the latest MS Project Library and it should work.

I would also try saving the 2007 schedule as a 2003 file first and see if that helps with the people using 2003.

Something else you may want to do is try compiling the code in the VB editor to make sure there are not any errors.

There are a lot of issues that could be causing this. Post back if this does not help.

Increasing the Max Locks may work, however, you say you are joining three tables and there is a calculated field. If you remove the calculated field, does the query joining the tables work? One of two things may be happening. One – The calculated field has a null value or produces an error such as divide by zero that is interfering with the joins or Two – You managed to produce a cartesian product and are getting too many results.

My suggestion is to first try the queries without the calculated field to see if the joins work. If not, then try running the query by joining only two of the three tables to see where the issue is occurring.

What are the join types, Inner, Outer, or other? HTH

When creating a form in access, there is the ability to create tabs on the form to better organize what the user is viewing. However, I am not sure this is what you are looking for.

When using excel, users typically try to group like sets of data in tabs. This can be done by grouping by fields in a query and displaying the results. HTH – but I am not sure this answers your question.

Please follow Stuarts suggestion and post the error message. Recently, my teenage son was on our computer and received a message that a virus was detected on the computer. A pop up then appeared that said press this button to remove the virus. All I can say is that it took me many, many (did I say many) hours to clean up the machine from all of the junk it loaded after he pressed the button. It also went to some very lovely internet sites when you opened an internet connection. My son has promised to call me the next time this happens. It is a shame that so many will fall for this and press the button to remove the virus. What my son did not know is that the system is virus scanned every day when nobody is using the machine. Anyway, I would follow Stuarts advice and post your error message for review.

Several groups of employees are using Visio to create work flow diagrams and then using these diagrams to store the dates when a task or tasks are complete.

They have asked me if there is a way to use these dates to generate reports or metrics that track the number of days that have expired between tasks.

I am not a visio expert so am wondering if anyone knows if Visio has the capability to store data and then create metrics on the data or would the data need to be extracted to a different application such as access or excel to generate metrics. I would prefer access.

If Visio does have this capability, how is the data stored? In tables or text fields linked to the cell? Any insight on this would be appreciated. In the meantime, I will start researching this. Thanks.

I am going to answer my own question after doing some research. According to microsoft, Automation and VB can be used to get the data from Visio to another application such as a database to store and query the data. In visio, using VB, the objects can be looped through and the data for each object such as name and data can be stored as an array each time the visio form closes. Another system such as access can then use VB Automation to connect to Visio and extract the data. It is a little more complicated then this but this is the general idea. The following link helped a bit. Visio Automation Link

Is there any way in Project to show the tasks at the start of the project and the ending tasks on the Gantt, but drop out the middle? We have a three year project. The first year is planning and development. The second year is basically one task. The last year completes the long task and has several milestones. We would like to drop that second year from the Gantt to get the printout to one page. Shrinking to one page makes the result too small to read.

Is there a way in Project to do this? Or does someone have a workaround?

Now that I think about it, if you input the Text Field and changed the Name to Year. You could input Year 1, Year 2, … Year N in the value of the text fields so that when you want to print a particular year, you could then just filter or the Year you input. So in the filter, if you wanted to print Year 1, 3 and 5 you could set the filter to where the text field is Year 1 or Year 3 or Year 5. This would give you greater flexibility in getting the years you want. HTH

Is there any way in Project to show the tasks at the start of the project and the ending tasks on the Gantt, but drop out the middle? We have a three year project. The first year is planning and development. The second year is basically one task. The last year completes the long task and has several milestones. We would like to drop that second year from the Gantt to get the printout to one page. Shrinking to one page makes the result too small to read.

Is there a way in Project to do this? Or does someone have a workaround?

The brute force method to do this that will work in any version of Project is to insert a Text Field in your Gantt View. For this example, insert Text6. You could then go to each row in the Gantt and insert a variable such as a 1 in the Text6 field you inserted for all rows you want to print. Then create a filter based on Text6 = 1. Open the filter you just created that just shows the rows where Text6 = 1 and you can then print preview / print the selection. This is not the most elegant method but it will work. HTH.

Did you ever figure out how to correct the Visio issue? If so, could you please post your solution so others can benefit? Thanks.

Wes,

I have not used MS Project 2000 in a long time and do not have the software anymore to test against. I do not recall any issues with Hyperlinks nor could I find any old references or issues when researching it. Sorry, but I am unable to assist. Anyone else have any suggestions?

Silverback,

Are the databases being opened in the same operating system that they were designed in? You might want to check to make sure your VB references are still valid. Are you able to debug in VB without receiving errors? Is the db in question a standalone database on a particular machine or setup as a front end and back end on a network? If on a particular machine, I would try it on a different machine. Just my 2 cents here. HTH.

Said,

I am not sure what your issue is.

If the task is greyed out, then you probably have a parent task with children and the start date would be calculated based on the earliest child start date and lastest child finish end date. Take a look at the children tasks linked to the parent to see what is causing this.

By the way, are you using 2003 or 2007?

Gary

From what I remember, you cant shade the tasks to make it stand out. (Not sure about 2007) Other then changing the fonts and font color, you could use graphical indicators.

Try looking at the following post and answers, post 302674 , or search on shading or graphical indicators.

HTH

Please check to make sure all of your service packs are installed. If they are, then try uninstalling and re-installing the software. Post back if you still have problems.

Are you running the application on a stand alone computer, network, etc? What operating system are you using?

One last thing to check – in your report, query, or datasource for the report, make sure you are using the data field for PainID and not PainID.value.