B
Bob H
I have a tools database which been used for over 12 months on a network
at work. Just lately I have noticed that on the main tools query, when I
open it to do some filtering for locations or tools, I am asked for a
parameter. If I just click ok, and not enter anything, the query runs.
It didn't used to ask for a parameter, so I don't understand why it is
doing so now.
This query is used to select the different tool types from a combo box
in the main form, so I don't want to change anything that would stop the
selection working.
The SQL for the said query is below:
SELECT tblTools.ToolTypeID, tblTools.Manufacturer, tblTools.Product,
tblTools.Size, tblTools.[Lenght Size], tblTools.SWL, tblTools.Drive,
tblTools.Range, tblTools.Increment, tblTools.ManufSerialNo,
tblTools.SerialNo, tblTools.AssetNo, tblTools.MPSENo,
tblTools.LastTestDate, DateAdd([PeriodTypeID],[Freq],[LastTestDate]) AS
NextTestDate, tblTools.CertificateNo, tblTools.LocationID,
tblTools.Notes, tblTools.Calibrate, tblTools.DateAdded, tblTools.DateEdited
FROM tblToolType INNER JOIN tblTools ON tblToolType.ToolTypeID =
tblTools.ToolTypeID
WHERE (((tblTools.ToolTypeID)=[Forms]![Tools]![cboSelectToolType])) OR
((([Forms]![Tools]![cboSelectToolType])=0 Or
([Forms]![Tools]![cboSelectToolType]) Is Null));
Thanks
at work. Just lately I have noticed that on the main tools query, when I
open it to do some filtering for locations or tools, I am asked for a
parameter. If I just click ok, and not enter anything, the query runs.
It didn't used to ask for a parameter, so I don't understand why it is
doing so now.
This query is used to select the different tool types from a combo box
in the main form, so I don't want to change anything that would stop the
selection working.
The SQL for the said query is below:
SELECT tblTools.ToolTypeID, tblTools.Manufacturer, tblTools.Product,
tblTools.Size, tblTools.[Lenght Size], tblTools.SWL, tblTools.Drive,
tblTools.Range, tblTools.Increment, tblTools.ManufSerialNo,
tblTools.SerialNo, tblTools.AssetNo, tblTools.MPSENo,
tblTools.LastTestDate, DateAdd([PeriodTypeID],[Freq],[LastTestDate]) AS
NextTestDate, tblTools.CertificateNo, tblTools.LocationID,
tblTools.Notes, tblTools.Calibrate, tblTools.DateAdded, tblTools.DateEdited
FROM tblToolType INNER JOIN tblTools ON tblToolType.ToolTypeID =
tblTools.ToolTypeID
WHERE (((tblTools.ToolTypeID)=[Forms]![Tools]![cboSelectToolType])) OR
((([Forms]![Tools]![cboSelectToolType])=0 Or
([Forms]![Tools]![cboSelectToolType]) Is Null));
Thanks