Importing Access forms into Project

[wadical]

Hello,

Here is what I did:
a) Saved an MSProject .mpp as an Access .mdb file.
b) In the .mdb, created new tables for Issues, Risks and Contact_Information
c) In the .mdb, created Forms for data entry and editing forthe Issues,
Risks and Contact_information

What I want to do is:
a) Use these forms (and the underlying new tables) when I open the project
back in MS Project
b) Create a toolbar in MSProject toe open and use these forms

Thanks.

 

[Earl Lewis]

You can probably find a way to open the Access forms from within project but I don't think it's worth the effort. The forms wouldn't really be running "inside" project anyway. This would require you to create an Access OLE object and run the Access app regardless.

Why don't you create the forms in project and simply create a connection to the Access database where you can read/write the data? This would be a more typical approach to this kind of problem. I know you've probably invested considerable time in the Access forms but I don't think what you want to do is viable.

Also, as far as I know there's no mechanism in Access that allows you to export the form.

Earl
Hello,

Here is what I did:
a) Saved an MSProject .mpp as an Access .mdb file.
b) In the .mdb, created new tables for Issues, Risks and Contact_Information
c) In the .mdb, created Forms for data entry and editing forthe Issues,
Risks and Contact_information

What I want to do is:
a) Use these forms (and the underlying new tables) when I open the project
back in MS Project
b) Create a toolbar in MSProject toe open and use these forms

Thanks.

 

[wadical]

Thank you , Earl.

Do you have a code snippet for this? Or is there someplace I could go to?
Please excuse the 'newbie'-ness.

Regards,
.... wadical.

 

[Earl Lewis]

wadical,

Try this link for ADO OLE DB (ADO = ActiveX Data Objects) syntax.

http://www.able-consulting.com/MDAC/ADO/Connection/OLEDB_Providers.htm#OLEDBProviderForMicrosoftJet

Depending on which data access method you want to use you need to make sure to add the reference to it into your MSProject VBE. Otherwise you'll get unknown object kinds of errors when compiling/running.


Earl
Thank you , Earl.

Do you have a code snippet for this? Or is there someplace I could go to?
Please excuse the 'newbie'-ness.

Regards,
.... wadical.

 

[wadical]

Earl: Once again, thank you.

wadical,

Try this link for ADO OLE DB (ADO = ActiveX Data Objects) syntax.

http://www.able-consulting.com/MDAC/ADO/Connection/OLEDB_Providers.htm#OLEDBProviderForMicrosoftJet

Depending on which data access method you want to use you need to make sure to add the reference to it into your MSProject VBE. Otherwise you'll get unknown object kinds of errors when compiling/running.


Earl

Thank you , Earl.

Do you have a code snippet for this? Or is there someplace I could go to?
Please excuse the 'newbie'-ness.

Regards,
.... wadical.