Share via

GUID location

Anonymous
2020-12-12T15:46:32+00:00

I have an existing query that will not recognize new calculation expression and answers with "Malformed GUID Constant".  Where or how do I fix this issue.

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Tom van Stiphout 40,211 Reputation points MVP Volunteer Moderator
2020-12-13T22:17:53+00:00

> , Nz([ 21BIWKCHG ])+Nz([ 21BIMTHCHG ]) AS 21WKCHG

That is wrong: there should not be spaces around the field names. Should be:

, Nz([21BIWKCHG])+Nz([21BIMTHCHG]) AS 21WKCHG

Was this answer helpful?

1 person found this answer helpful.
0 comments

11 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2020-12-12T17:48:23+00:00

    Thank you or taking the time to reply.  No, I am not.  This query operates in the background to a form which allows client updating, pricing changes etc and the basic tables are updated annually.  The query works as designed in the current year but when adding a new calculated field it allows the field in the related table and the query.  Activating the query produces a parameter value question and then a "malformed GUID constant" error.

    I am not a computer expert but designed this 15 years ago and have stumbled along annually to update the form and related tables, query's over the years annually.  First time I have experienced this problem. 

    Lee

    Was this answer helpful?

    0 comments
  2. Anonymous
    2020-12-12T17:46:55+00:00

    Thank you or taking the time to reply.  No, I am not.  This query operates in the background to a form which allows client updating, pricing changes etc and the basic tables are updated annually.  The query works as designed in the current year but when adding a new calculated field it allows the field in the related table and the query.  Activating the query produces a parameter value question and then a "malformed GUID constant" error.

    I am not a computer expert but designed this 15 years ago and have stumbled along annually to update the form and related tables, query's over the years annually.  First time I have experienced this problem. 

    Lee

    Was this answer helpful?

    0 comments
  3. Tom van Stiphout 40,211 Reputation points MVP Volunteer Moderator
    2020-12-12T17:22:23+00:00

    Are you familiar with Application.StringFromGuid and GuidFromString?

    Was this answer helpful?

    0 comments
  4. George Hepworth 22,855 Reputation points Volunteer Moderator
    2020-12-12T17:19:11+00:00

    My first thought is that you should find the GUID constant in your query and change it so it is properly formed.

    That said, a few other questions inevitably come up. Such as, are you actually trying to use a GUID in this query? Is there VBA code somewhere in the accdb which is setting a constant value for a GUID? Or maybe there's something else entirely that you haven't yet disclosed?

    Was this answer helpful?

    0 comments