ReplicationID Reference in VBA

[RayMilhon]

I have a linked SQL Server Database that uses a guid as one of the keys in an Access 2010 DB. I need to write a function that takes the guid as a parameter. Runs a query that sums a numeric field and returns that sum to the query. What I can't figure out is how do I set the Parameter Type to ReplicationID? If I import a portion of the table Access defines the field as ReplicationID but when I put ReplicationID in the code it errors?

Public Function Member_Mnths(ByRef PCPKey As ????) As Long


Dim strsql As String, rs As New ADODB.Recordset
strsql = "SELECT Sum(a.CURRMM) AS MM " & _
"FROM dbo_RVS_CAP_MM_HIST a INNER JOIN tbl_HPCODEs ON a.HPCODE = tbl_HPCODEs.HPCODE " & _
"Where a.pcp_keyid = " & PCPKey & " AND CVDate(a.capmonth & " / 1 / " & a.capyear) between #" & _
DateAdd("m", -7, CVDate(Month(Now()) & "/01/" & Year(Now()))) & "# AND #" & DateAdd("d", -1, DataAdd("m", -1, CVDate(Month(Now()) & "/01/" & Year(Now())))) & _
"# "
rs.Open strsql, CurrentProject.Connection, adOpenForwardOnly, adLockReadOnly
If rs.EOF Then Member_Mnths = 0 Else Member_Mnths = rs!MM
rs.Close
Set rs = Nothing


End Function

[Estuardo]

G'd evening Ray,
First of. Please don't use GUI's for any of your programming needs. As you notice it is (in our ms-sql/access world) just for replication. As a rule of thumb don't use them, let the db engines do.
That being said. What you're looking at is not the "real" value, what you see is the canonical value and it will change as soon as you change any row. You should not manipulate that value. if you really need to see i'll dare to say that you may try with the access functions StringFromGUID and GUIDFromString. Once again i'm not sure if this will help.
If you can, add a natural key or any other key to your tables to make easier the data manipulation.
G'd luck

[RayMilhon]

Unfortunately there are no local tables. This particular Access Database is used for Reporting from a SQL Server Database.

The Report does several calculations and one of the divisors in the calculation is member months. This function is to return the number of Member Months for a 6 month period. The full calculation is (a/pcpmembermonths) * ( reporting period in days /365 ) * 1000 (although I can never remember off the top of my head if its reporting period in days/365 or the other way around.) I have the formula on my desk so I don't have to remember it but I'm not at work today.

Since the report is for a specific PCP I have to use the PCP Key Id to get only the member months assigned to that PCP.

I'll try that stringfromguid and guidfromstring. I knew about the stringfromguid but not the guidfromstring which is why mine kept failing. Thanks.