March 12th, 2010
I am looking for detailed guidance on creating an interface in
Microsoft Access to link to Microsoft Project using Visual Basic for
Applications in Access. I want to be able to enter data on an Access
Form and have that data appear formatted correctly in Microsoft
Project. My goal is to provide an interface between access and
project. I would like to be able to enter in data into an Access form
for the following Microsoft Project fields and have the data appear
correctly formatted in Project; the project fields are: Task Name,
Start, Duration, Actual Start, Finish, Actual Finish, Resource Names,
Predecessors, and Percent complete. Your help is very much
appreciated.1. The program does not necessarily need to store the data values
within Access, just pass the data to Project in the correct format. I
chose the Access interface for two reasons: 1) this program will be
part of an already existing database that stores links to project
documentation. 2) Access VBA is the Object Model I am most familiar
with, I thought maybe the necessary data could be collected in either
an Access form or a series of input boxes.
2. The program would be used anytime this button within Access is
clicked. So, potentionally it could be used on an existing Project or
a new one depending on the circumstances. There is a variable assigned
to the Project file name, so that is how I would determine which
Project file is to be used. The program needs to be able to manipulate
existing project tasks/information. So, if the data needs to be stored
in Access that is fine.1. Does the program need to store the data in Access, or just pass it
through to Project? If not stored in Access, why an Access interface?
2. Will the program be using a new or existing Project? If using an
existing Project, how will the correct project file be determined? If
using an existing project, will the entries only be new ones, or will
the program have to work with existing parent/child tasks?#If you have any other info about this subject , Please add it free.# |
|
Posted in dballastages.com | edit