Want a default in parameter

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

Guest

Hi everyone! Enjoying the spring? It's a beautiful time of year. Using A02 on
XP. Have a letter query and want to ask "Include New Client Info Paragraph?
Yes or No."

I have the following on my query's FIELD line: NCForm: [Include New Client
Info Paragraph? Y/N] and I would LOVE to have it default to "N". I'm sure
it's possible but no clue how.

Could/Would someone be kind enough to direct me? Thank you in advance for
any help or advice! Luv U Guys!
 
Bonnie:

Try this (all as a single line in the 'field' row).

NCForm: IIf(IsNull([Include New Client Info Paragraph? Y/N]),"N",[Include
New Client Info Paragraph? Y/N])

If the user hits the return key without entering Y or N at the parameter
prompt N will be returned in the column. The default N won't show in the
parameter prompt, however; to achieve that you'd have to create a dialogue
form to enter the parameter rather than using a simple system generated
dialogue.

Ken Sheridan
Stafford, England
 
Hi Ken!!! You are the reason I keep going after being told it cannot be
done. I did have to alter your suggestion just a little bit. I wrote:
NCForm: IIf(IsNull([Include New Client Info Paragraph? Blank=No,
Y=Yes]),"N","Y"). Using yours I got a second parameter box with just
'Include' in it (can only hold 8 charaters?) and had to answer Y or N for
both. Changed it to above and it works GREAT!!! Thank you SO much for
taking the time to solve mysteries for folks like myself.
--
Bonnie


Ken Sheridan said:
Bonnie:

Try this (all as a single line in the 'field' row).

NCForm: IIf(IsNull([Include New Client Info Paragraph? Y/N]),"N",[Include
New Client Info Paragraph? Y/N])

If the user hits the return key without entering Y or N at the parameter
prompt N will be returned in the column. The default N won't show in the
parameter prompt, however; to achieve that you'd have to create a dialogue
form to enter the parameter rather than using a simple system generated
dialogue.

Ken Sheridan
Stafford, England

Bonnie said:
Hi everyone! Enjoying the spring? It's a beautiful time of year. Using A02 on
XP. Have a letter query and want to ask "Include New Client Info Paragraph?
Yes or No."

I have the following on my query's FIELD line: NCForm: [Include New Client
Info Paragraph? Y/N] and I would LOVE to have it default to "N". I'm sure
it's possible but no clue how.

Could/Would someone be kind enough to direct me? Thank you in advance for
any help or advice! Luv U Guys!
Click to expand...
Click to expand...
 
Hi S. Clark. Just wanted you to know that I did indeed get a positive
response (it seems to be possible on the 3rd Tuesday of any month that starts
with an 'A'). I altered Ken's reply just a bit to avoid the pesky double
parameter. Here 'tis: NCForm: IIf(IsNull([Include New Client Info
Paragraph? Blank=No, Y=Yes]),"N","Y"). Works like a charm.

Thanks for the reply though, I love the newsgroups and I learn SO MUCH!!!
--
Bonnie


[MVP] S.Clark said:
I'm sure it's not possible, and I have a clue(But only on even Mondays).
The parameter query has minimal functionality.

You CAN build your own form, add a text box(or check box) and go from there,
instead.

--
Steve Clark, Access MVP
FMS, Inc
http://www.fmsinc.com/consulting
Professional Access Database Repair
*FREE* Access Tips: http://www.fmsinc.com/free/tips.html

Bonnie said:
Hi everyone! Enjoying the spring? It's a beautiful time of year. Using A02
on
XP. Have a letter query and want to ask "Include New Client Info
Paragraph?
Yes or No."

I have the following on my query's FIELD line: NCForm: [Include New Client
Info Paragraph? Y/N] and I would LOVE to have it default to "N". I'm sure
it's possible but no clue how.

Could/Would someone be kind enough to direct me? Thank you in advance for
any help or advice! Luv U Guys!
Click to expand...
Click to expand...
 
Back
Top