Purchase Solution

Creating Search Table Based on Combo Box for Access Database

Not what you're looking for?

Ask Custom Question

When 1 is selected for choice, check to see if the combination of 1 for choice and zip code exists. If combination exists, message "A primary location already exists for this zip code: If not, save code already in place.

When 2 is selected for choice, check to see if the combination of 12for choice and zip code exists. If combination exists, message "A secondary location already exists for this zip code: If not, save code already in place.

When 3 is selected for choice, Update Include field in table to "Out of Area".

Attachments
Purchase this Solution
Solution Summary

Provides steps necessary to create the search table.

Solution Preview

Dear Student,
Please find attached the update MS Access database. I have added a new form called frmSearchByOption. I have also ...

Purchase this Solution
Free BrainMass Quizzes
C# variables and classes

This quiz contains questions about C# classes and variables.

Basic Computer Terms

We use many basic terms like bit, pixel in our usual conversations about computers. Are we aware of what these mean? This little quiz is an attempt towards discovering that.

Javscript Basics

Quiz on basics of javascript programming language.

C++ Operators

This quiz tests a student's knowledge about C++ operators.

Java loops

This quiz checks your knowledge of for and while loops in Java. For and while loops are essential building blocks for all Java programs. Having a solid understanding of these constructs is critical for success in programming Java.

View More Free Quizzes
Related BrainMass Solutions

  • Huffman Trucking Input Forms

    Creating a form You can create a form on your own or you can have Microsoft Access create your form for you using a Form Wizard. A Form Wizard speeds up the process of creating a form because it does all the basic work for you.

  • Create an Access Database

    Make a screen shot for the search window with the search string you use - Use the Report Wizard to create a report based on the primary Firm table and the related Payment table.

  • Relational Database Management System Implementation

    Make a screen shot for the search window with the search string you use Use the Report Wizard to create a report based on the primary Firm table and the related Payment table.

  • design a database

    There are several approaches to creating a successful database. Search the internet to find information about designing a simple database for your client.

  • Create a database for a human resources group

    153252 Access Database Problem Create a database for a human resources group. List a few different tables and colums to store the HR information. State assumptions in creating the DB and underlying database objects.

  • This post addresses access database and queries.

    We begin the writing by using CREATE TABLE, which is the SQL command that tells the database to create a table based on the additional SQL commands that will be written. We then save the query and run the query.

  • A MYSQL and PHP Project

    There are no strict requirements for the search engine, however you may want to consider implementing the following: Quick search - based on simple keyword(s) Advanced search - based on a combination of different attributes Category search -

  • Remove an item from combo box based on first letter in Visual Basic

    177008 Software: Deleting Items Based on its First Letter "In the following exercises, assume that the Simple combo box appears as shown and that the Sorted property is set to True.

  • Access Database: Employee Table and a Customer Table

    The solution assists with creating an Access database that includes two different tables.

View More Related Solutions