linking to MS Project from MS Access (1 Viewer)

[dapiaoen]

AHA!

I downloaded Mr Moe's zip. It appears he is working with Access 97 and I gave him ADO code. Ah, well.

 

[mr moe]

Scott,
One questoin regarding this. I got it to work perfect, but do u think there is a way to link only particular table view.

Thanks.

 

[scottfarcus]

Not sure I understand the question...

 

[mr moe]

Well thats fine, but I meant to ask is there a way that you could link ms access to a particular table view. Like you know in Ms Project you can create your own table view which will be for example filtered by something........ Thanks. I know that this is a confusing question but please forgive me , I did my best to explain the situation. Talk to you later.

bye.

 

[WayneRyan]

mr moe,

All you have to do is find a MS Project view that you like.

Get the names of the Project Objects that provide the information.

Add the new fields to your Access table.

Mod your code to add the new fields for each task.

Wayne

 

[mr moe]

Scott Any suggestions

Hey Scott,
Sorry to ask this question so late. I know we have covered this long time ago. One question, I'm trying to link a field with the name % Complete, I get a synatx error, I put the name iin brackets but then it doesn't work. Any suggestions? Thanks.

 

[scottfarcus]

Moe,

Not sure I can help.

You may have to change the field name.

For future reference, use the following as a guideline for creating fields and other objects in your databases...

Access Naming Conventions

Note: No spaces (use underscore to separate words) AND Avoid !@#$%^&*() characters.