I have a single table created in access with different supplier information (supplier name, address, item supplied, etc) -- about 1500 records.
i need to create a form of some sort that will allow users to extract data on either the specifc supplier name (from a pulldown menu) and the items that they supply OR be able to type in (in an input window) the item they are looking for (would use the criteria Like "X" where x is some part of the name of the component) and then see which suppliers have supplied that specific item.
it would also be nice if the user could then select by a check box or something which other attributes be displayed with the data.
my thought is that i need to create some sort of form that takes the information that the user inputs from the methods specified above and then dumps that information in to a query which then extracts the data.
then, is there a way to dump that extracted data in to an excel spreadsheet?
this is the first time i have done something like this, so i really havent got much of a clue.. any help or pointers that you can lend would be MUCH appreciated. thanks so much in advance.
i need to create a form of some sort that will allow users to extract data on either the specifc supplier name (from a pulldown menu) and the items that they supply OR be able to type in (in an input window) the item they are looking for (would use the criteria Like "X" where x is some part of the name of the component) and then see which suppliers have supplied that specific item.
it would also be nice if the user could then select by a check box or something which other attributes be displayed with the data.
my thought is that i need to create some sort of form that takes the information that the user inputs from the methods specified above and then dumps that information in to a query which then extracts the data.
then, is there a way to dump that extracted data in to an excel spreadsheet?
this is the first time i have done something like this, so i really havent got much of a clue.. any help or pointers that you can lend would be MUCH appreciated. thanks so much in advance.
