VBA

Moderators: PavlinII
Number of threads: 1614
Number of posts: 3000

This Forum Only
Post New Thread
Single Post View       Linear View       Threaded View      f

Report
Search Box within main Excel database Posted by Kjarkas on 15 Jan 2009 at 9:06 AM
Hi,
I am trying to simplify looking up information within an Excel database, filtering by only two factors.

What I want to do is create a search box that has two fields and a command button. The two fields are not standard, e.g. "First Name", "Date", but they are restriced to their respective columns in the database. Basically this is what I want:

Enter in Field 1: (Input searched in one column)

Enter in Field 2: (Input searched in another column)

Search (Command Button)

I already designed the box, I just need to assign code to each function. I think I can already make an error message in case either of the fields have incorrect input. I could use some help here, I'll need to know by Monday. Thanks, guys.

Sorry if I'm being vague, I just don't want to give too much information away, this is for a certain company.
Report
Re: Search Box within main Excel database Posted by shasur on 16 Jan 2009 at 1:21 AM
Hi

You can use the find method in Excel

http://www.ozgrid.com/VBA/find-method.htm

or

you can try ADO to connect to Excel sheet just like a Access database

http://vbadud.blogspot.com/2008/05/using-excel-as-database.html
VBA Tips & Tricks (http://vbadud.blogspot.com)

C# Code Snippets (http:dotnetdud.blogspot.com)



 

Recent Jobs

Official Programmer's Heaven Blogs
Web Hosting | Browser and Social Games | Gadgets

Popular resources on Programmersheaven.com
Assembly | Basic | C | C# | C++ | Delphi | Flash | Java | JavaScript | Pascal | Perl | PHP | Python | Ruby | Visual Basic
© Copyright 2011 Programmersheaven.com - All rights reserved.
Reproduction in whole or in part, in any form or medium without express written permission is prohibited.
Violators of this policy may be subject to legal action. Please read our Terms Of Use and Privacy Statement for more information.
Operated by CommunityHeaven, a BootstrapLabs company.