parameter value in Update query

[Guest]

I have an update query but the error message keeps staing I have a Parameter
value error.

states: dbo_tblproduct.AvailableOnline then has a box for a parameter. IT IS
NOT SET UP FOR A PARAMETER! Any ideas on this one?

 

[Guest]

Pot your SQL statement.

 

[Guest]

If you are getting a prompt for a parameter, when you do not expect one, it's
probably because you have mis-spelled the name of a column or table in your
query. Since Access can't find the column/table, it prompts you for the value.

First thing, check your spelling and make sure you have it right.

Second thing, if it's right, post your SQL so we can see it.

 

[Guest]

Also I get a data type mismatch now in when I run the query. I am just rrying
to update one table from ultiple tables. Here is my SQL

UPDATE dbo_tblSaaDocument RIGHT JOIN (dbo_tblObligationType INNER JOIN
(dbo_TblProductVersion INNER JOIN (DEV_dbo_TblProduct INNER JOIN
dbo_TblProduct ON DEV_dbo_TblProduct.ProductId = dbo_TblProduct.ProductId) ON
dbo_TblProductVersion.ProductId = dbo_TblProduct.ProductId) ON
dbo_tblObligationType.ObligationTypeID = dbo_TblProduct.ObligationTypeID) ON
dbo_tblSaaDocument.SaaDocumentID = dbo_tblObligationType.SaaDocumentID SET
DEV_dbo_TblProduct.ProductId = [dbo_tblProduct].[ProductId],
DEV_dbo_TblProduct.AvailableOnline = [dbo_tblProduct].[Available Online],
DEV_dbo_TblProduct.EAndOFlag =
IIf([dbo_tblProductversion].[EAndOFlag]=-1,"Y","N")="[DEV_dbo_TblProduct].[EAndOFlag])",
DEV_dbo_TblProduct.Countersignatures =
IIf([dbo_tblProductversion].[Countersignatures]=-1,"Y","N")="[DEV_dbo_TblProduct].[Countersignatures]",
DEV_dbo_TblProduct.Attachments =
IIf([dbo_tblProductversion].[Attachments]=-1,"Y","N")="[DEV_dbo_TblProduct].[Attachments]",
DEV_dbo_TblProduct.StateAbbr = [dbo_TblProduct]![StateAbbr],
DEV_dbo_TblProduct.BondAmtMin = [dbo_TblProductVersion]![BondAmtMin],
DEV_dbo_TblProduct.ProductLine = [dbo_tblObligationType]![ProductLine],
DEV_dbo_TblProduct.BondAmtStd = [dbo_TblProductVersion]![BondAmtStd],
DEV_dbo_TblProduct.BondAmtMax = [dbo_TblProductVersion]![BondAmtMax],
DEV_dbo_TblProduct.BondType = [dbo_tblObligationType]![BondType],
DEV_dbo_TblProduct.BondTermMonths = [dbo_TblProductVersion]![BondTermMonths],
DEV_dbo_TblProduct.CancelDays = [dbo_TblProductVersion]![CancelDays],
DEV_dbo_TblProduct.ObligationTypeID = [dbo_TblProduct]![ObligationTypeID],
DEV_dbo_TblProduct.CategoryId = [dbo_tblObligationType]![CategoryID],
DEV_dbo_TblProduct.BondExpirationDate =
[dbo_TblProductVersion]![BondExpirationDate],
DEV_dbo_TblProduct.MinCreditScore = [dbo_TblProductVersion]![MinCreditScore],
DEV_dbo_TblProduct.BondEffectiveDate =
[dbo_TblProductVersion]![BondEffectiveDate], DEV_dbo_TblProduct.ClassCode =
[dbo_tblSaaDocument]![ClassCode], DEV_dbo_TblProduct.RiskType =
[dbo_TblProductVersion]![RiskType], DEV_dbo_TblProduct.RateType =
[dbo_TblProductVersion]![RateType], DEV_dbo_TblProduct.RenewalMethod =
[dbo_TblProductVersion]![RenewalMethod], DEV_dbo_TblProduct.RateCode =
[dbo_TblProductVersion]![RateCode],
DEV_dbo_TblProduct.BondObligationDescription =
[dbo_TblProduct]![BondObligationDescription], DEV_dbo_TblProduct.ObligeeId =
[dbo_TblProduct]![ObligeeID], DEV_dbo_TblProduct.SpecialInstructions =
[dbo_TblProductVersion]![SpecialInstructions], DEV_dbo_TblProduct.Description
= [dbo_tblProductVersion].[Description], DEV_dbo_TblProduct.FormId =
[dbo_tblProductVersion].[NewBusinessFormId]
WHERE (((DEV_dbo_TblProduct.ProductId)<>([dbo_tblProduct].[ProductId]))) OR
(((DEV_dbo_TblProduct.AvailableOnline)<>([dbo_tblProduct].[Available
Online])) AND
((DEV_dbo_TblProduct.EAndOFlag)<>([dbo_tblProductVersion].[EAndOFlag])) AND
((DEV_dbo_TblProduct.Countersignatures)<>([dbo_tblProductVersion].[Countersignatures]))
AND
((DEV_dbo_TblProduct.Attachments)<>([dbo_tblProductVersion].[Attachments]))
AND ((DEV_dbo_TblProduct.StateAbbr)<>[dbo_tblProduct].[StateAbbr]) AND
((DEV_dbo_TblProduct.BondAmtMin)<>[dbo_TblProductVersion].[BondAmtMin]) AND
((DEV_dbo_TblProduct.ProductLine) Not Like
[dbo_tblObligationType].[ProductLine]) AND
((DEV_dbo_TblProduct.BondAmtStd)<>[dbo_TblProductVersion].[BondAmtStd]) AND
((DEV_dbo_TblProduct.BondAmtMax)<>[dbo_TblProductVersion].[BondAmtmax]) AND
((DEV_dbo_TblProduct.BondType) Not Like [dbo_tblObligationType].[BondType])
AND
((DEV_dbo_TblProduct.BondTermMonths)<>[dbo_TblProductVersion].[BondTermMonths])
AND ((DEV_dbo_TblProduct.CancelDays)<>[dbo_TblProductVersion].[CancelDays])
AND
((DEV_dbo_TblProduct.ObligationTypeID)<>[dbo_TblProduct].[ObligationTypeID])
AND ((DEV_dbo_TblProduct.CategoryId) Not Like
[dbo_tblObligationType].[CategoryID]) AND
((DEV_dbo_TblProduct.BondExpirationDate)<>[dbo_TblProductVersion].[BondExpirationDate])
AND
((DEV_dbo_TblProduct.MinCreditScore)<>[dbo_TblProductVersion].[MinCreditScore])
AND
((DEV_dbo_TblProduct.BondEffectiveDate)<>[dbo_TblProductVersion].[BondEffectiveDate])
AND ((DEV_dbo_TblProduct.ClassCode)<>[dbo_tblSaaDocument].[ClassCode]) AND
((DEV_dbo_TblProduct.RiskType)<>[dbo_TblProductVersion].[RiskType]) AND
((DEV_dbo_TblProduct.RateType)<>[dbo_TblProductVersion].[RateType]) AND
((DEV_dbo_TblProduct.RenewalMethod)<>[dbo_TblProductVersion].[RenewalMethod])
AND ((DEV_dbo_TblProduct.RateCode)<>[dbo_TblProductVersion].[RateCode]) AND
((DEV_dbo_TblProduct.BondObligationDescription)<>[dbo_TblProduct].[BondObligationDescription])
AND ((DEV_dbo_TblProduct.ObligeeId)<>[dbo_TblProduct].[ObligeeId]) AND
((DEV_dbo_TblProduct.SpecialInstructions)<>[dbo_TblProductVersion].[SpecialInstructions])
AND ((DEV_dbo_TblProduct.Description)<>[dbo_TblProductVersion].[Description])
AND
((DEV_dbo_TblProduct.FormId)<>[dbo_TblProductVersion].[NewBusinessFormId]))
WITH OWNERACCESS OPTION;