I have a saved UNION query named
qryAuthsOwnersAddnlOwnersLienholders4OneCar.
Here it is...
SELECT [AddnlOwnrFName] & " " & [AddnlOwnrLName] & " " &
[AddnlOwnrAddr] & " " & [AddnlOwnrCity] & ", " & [AddnlOwnrState] & "
" & [AddnlOwnrZip] & " " & "(" & [AddnlOwnrCounty] & " county) " &
Format$([AddnlOwnrPhone],"(@@@) @@@-@@@@") & " " &
IIf([Corporation]=True,"(corporation)","(person)") AS Item,
tblVehicleJobs.VehicleJobID, "X" AS OLAX, tblAddnlOwnrs.AddnlOwnrID AS
RecID, [AddnlOwnrFName] & " " & [AddnlOwnrLName] AS Recipient,
[AddnlOwnrFName] & " " & [AddnlOwnrLName] & " " & [AddnlOwnrAddr] & "
" & [AddnlOwnrCity] & ", " & [AddnlOwnrState] & " " & [AddnlOwnrZip]
AS NameAddr
FROM tblVehicleJobs INNER JOIN tblAddnlOwnrs ON
tblVehicleJobs.VehicleJobID = tblAddnlOwnrs.VehicleJobID
WHERE tblVehicleJobs.VehicleJobID=GetCurrentVehicleJobID ();
UNION SELECT [LienHolderName] & " " & [LienHolderAddr] & " " &
[LienHolderCity] & ", " & [LienHolderState] & " " & [LienHolderZip] &
" " & "(" & [LHCounty] & " county) " &
Format$([LienHolderPhone],"(@@@) @@@-@@@@") & " (corporation)" AS
Item, tblVehicleJobs.VehicleJobID, "L" AS OLAX,
tblLienHolders.LienHolderID AS RecID, [LienHolderName] AS Recipient,
[LienHolderName] & " " & [LienHolderAddr] & " " & [LienHolderCity] &
", " & [LienHolderState] & " " & [LienHolderZip] AS NameAddr
FROM tblVehicleJobs INNER JOIN tblLienHolders ON
tblVehicleJobs.VehicleJobID = tblLienHolders.VehicleJobID
WHERE tblVehicleJobs.VehicleJobID=GetCurrentVehicleJobID ();
UNION SELECT [OwnerFName] & " " & [OwnerLName] & " " & [OwnerAddr] &
" " & [OwnerCity] & ", " & [OwnerState] & " " & [OwnerZip] & " " &
"(" & [OwnerCounty] & " county) " & Format$([OwnerPhone],"(@@@)
@@@-@@@@") & " " & IIf([Corporation]=True,"(corporation)","(person)")
AS Item, tblVehicleJobs.VehicleJobID, "O" AS OLAX, tblOwners.OwnerID
AS RecID, [OwnerFName] & " " & [OwnerLName] AS Recipient,
[OwnerFName] & " " & [OwnerLName] & " " & [OwnerAddr] & " " &
[OwnerCity] & ", " & [OwnerState] & " " & [OwnerZip] AS NameAddr
FROM tblVehicleJobs INNER JOIN tblOwners ON tblVehicleJobs.OwnerID =
tblOwners.OwnerID
WHERE tblVehicleJobs.VehicleJobID=GetCurrentVehicleJobID ();
UNION SELECT IIf(IsNull([AuthCompany]),[AuthFName] & " " &
[AuthLName],[AuthCompany]) & " " & [AuthAddr] & " " & [AuthCity] & ",
" & [AuthState] & " " & [AuthZip] & " " & Format$([AuthPhone],"(@@@)
@@@-@@@@") AS Item, tblVehicleJobs.VehicleJobID, "A" AS OLAX,
tblAuth.AuthID AS RecID, IIf(IsNull([AuthCompany]),[AuthFName] & " " &
[AuthLName],[AuthCompany]) AS Recipient,
IIf(IsNull([AuthCompany]),[AuthFName] & " " &
[AuthLName],[AuthCompany]) & " " & [AuthAddr] & " " & [AuthCity] & ",
" & [AuthState] & " " & [AuthZip] AS NameAddr
FROM tblAuth INNER JOIN tblVehicleJobs ON tblAuth.AuthID =
tblVehicleJobs.AuthID
WHERE (tblVehicleJobs.VehicleJobID=GetCurrentVehicleJobI D()) AND
(tblAuth.AuthCatID)<>2;
UNION SELECT [ProxyFName] & " " & [ProxyLName] & " " & [ProxyAddr] &
" " & [ProxyCity] & ", " & [ProxyState] & " " & [ProxyZip] & " " &
Format$([ProxyPhone],"(@@@) @@@-@@@@") AS Item,
tblVehicleJobs.VehicleJobID, "P" AS OLAX, tblProxies.ProxyID AS RecID,
[ProxyFName] & " " & [ProxyLName] AS Recipient, [ProxyFName] & " " &
[ProxyLName] & " " & [ProxyAddr] & " " & [ProxyCity] & ", " &
[ProxyState] & " " & [ProxyZip] AS NameAddr
FROM tblVehicleJobs INNER JOIN tblProxies ON tblVehicleJobs.ProxyID =
tblProxies.ProxyID
WHERE tblVehicleJobs.VehicleJobID=GetCurrentVehicleJobID ();
This query runs fine when I dbl-clik it in the database window. But
when I use DAO to access it, I get an error saying
GetCurrentVehicleJobID() is UNDEFINED. This has only recently
become a problem. The FN returns a VehicleJobID long integer value
when called. For nearly a year, I've had no problems calling the FN
to furnish a criteria value for the saved query. Now, in the past week
it seems I've had nothing but problems in several different places
where I've used the function to furnish a criteria value in an SQL
statement.
