![]() ![]() But when I switch to the 'old' code I was using before it works completely fine so it has to do with the find method not working properly.ĭo you have any idea of what's wrong in the code? I can't find a solution and the find method is crucial in my macro. As a reminder, I suggest you focus your time creating projects in the following five categories: Ingest a CSV, Create a Table Use JOINS to Build a New Table Create View (s) Write a SQL Script. This article will cover 15 SQL project ideas for beginners, as shown in the list below. When I run the macro it doesn't pop any error, it just does nothing. SelectTaskField Row:=0, Column:="duration", Width:=2 You can choose a project for the new task folder and add a new unique name. TaskSucc.LinkPredecessors Tasks:=TaskPred, Link:=pjFinishToStart Create folder can also be from the context menu Database Tasks View. If Application.Find("Name", "equals", rst.Fields("Milestone"), False) Then The SSIS packages are run in SQL Server Data Tools SSDT they use SSIS runtime in the development machine. It refers to the logic that allows a package to run. AND projectcostdistributionpeo.TASKID NVL(LINK.projelementid, projectcostdistributionpeo.TASKID) AND pet.expendituretypename IN (‘Professional Labor’, ‘Contract Professional Labor’)) AND expenditureitempeo.projectid ppa.projectid) AS TotalHoursActualITD, link. SQL Server Integration Services: SSIS Runtime Engine. SetTaskField Field:="Task Type", Value:=rst.Fields("Task_Type") A Solution refers to the logical grouping of related projects. While rst.EOF True And rst.BOF True SetTaskField Field:="Name", Value:=rst.Fields("Task_Name") I've researched and I need the find method in order to get the results I want, so I changed my code and I got to this so far: For now I've made use of ActiveProject.Tasks to set the tasks I need in order to make the LinkPredecessors method work, but I've found that it doesn't perfectly fit with what I need. Figure 3 Creating tables in the data tier application In the New Item pane, select Tables and then provide a name to the table. Alternatively, you can also select New Item from the drop-down and then select Tables from the list. I need to make use of the LinkPredecessors method in order to automatically establish main tasks and its predecessors in MS Project. Right-click on the Tables directory, select Add and then select Tables. ![]()
0 Comments
Leave a Reply. |