Hello...I want to make something in VB (Version 9) that reads multiple data from specified file (Access 2007) and displays content in list box. If file doesn't exist, alert user.
More description:
My name is Steven, I'm a college student and now I'm running my practical session to complete my study. I've been assigned to build a system by my supervisor. He asked to develop a system which is works for finding/searching files that is stored in Microsoft Access 2007. The file that want to be search can be recognize by its 'code' or its 'file name', perhaps just like search engine. We use VB 2008 (Version 9) as it interface and Microsoft Access as its database. For example, a user try to find a file named "Financial Report" while its code "0025", this user is able to search whether by typing its file name or code even by its full file name or its full code, which is mean the search result can be find successfully and shown in the "???" if the user type "Financial Report" or "0025" in the text box.
But, if the user type only part for the file name such as "Fi", all files that have "Fi" as a part of its file name will also be shown as result. For example like "Financing", "Financial Unit", "Filing" and etc. And so on if the user just type the code only as "00", the other file that also have the same or part of the code will also be shown like "001", "0007", "0012", "0023", "3500", (%00), (00%), (%00%). So please, I do really asked you to help me on showing me some guidelines/faqs/hints and etc. Thanks for your help.