Trouble with autonumber field in a query

  • Thread starter Thread starter Opal
  • Start date Start date
O

Opal

I am running Access 2003 and am trying to create a query with an
autonumber field. I have two tables in the query each with 7 fields.
I have 3 of the fields linked because I only want to see the values in
the query if these 3 fields are equal between the two tables. I was
trying to utilize an example I saw on:

http://www.lebans.com/rownumber.htm

To help me create an autonumber field in the query, but I get an error
message that tells me

"Undefined function 'Serialize' in expression"

Is this because this orignal database from www.lebans.com uses an
older version of
Access and "Serialize" is not a function in Access 2003?

Can anyone help be create a query with an autonumber field? Thank you.
 
Hello "Opal".

Opal said:
I am running Access 2003 and am trying to create a query with
an autonumber field. I have two tables in the query each with
7 fields. I have 3 of the fields linked because I only want to
see the values in the query if these 3 fields are equal between
the two tables. I was trying to utilize an example I saw on:

http://www.lebans.com/rownumber.htm

To help me create an autonumber field in the query, but I get an
error message that tells me

"Undefined function 'Serialize' in expression"

Is this because this orignal database from www.lebans.com uses an
older version of
Access and "Serialize" is not a function in Access 2003?
Click to expand...

No, I don't think so. It is because the "Serialize" function is not
found in your database. Copy the code of the function to a sandard
module in your database.
 
Is this because this orignal database from www.lebans.com uses an
older version of
Access and "Serialize" is not a function in Access 2003?
Click to expand...

Serialize is evidently a custom function, probably from Lebans' database. It
is not and never has been a builtin function in Access.

John W. Vinson [MVP]
 
Hello "Opal".









No, I don't think so. It is because the "Serialize" function is not
. Copy the code of the function to a sandard
module in your database.

--
Regards,
Wolfgang- Hide quoted text -

- Show quoted text -
Click to expand...

Thank you Wolfgang....I missed that. Now it recognizes the function,
but the numbers
will not increment. I will keep researching.
 
Back
Top