Form Validation

G

Guest

I have a form to submit a work order. There are three
fields (componentname, username, and workrequested). The
form writes to an Access database.

I would like the form submission to be validated based on
the criteria of the database, not through rules set up
via the web page. I understand this is more taxing on
the server. The reason for this request is that there is
no way I could write the validation rules for
componentname and username as they are very lengthy lists
that change frequently.

As it stands presently, one could (and do) enter
usernames and componentnames that are not valid. I then
need to "adjust" them.

My problem? I do not know how to set up the form to
validate based on the criteria of the database.
 
T

Thomas A. Rowe

The best and easiest approach would be to create a drop down menu, than pulls the required value for
selection by the users from the database, that way they can only select valid entries.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
 
G

Guest

That drop-down menu would have several thousand different
component names. I understand that once they began
typing, they would get to the correct area, but even
still, clicking on the wrong entry (easy to do with drop-
downs) would result in poor data being passed.
-----Original Message-----
The best and easiest approach would be to create a drop
Click to expand...
down menu, than pulls the required value for
selection by the users from the database, that way they
Click to expand...
can only select valid entries.
 
T

Thomas A. Rowe

Could you have the user first select a top level category, which would limit the number of component
that would need to be displayed?

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
 
F

Frolickin

Thomas A. Rowe said:
Could you have the user first select a top level category, which would limit the number of component
that would need to be displayed?
Click to expand...

Not easily. I suppose I could re-work this whole thing so an employee would
only be able to report work requests for components that are in their
room/office/whatever.

I am gathering by your questions there is not a way to use Access's
valiadation rules a FP form. Is that correct?
 
T

Thomas A. Rowe

Correct. You would have write your own custom ASP/VBScript server-side validation functions.

You might want to also ask this in the Access newsgroup.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
 
Top