Query

  • Thread starter Thread starter ScrinnBatt
  • Start date Start date
S

ScrinnBatt

Good day all

I have two questions which I would like help with please?
My database is a Machinery Faults database, and has a form that a user can
enter all details for the fault and how it was repaired.. I have made a
number of queries based on machinery Serial Numbers, Part Numbers etc. I
have a field (a checkbox) in the form that relates to whether Outside
Technical assistance was required.

1. How do I set up a Query to run so that it pulls out only those forms with
the checkbox ticked? I tried Is Null and Is Not Null in the TechAssist field
but they return all records.

2. With the majority of the quieries I have set up successfully, I get a pop
up box for the user to enter data, i.e if he wants to obtain all the fault
cards for a certain serial number, he will enter the serial number in the
box. However I would like to make the text above the box more user friendly
so instaed of

[Forms]![fmFaults]![SerNo]

I would like

"Please Enter Serial Number"

Many thanks in Advance

Matty
 
1. How do I set up a Query to run so that it pulls out only those forms with
the checkbox ticked? I tried Is Null and Is Not Null in the TechAssist field
but they return all records.
Click to expand...

Try using Is True or Is False

2. With the majority of the quieries I have set up successfully, I get a pop
up box for the user to enter data, i.e if he wants to obtain all the fault
cards for a certain serial number, he will enter the serial number in the
box. However I would like to make the text above the box more user friendly
so instaed of
Click to expand...

In the criteria field within the query (in design View)

type

[Enter Serial Number]

HTH
 
Back
Top