
June 9th, 2006, 01:42 AM
|
 |
Contributing User
|
|
Join Date: Aug 2004
Location: Idaho
|
|
Fore!
Quote: | Originally Posted by tband hello...im a newbie for vb,my brother owns a shop selling golf equipment. He wants me to help him create a easy running program for searching items. The idea is: lets say i have 1000 shafts on stocks, i key in all the details in a database like weight,torque,mph(e.g 1-5,5-10,10-15) then i wanna create a exe or a program that is with 3 columns to type in keywords and a big column showing de results. lets say if i type in de weight column 60,then the database will look up all shafts dat match weight 60, then 2nd column i type in 70 torque, then the search results will auto narrow down or just show up shafts with both weight 60 and torque 70 shafts only, and last one if i type 98 for mph column, it'll show up only shafts with weight 60,torque 70 and mph with 95-100 because 98 its in de middle of 95-100.
IS that a complicated one...and what ideas and codes should i be doing...please give me any ideas.....>.< thank you so much |
You could use Access with VBA to do that easily. If you have never done any programming you have some studying to do as Access can be a difficult concept to grasp at first. Access can be customized to do other neat things using VBA which is pretty simple to learn the basics of.
If you have all your Data tabulated on paper its as simple as creating tables to hold your data and forms, queries or reports to search or get the data in and out of the tables.
Tables hold data.
Forms act as a interface between you and the tables where the data is stored. You can put customized search tools on those forms like you decscribed above to search out what you want using what you put in as search criteria.
Queries are the search engines that find the data.
Reports are predesigned /customized reports that spit out the data you want in the way you want it. They could simply be the search you just ran detailing the specs of certain clubs based on your search criteria that are printed out with the company logo etc. on them.
The question you have to ask yourself is how much time do you have to develop this, and do you have a DB program like Access to do it?
|