473,326 Members | 2,192 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

VBA Search Engine Dilemma

Hello from Asia Minor,
I am far away from home and my reference material is not with me.
Dilemma: I have been asked to create a program from scratch that will have a search engine built into it, searching for personal data at a sentry post, to make it easier than searching through tons of papers printed out which change daily, weekly and monthly. Drawing on what little programming language I know, I have composed something. However, the language I learned was PASCAL, not VBA. I am quickly learning access, but time is NOT on my side.
Bottom Line: Can anyone point me in the right direction?
Anyone have any samples or ideas to get me going?
I have all of the forms, and colorful pazzaz, but I am really counting on this search engine as being the heart of my project.
Anything would be greatly appreciated.
-Soldier in Afghanistan
Jan 28 '12 #1
4 1474
NeoPa
32,556 Expert Mod 16PB
Before you can build a search engine of any form you need to have developed a very clear understanding of what you want to search in as well as what you want to search for (which may well include multiple options).

As a very basic, conceptual, answer I would say that you need a massive form which displays as much detail as possible using boound controls (The whole form being bound to a query which shows all the information required, including, but not necessarily limited to, all data that you may wish to search on.), as well as various unbound controls that you would use to specify the information to search for.

Actually, the concept is filtering rather than searching, but that is more how you must think of it technically than how users need to think of it. Example Filtering on a Form can help you with the whole concept.

Good luck, and God Bless.
Jan 28 '12 #2
Wow! Simply put and very informative. I will try your concept.
By the Way, the term cascading means that when a certain condition is met, more of the form can come into view, right? I don't want the user to be overwhelmed with info, but I do want more options to pop up if certain criterion are met. If that is cascading, then I need to not only learn filtering, but cascading as well. Again, Thank you for your intuition and helping me by reading between the lines as well.
Very Gratefully,
Sam
Jan 28 '12 #3
NeoPa
32,556 Expert Mod 16PB
Cascaded filtering can be explained by thinking of a hierarchical system (See Cascaded Form Filtering if you haven't already). In its simplest form we might have the following data :
Top level - Battalion
Expand|Select|Wrap|Line Numbers
  1. Battalion
  2. A
  3. B
  4. C
Middle level - Platoon
Expand|Select|Wrap|Line Numbers
  1. Platoon  Battalion
  2. A1          A
  3. A2          A
  4. A3          A
  5. B1          B
  6. B2          B
  7. B3          B
  8. C1          C
  9. C2          C
  10. C3          C
Data to show on form - Soldiers
Expand|Select|Wrap|Line Numbers
  1. Soldier  Platoon
  2. Anderson    A1
  3. Best        A2
  4. Clarke      A3
  5. Denning     B1
  6. Evans       B2
  7. Fuller      B3
  8. Grigg       C1
  9. Hughes      C2
  10. Innes       C3
  11. Jones       A1
  12. Kinnear     A2
  13. Lewis       A3
  14. Muller      B1
  15. Nicholls    B2
  16. O'Donnell   B3
  17. Potter      C1
  18. Quinn       C2
  19. Rowlands    C3
I'm sure my example data is totally ridiculous, but it gives an illustration of the concept anyway.

The form would have unbound ComboBoxes set to display the lists of Battalions and Platoons. The form would display only those soldiers that belonged to the platoon selected in the Platoon ComboBox. The hierarchical element though is that the list of Platoons would also be dependent on the value selected from the Battalion ComboBox.

Thus, you might select Battalion B, which would restrict the list of Platoons to B1, B2 & B3, then select Platoon B2, which would restrict the records on the form to Evans and Nicholls.
Jan 28 '12 #4
Mihail
759 512MB
Hello !
My English is not enough good so maybe I am wrong; but I understand that the data are (exist) in electronic format but you have not a search engine to find a certain information.
If this is the situation let us to know. More than provide more details about how the data are stored.
Jan 29 '12 #5

Sign in to post your reply or Sign up for a free account.

Similar topics

5
by: Frank | last post by:
Hello, I'm running a site with +20.000 articles. The articles (html files) are saved on the server as txt files. Alle other data (author, date, category and so on) are in a MySQL db. Before we...
8
by: Rod | last post by:
Hi, i am doing a ecommerce website and would like to implement a search engine to find products. All the serach engine I have found on the web are parsing html page! This is not what i want. i...
11
by: Petre Huile | last post by:
I have designed a site for a client, but they have hired an internet marketing person to incrase their search engine ranking and traffic. He wants to put extra-large fonts on every page which will...
8
by: Craig Cockburn | last post by:
Hi I'm aware of the use of robots.txt and the use of <META NAME="ROBOTS" CONTENT="index,follow"> However, what would be more useful is to be able to control within a page which elements of...
2
by: vichet | last post by:
Hi All; Please help me with some problem i want VBSCRIPT to search something in only my own website give me code thank vichet
2
by: Patrick | last post by:
Are the differences between a search engine, a subject directory and a meta search engine significant for an ebusiness web site owner? A meta search engine merely uses ordinary existing search...
3
by: hazly | last post by:
I'm very new in the web technology and need advice on search engine. I want to develop a portal using PHP and MySQL on Linux. Need to know on the following features : 1. search engine that could...
4
by: MDW | last post by:
Posted this on another board, but evidently it was off-topic there...hope you folks will be able to provide some guidance. I've been working on a Web site for a business (my first non-personal...
11
by: emailus | last post by:
I am webmaster for the domain <www.alpha1.org.au>. Not being an expert in html, I take advantage of my domain Registrant's web building tool, 'Instant Website'. This tool is provided as part of...
0
by: Search.DailyFreeCode.Com | last post by:
http://search.dailyfreecode.com/ A Search Engine has been designed which fulfills all the needs of programmers, with specific focus on following areas 1. Projects 2. Sourcecode 3. Articles...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.