Barton_Day
asked on
Code Charge and MS Access
I am using a code generating tool called code charge. I am using the builder to update a Access Database table.
I have two labels pulling data from another table but those ID are also in the table that I am updating. I do not want to combine the two tables because I will have to modify it later.
UPDATE tbl_ActivityPaths
SET tbl_ActivityPaths.path='{p ath}'
WHERE tbl_ActivityPaths.id = {identify}
When I run this query I receive the following error message...
Malformed GUID. in query expression 'tbl_ActivityPaths.id = {identify}'. (Microsoft JET Database Engine)
Any thoughts would be appreciated...
Thanks,
Bart
I have two labels pulling data from another table but those ID are also in the table that I am updating. I do not want to combine the two tables because I will have to modify it later.
UPDATE tbl_ActivityPaths
SET tbl_ActivityPaths.path='{p
WHERE tbl_ActivityPaths.id = {identify}
When I run this query I receive the following error message...
Malformed GUID. in query expression 'tbl_ActivityPaths.id = {identify}'. (Microsoft JET Database Engine)
Any thoughts would be appreciated...
Thanks,
Bart
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Bart