MS Access VBScript Temperature Conversion

The only assignment is the programming assignment.

I have put the database out for you to use. It's called conversion student.

Double click on the form to open it. see image.

Switch between design view and form view, design to code, form to run.

From the file menu or by right clicking on the form tab. see image.

To open the code window, put the form in design view. Select the Design tab under the Form Design window and click on View Code. see image.

I've also put out the other databases, Sort and Recursion for you reference. The Powerpoint has been uploaded to the Powerpoints folder (More Programming 2. pptx).

You have a database that will convert temperature values.

From Fahrenheit to Celsius and Celsius to Fahrenheit.

I will give you the database with the form with 2 text boxes and 3 buttons.

The Fahrenheit box is called txtFahrenheit

The Celsius box is called txtCelsius

The button for converting to Fahrenheit is called cmdConvertToF

The button for converting to Celsius is called cmdConvertToC see image.

You will be writing the code for both buttons.

In the code view of the database, I have given you the 2 button events and the procedure.

When the user clicks a button, you will take the value from the proper box and send it to a procedure to calculate and display the result.

In general, You need to figure out the variables you need and declare them

Here's a couple of declaration statements for reference

• Dim a as integer
• Dim b as single (decimal number)
• Dim c as double (big decimal number)
• Dim d as string (text)
• Dim e as Boolean (true/false)

Determine which button the user pushed

Send the button value and the value from the box to the conversion procedure

Do the calculations

Display the results