Chinese Antiques

Antique Vases, Bowls, Statues, swords and more

Form

July 26th, 2009

Angie

Form

Cuisinart GR-4N 5-in-1 Griddler

$185.00

The Cuisinart(tm) Griddler makes “multifunctional” an understatement! Make perfect panini… plus! With four separate cooking options, it can handle everything from pancakes to sausages to grilled cheese to steaks, hamburgers and panini. It helps you prepare more servings of more kinds of food in less time, so you can cook for a crowd — no one has to wait!Simply change the cooking plates and adju…

De’Longhi EC155 15 BAR Pump Espresso and Cappuccino Maker

$69.00

The DeLonghi Espresso Maker has a patented dual-function filter holder for use with ground espresso, this unique filter mixes air into the brewing process to produce a perfect crema. Distinguished by it’s caramel color, the crema is the essence of authentic espresso. The filter also accommodates E.S.E pods. This great Espresso machine offers a swivel jet frother that makes cappucccino, latte or an…

Cuisinart CPB-300 SmartPower 15-Piece Compact Portable Blending/Chopping System

Meet the Cuisinart SmartPower Compact Portable Blender – the compact powerhouse that does it all! Use the streamline blending cup to make smoothies in a flash! Mince herbs in the chopper cup and whip up custom drinks right in the “To-Go” cups – we’ve included four of them so everyone can have their favorite! Designed of fit anywhere, the Compact Portable Blender delivers big blender performance wi…

Ms Access Tip – How to Use Variables in the Access Query Design Form

MS Access Tip – How to use variables in the Access query design form.

In this example you are going to learn how to enter or select data in one form and open another form with more data related to the field you just selected by taking advantage of global variables in the query design form. To help achieve this, you will use a global variable entered in the criteria of a field while creating the query in the Access query design form. The result is a powerful user interface function that allows a user to look up more data, or enter more data related to a selected record. Users can use it to look up pricing histories, addresses, inventory locations, really anything where you would have more data about a key field in your database.

You can achieve this by learning to use global variables. These variables can be accessed by any form, query, macro, or other modules while you are in the Access session. Use a module to store these variables in.

There are several simple steps to achieve this functionality.

Create a global variable in a module

Create your data table.

Create the source query for the “look up” or pop up form

Create the pop up form with the source query as the data source

Create the form to enter the selection from and enter the VBA code to the pertinent control events on the form to open the look up form.

1) Create a module with the following few lines of code.

Option Compare Database

Public DFname As String

Public Function GetVFname () As String

GetVFname = VFname

End Function

2) Create a table with the following fields for demonstration sake. ID as an autonumber. Then create Fname, Lname , Street, City, St, Zip, County, Phone as text fields and lastly add DOB as a date field.

Set the form to be a pop up form. While in design mode, make sure the form is selected and then on the “Other” tab turn the Pop Up setting to yes. Save the table naming it Client.

3) Next create a query to use as the data source for your form. Use the Client table as the source and select all the fields from the table field list using the Windows shift select feature and drag them down to the field view portion of the Query by Example form. Now in the ID field, set the Criteria as:

GetVFname ()

Close the query and save it as IDQry

4) Create a form using the query you just created as the data source. So, on the Data tab on the form select IDQry. Just put all the fields on the form for this example. Save it as ClientData.

5) Create a second form and use the client table as the data source. This form is used to demonstrate selecting a record with a double click event and getting the pop up form with more information related to the selected record.

In a real application you may want to access data from other tables/forms in the same way. Pull in the Id, Fname and Lname fields only. Close and save the form as NameLst.

Put the following code on the double click event of the Id field. This will open the “ClientData” form with the selected Client.

Private Sub ID_DblClick(Cancel As Integer)

VFname = Me.ID.Value

DoCmd.OpenForm “ClientData”, acNormal

End Sub

Now to see this example work, simply open the NameLst form and double click on the ID field in any record.

This example was created with Access 2002. There are more than likely many different ways to accomplish the same functionality, but we have found that this general approach is the most scalable to larger applications.

How do bubbles form when you blow from the straw into the cup?

When you blow from the straw into a glass of water. Usually buuble form. But how are they formed?

You are forcing air from your lungs into the water through the straw. Even if you provide a continuous and steady supply of air, you will see that you will not get a huge air bubble but instead you will get many small air bubbles. How does this happen?
As air reaches the bottom of the straw and starts coming out of it will immediately experience buoyancy, which pushes the air upwards. This can be explained by Archimedes’s Principle but this is not your question so let’s don’t spend time here. Water is surrounding the air as it peeks through the bottom end of the straw. The surface tension in the interface water-air keeps (to some degree) the air mass together as the bubble forms in the opening of the straw. There will be a time where the buoyancy experienced by the mass of air being pumped is greater than the surface tension trying to keep this volume of air together and at this time the air mass will split and break: one part will move upwards and the other part will still remain in the opening of the straw, forming another bubble.
Based on this explanation, you could infer that if a liquid has less surface tension than other then the size of the bubbles as they break up from the bottom of the straw should be smaller in size than the bubbles formed in a liquid with a higher surface tension. You could try to compare the size of the bubbles in water and the bubbles in water mixed with detergent (which decreases surface tension in water). Might be hard to see the difference though.

Why do bubbles have a spherical shape? Because the air inside the bubble is pushing in all directions with the same magnitude and this produces a sphere. Additionally the size of the bubble will increase as it moves upwards because there is less hydrostatic pressure and this allows the expansion of the air inside the bubble. This is easy to prove if you watch on TV people diving hopefully showing the bubbles as they move up. This is also the reason why divers are told the first day of training that they should never keep air inside their lungs and ascend. This air inside the lungs will expand and could burst the diver’s lungs. So remember, a certain volume of air underwater will expand its volume as it moves up to surface. We can’t see much difference in a glass of water as it is not deep enough.