parameter value in Update query

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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.
 
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;
 
Back
Top