Re: Creating a new MS Project file from Access

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Google knows everything!
for example here some sample code:
http://www.mcse.ms/archive184-2005-5-1611019.html

--
Alex Dybenko (MVP)
http://Alex.Dybenko.com
http://www.PointLtd.com


"JRB" <JRB@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:6CF329BA-9F72-4909-9C3C-4A9C96B31833@xxxxxxxxxxxxxxxx
> Hoping someone can help me out here. I've developed an Access database to
> help manage property development projects. The clients have since decided
> that they would like to tie the database in with MS project, which they
> are
> currently using to manage the scheduling for these projects. I understand
> that I can save an MS Project file as an Access database and then link
> that
> data to the data in my database file. I'd like the user to be able to
> create
> a new project record in my Access database and then have it automatically
> create the new project file in MS Project and subsequently save that new
> file
> to the Access database that contains their other MS Project projects.
>
> I've referenced the MS Project Object Library in my Access database, but
> am
> unsure as to how to proceed. I can't seem to find any documentation on
> the
> relative commands, etc.
>
> Can anyone give me the proper code to create a new project in MS Project
> from MS Access??
>
> Any help would be greatly appreciated!
>
> Janelle


.

Relevant Pages

  • RE: Creating a new MS Project file from Access
    ... Dim prjPrj As MSProject.Project ... Set appPrjApp = CreateObject ... I've developed an Access database to ... > create the new project file in MS Project and subsequently save that new file ...
    (microsoft.public.access.modulesdaovba)
  • Re: Work field values change when exporting to Access
    ... Microsoft Project Most Valuable Professional ... > Project file number work record 40697 hrs. ... > Access database task_work record 2441820000 ...
    (microsoft.public.project)
  • RE: Default File Format
    ... Open a Microsoft Access file (Microsoft Access file: An Access database or ... A project file doesn't contain data and is used to connect to ... Under Default File Format, click the Access file format you want. ...
    (microsoft.public.office.setup)
  • Creating a new MS Project file from Access
    ... I've developed an Access database to ... help manage property development projects. ... The clients have since decided ... create the new project file in MS Project and subsequently save that new file ...
    (microsoft.public.access.modulesdaovba)
  • Re: ADO conditional insert, update, or delete
    ... I have a multi-dimensional array and an Access database. ... Two saved queries are all ... running Access, and if so, can you provide sample code? ...
    (microsoft.public.scripting.vbscript)