Database results default value

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

Guest

I'm working on a database in Frontpage (using Access) that will return data
based on the user's selections. I have dropdown boxes for the user to select
a choice. If they don't select anything, I want the database to return ALL
things in that field. Therefore, rather than setting the default value to
"0," I need to somehow set it to "all." for that to happen, what do I enter
as the field's default value?
 
You will have to custom write the script to process the database query to handle a value of "ALL"

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================
 
Use % (not 0) for the default value

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


| I'm working on a database in Frontpage (using Access) that will return data
| based on the user's selections. I have dropdown boxes for the user to select
| a choice. If they don't select anything, I want the database to return ALL
| things in that field. Therefore, rather than setting the default value to
| "0," I need to somehow set it to "all." for that to happen, what do I enter
| as the field's default value?
 
Back
Top