Can a form be used as a user friendly way to run a query. I need to have drop down menus to pick out the part type and text boxes to search descriptions, a way to run the search, and a way to give a report of parts that fit?
by 
Steel Fire
ANSWERS: 1
-
Certainly. The form will only submit the data about the drop down menu and text boxes, however. You will have to use a server-side language such as PHP or ASP to pull results from your database. You might have a look at this: http://w3schools.com/html/html_forms.asp You'll set the "action" attribute of the form to your PHP/ASP/other file and the "method" attribute to "post". If you're using PHP, the variables from your form will be accessible through the $_POST array (i.e. $_POST['variablename']). EDIT: I'm sorry, I didn't happen to notice that this question concerned Microsoft Access. Perhaps the information on forms will still be of some use to you.
RELATED QUESTIONS
Copyright 2023, Wired Ivy, LLC