Third ? for Rod Gill re: VBA Programming for Office Project book

A

andy.novak

Rod,

I went through pages 446 - 449 and made the necessary changes to your
Module 29 code to be compatible with MS Project Server 2007.

However, when I ran the Excel report I received the following error:

"Run-time error Operand clash: uniqueidentifier is incompatible with
tinyint"

Going into debug mode, the cursor is sitting on the "rs.Open Sql,
Conn" statement of the "GetData" Subroutine

Please help. I'm guessing it might have something to do with using
ProjectUID instead of PROJ_ID.

Do I need to change the datatype of the "ProjID" attribute? Not sure
really what to do.

Also, any reason your second connection string in UpdateReport() is
using (local) for the data source and "MPSsampledatabase"?

Thanks,
Andy Novak
UNT
 
R

Rod Gill

Hi Andy,

In the Project Server database, there are Project GUIDs which are 30 odd
characters of alphanumeric data. Then there are Ids such as the row number
in the Gantt chart and UniqueIDs that you also get in Project. It could be a
mix up between them. Email me at vba AT project-systems DOT co DOT nz with
your code and I'll have a look at it.

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com
 
A

andy.novak

Hi Andy,

In the Project Server database, there are Project GUIDs which are 30 odd
characters of alphanumeric data. Then there are Ids such as the row number
in the Gantt chart and UniqueIDs that you also get in Project. It could be a
mix up between them. Email me at vba AT project-systems DOT co DOT nz with
your code and I'll have a look at it.

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:http://www.projectvbabook.com
Click to expand...

Rod, did you get my email? Look forward to hearing back from you.
 
R

Rod Gill

Yes I did and I replied. Only problem is that I'm working 12 hours a day at
the moment and I live in New Zealand with a big time difference with the US,
so there will be delays!

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com



Hi Andy,

In the Project Server database, there are Project GUIDs which are 30 odd
characters of alphanumeric data. Then there are Ids such as the row number
in the Gantt chart and UniqueIDs that you also get in Project. It could be
a
mix up between them. Email me at vba AT project-systems DOT co DOT nz with
your code and I'll have a look at it.

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:http://www.projectvbabook.com
Click to expand...

Rod, did you get my email? Look forward to hearing back from you.
 
A

andy.novak

Yes I did and I replied. Only problem is that I'm working 12 hours a day at
the moment and I live in New Zealand with a big time difference with the US,
so there will be delays!

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:http://www.projectvbabook.com







Rod, did you get my email?   Look forward to hearing back from you.
Click to expand...

Alright sir. thank you very much. I'll see if I can find the email.
 
Top