Changing Tables by BCSrestore

Kalani Combo Dresser / Changing Table – Cherry $409 A combo dresser / changing table is perfect for those who are small on space, big on style! Drawers and cabinet provide tons of room and the top doubles as a changing station. Dimensions: 54"W x 20"L x 39"H Gift Wrap not available. Shipping Note: This item ships via UPS Ground within contiguous United States only. Cannot be shipped to AK/HI, PO boxes, US territories, or APO/FPO addresses.

Kalani Combo Dresser / Changing Table – Espresso $409 A combo dresser / changing table is perfect for those who are small on space, big on style! Drawers and cabinet provide tons of room and the top doubles as a changing station. Dimensions: 54"W x 20"L x 39"H Gift Wrap not available. Shipping Note: This item ships via UPS Ground within contiguous United States only. Cannot be shipped to AK/HI, PO boxes, US territories, or APO/FPO addresses.

Kalani Combo Dresser / Changing Table – Ebony $409 A combo dresser / changing table is perfect for those who are small on space, big on style! Drawers and cabinet provide tons of room and the top doubles as a changing station. Dimensions: 54"W x 20"L x 39"H Gift Wrap not available. Shipping Note: This item ships via UPS Ground within contiguous United States only. Cannot be shipped to AK/HI, PO boxes, US territories, or APO/FPO addresses.

Kalani Combo Dresser / Changing Table – Honey Oak $409 A combo dresser / changing table is perfect for those who are small on space, big on style! Drawers and cabinet provide tons of room and the top doubles as a changing station. Dimensions: 54"W x 20"L x 39"H Gift Wrap not available. Shipping Note: This item ships via UPS Ground within contiguous United States only. Cannot be shipped to AK/HI, PO boxes, US territories, or APO/FPO addresses.

Da Vinci Changing Pad $39 Made from polyurethane foam, this changing pad is hand sewn and will fit all DaVinci changing tables. Dimensions:34"L x 17"W x 1"H Gift Wrap not available. Shipping Note: This item ships via UPS Ground within contiguous United States only. Cannot be shipped to AK/HI, PO boxes, US territories, or APO/FPO addresses.

Dekor Terry Changing Pad Cover – Blue $9.95 Dekor’s Terry Changing Pad Cover is made of ultra soft, high-quality terrycloth and makes a great addition to changing stations. Fits all standard "16 x 32" changing tables. Available in three colors. Machine washable.

Dekor Terry Changing Pad Cover – Natural $9.95 Dekor’s Terry Changing Pad Cover is made of ultra soft, high-quality terrycloth and makes a great addition to changing stations. Fits all standard "16 x 32" changing tables. Available in three colors. Machine washable.

Dekor Terry Changing Pad Cover – Pink $9.95 Dekor’s Terry Changing Pad Cover is made of ultra soft, high-quality terrycloth and makes a great addition to changing stations. Fits all standard "16 x 32" changing tables. Available in three colors. Machine washable.

Cariboo Classic Changing Table – Teak $394.95 Cariboo is a line of children’s furniture that showcases elegant design with practical features. Designed and made in New Zealand, the Cariboo line is constructed of sustainable Radiata wood. The coordinating bassinets and changing tables blend easily with the most stylish home decor. Each piece will be a striking addition to any nursery or master bedroom. The timeless beauty of the Cariboo Classic Changing Table adds a touch of class to any nursery. The Classic Changing Table also has long term use as a stand for toys or books when a changing table is no longer needed. The Classic Changing Table is environmentally friendly, made from sustainable New Zealand Radiata wood. Comes complete with a changing table pad and fitted toweling cover. Specifications: Dimensions: 35" H x 32" D x 33" L Weight Limit: 45 lbs Gift Wrap not available. Shipping Note: This item ships via UPS Ground within contiguous United States only. Cannot be shipped to AK/HI, PO Boxes, US territories, or APO/FPO addresses.

Gia Combo Unit – White $598 A great addition to any nursery, the Gia Combo Unit by Sorelle features a 3 drawer chest with an extra storage cabinet on the right-hand side. This piece serves as both a handy diaper changing station and dresser that will help you stay organized too. There is plenty of room to store blankets, clothes, diapers, bunting bags and much more. This functional piece of timeless furniture creates a wonderful area for your nursery’s decorative items like books, keepsakes, trinkets and picture frames. If you need extra storage or display space, Sorelle makes a coordinating hutch piece sold separately. The Gia Series by Sorelle is not only stylish, but also eco-friendly! These products are manufactured with a water-based paint, odorless glue, low levels of formaldehyde and Sorelle participates in a reforestation program. Features: Available in White and Espresso Crafted of Brazilian marupa hardwood Doubles as a changing station and dresser Four drawers and a cabinet Non-toxic finish Smooth surfaces and corners Optional Hutch with shelves sold separately Specifications: Dimensions: 53" x 19" x 34" Weight: 150 pounds Note: Hutch shown in picture is sold separately. Gift Wrap not available. Shipping Note: This item cannot be shipped to AK/HI, PO boxes, US territories, or APO/FPO addresses.

Gia Combo Unit – Espresso $598 A great addition to any nursery, the Gia Combo Unit by Sorelle features a 3 drawer chest with an extra storage cabinet on the right-hand side. This piece serves as both a handy diaper changing station and dresser that will help you stay organized too. There is plenty of room to store blankets, clothes, diapers, bunting bags and much more. This functional piece of timeless furniture creates a wonderful area for your nursery’s decorative items like books, keepsakes, trinkets and picture frames. If you need extra storage or display space, Sorelle makes a coordinating hutch piece sold separately. The Gia Series by Sorelle is not only stylish, but also eco-friendly! These products are manufactured with a water-based paint, odorless glue, low levels of formaldehyde and Sorelle participates in a reforestation program. Features: Available in White and Espresso Crafted of Brazilian marupa hardwood Doubles as a changing station and dresser Four drawers and a cabinet Non-toxic finish Smooth surfaces and corners Optional Hutch with shelves sold separately Specifications: Dimensions: 53" x 19" x 34" Weight: 150 pounds Note: Hutch shown in picture is sold separately. Gift Wrap not available. Shipping Note: This item cannot be shipped to AK/HI, PO boxes, US territories, or APO/FPO addresses.

Picci Changing Pad In Pink $120 Picci Changing Pad In Pink

Summer Contoured Changing Pad $24.99 Summer Contoured Changing Pad

Colgate Changing Pad $40 Colgate Changing Pad

Beatrice Combo Tower Dresser – White $249.95 Beautiful and classic, the Beatrice Combo Tower Dresser by Stork Craft is a perfect addition to any nursery. By combining ample storage space with a convenient changing table design, this multi-purpose furniture is both functional and space-saving. Every parent needs a comfortable and convenient place to change baby, and the Beatrice Combo Tower Dresser offers just that. Simply add a changing pad (not included) to the lower part of the dresser top and keep diapers and other changing supplies either in or on top of the storage tower for quick and handy access. With baby’s clothing neatly stored in the dresser drawers below, you can accomplish both changing and dressing while safely keeping a hand on baby at all times. Made from solid wood and wood products, the Beatrice Combo Tower Dresser features a durable non-toxic finish and classic, round wooden pulls. All drawers come with steel drawer glides with safety stops for smooth, safe motion, and Stork Craft includes a tipping restraint as an added and recommended safety precaution. As part of Stork Craft’s popular Beatrice collection, this mission-style dresser combo is available in several different finishes that will complement your existing nursery decor or complete your Beatrice collection. Features: Cam-lock construction for easy assembly Tipping restraint included Juvenile Products Manufacturers’ Association (JPMA) certified Includes a one-year warranty Specifications: Comes in six durable non-toxic finishes Assembled dimensions: 48"L x 18"W x 37.25" H Stork Craft Manufacturing, Inc. is an industry leader in design, manufacture and distribution of juvenile products. Being in operation for more than sixty years, Stork Craft is know for designing classic nursery furniture at an exceptional value. All Stork Craft products are Juvenile Products Manufacturers’ Association (JPMA) certified, undergo extensive and rigorous testing, and follow strict safety standards and regulations. Gift Wrap not available. Shipping Note: This item ships directly from the manufacturer within contiguous United States only. Cannot be shipped to AK/HI, PO boxes, US territories, or APO/FPO addresses.

Ms Access Tip: Self Learning Combo Box

Database data entry can be tedious at times. You can make your databases more user friendly if they have a way to select data to enter rather than typing in the same data over and over. Access provides a form control called a combo box to help with this task but it can lead to trouble. Also, if you find that the data is redundant, you will probably want to be able to sort on that field in the future for reporting. The combo box allows the user to select inputs from a preset location like a table, a list of values, or a preset query. This works well unless the option you want to enter is not in the preset data. Access will not let you put in a new value unless you set the Limit to List option to No. Then, users are allowed to put in any data without checks. This can be troublesome. The value of having the combo box can be quickly diminished if users are misspelling data as they enter it or using different data to mean the same thing. This is very easily seen as you can define the United States as US, USA, United States, United States of America all meaning the same thing. Subsequent reporting would be inaccurate with misspelled input and dissimilar input for the same field.

To over come that problem, it would be handy to have code that asks the user to confirm a new entry into the table before they go ahead, just to make sure they entered what they meant to. This example shows you how to accomplish this with what I call a self learning combo box. Meaning, it learns new entries and adds them to the list of preset values, but requests a confirmation from the user if the entry is not already in the table. Use the following to create a simple form to demonstrate the self learning combo box and make it a feature you give your users in the future.

Create a new database and do the following steps:

Set references by adding the Microsoft DAO 3.6 Object Library to the current checked list. Do this by opening the VBA editor and clicking on Tools/References then checking the library from the list.

Create a table named contacts with these fields.

ConId as autonumber set as the primary key field

ConName as text

ConType as text

Fill in a line or two of test data before going on to the next step.

Design a very simple form for the example with one text box and two combo box controls on it.

Set the form’s data source to contacts

Set the control source for the text box as ConName and name it ConName on the Other Tab

Set the control source for the first combo box as ConType and name it xType

Set the Row Source to SELECT Contacts.ConType FROM Contacts GROUP BY Contacts.ConType;

Set the control source for the second combo box to ConType and name it Type

You can do this later if you want, but you can set the Format control for Visible to No for this combo box.

In Design View of the Form cut and copy in the following Form Code

Option Compare Database

Private Sub Type_NotInList(NewData As String, Response As Integer)

Me.Type.LimitToList = False

End Sub

Private Sub xType_AfterUpdate()

Dim Resp

MiSQL = "SELECT ConTypes.ConTypes FROM ConTypes WHERE (((ConTypes.ConTypes)='" & xType & "'));"

GetMiRSet ‘ calls the function GetMiRSet from a module

If MiRec.RecordCount = 0 Then

Resp = MsgBox("The Type entered '" & xType & "' is not in list. Do you wish to add? Press OK or CANCEL..", vbOKCancel, xType & " Not On List")

If Resp = 1 Then

MiSQL = "INSERT INTO ConTypes ( ConTypes ) SELECT '" & xType & "' AS x1;"

PutMiRSet ‘calls the function PutMiRSet from a module

MiSQL = "SELECT ConTypes.ConTypes FROM ConTypes WHERE (((ConTypes.ConTypes)='" & xType & "'));"

GetMiRSet

Me.Type.Requery

Me.Type = MiRec!ConTypes

Form.Refresh

Else

xType = Null

End If

Else

Me.Type = MiRec!ConTypes

Form.Refresh

End If

End Sub

Now close the form and save it.

Next you will create a handy new module you can use in any database to save a little work.

This code is handy in Access because it makes it a little quicker to work with Recordsets by predefining command options ahead of time. Using this module you can simply call GetMiRSet when you want data from a table and PutMiRSet when you want to put data into a table with VBA. The required input for both functions is the SQL string defined as MiSQL. It is needed to define the data set you want to use in the format like the following:

MiSQL = "INSERT INTO ConTacts( ConType ) SELECT '" & xType & "' AS x1;"

You should see a line similar to this in the above list of commands.

Hint: Use the New Query function to create your SQL statements. After you have designed them in Design View, change to SQL view and you will see the SQL string. Copy this and place it into the VBA editor to save some time. You may have to make some modification to the SQL string you copy after you put it into your VBA code on the form. Like in our example, you can see where we are using the xType control name like a variable in the string. You can’t do this inside the string quotes so you have to concatenate two strings together with the & symbol. Also, in this sql string, xType is a string, so if you want to put it into the statement, like all strings, it has to be inside quotes. But, since the string is in a string, use single quotes. It will help to put a debug.print MiSQL statement after this line to see how Access is going to interpret the string.

Now create a New Module and put the following lines into it and save it under any name.

Option Compare Database

Option Explicit

Public MiSQL As String, Midb As Database, MiRec As DAO.Recordset, MiRec2 As DAO.Recordset

Public Function GetMiRSet()

Set Midb = CurrentDb()

Set MiRec = Midb.OpenRecordset(MiSQL, dbOpenDynaset)

End Function

Public Function GetMiRSet2()

Set Midb = CurrentDb()

Set MiRec2 = Midb.OpenRecordset(MiSQL, dbOpenDynaset)

End Function

Public Function PutMiRSet()

Dim Midb As Database ', MiRec As DAO.Recordset

Set Midb = CurrentDb()

Midb.Execute MiSQL

End Function

You are done. Go back to the form and give it a try. Enter a new value in the text box and then enter a new value in the first combo box and you should get a message box asking you to confirm the entry.

You can find a working example database at http://www.biomationsystems.com/AccessTips.htm

About the Author

Jon Watson is the founder of Biomation Systems, Inc. With 26 years experience helping Fortune 500 companies with process improvement he formed BioMation to bring the same expertise to smaller companies that need the same improvements at an affordable price.

Jackson's Combo Table

South Shore Furniture, Cotton Candy Collection, Changing Table, Ebony $269.99 This Cotton Candy collection offers a classic look that will grow with baby. This collection is one of our most versatile ever as when removing the changing station from the changing table it becomes a regular chest....

Athena Daphne, Kimberly Crib Changing Table Pad $24.95 ...

Graco Portland Combo Dresser, Espresso $275.99 9170898 Finish: Espresso Features: -Combo dresser.-Sturdy modular design.-Allows for easy access for all your nursery necessities.-Coordinates beautifully with the matching Portland 5-drawer.-Completes the nursery by pairing with Graco Crib.-Three spacious drawers as well as an adjustable shelf behind the door.-Hidden European door hinges, European metal drawer glides as well as a locking mechanis...

Madison Changing Table Combo Unit - White ...

Kalani Combo Dresser / Changing Table - Cherry $409 A combo dresser / changing table is perfect for those who are small on space, big on style! Drawers and cabinet provide tons of room and the top doubles as a changing station. Dimensions: 54"W x 20"L x 39"H Gift Wrap not available. Shipping Note: This item ships via UPS Ground within contiguous United States only. Cannot be shipped to AK/HI, PO boxes, US territories, or APO/FPO addresses.

Kalani Combo Dresser / Changing Table - Espresso $409 A combo dresser / changing table is perfect for those who are small on space, big on style! Drawers and cabinet provide tons of room and the top doubles as a changing station. Dimensions: 54"W x 20"L x 39"H Gift Wrap not available. Shipping Note: This item ships via UPS Ground within contiguous United States only. Cannot be shipped to AK/HI, PO boxes, US territories, or APO/FPO addresses.

Kalani Combo Dresser / Changing Table - Ebony $409 A combo dresser / changing table is perfect for those who are small on space, big on style! Drawers and cabinet provide tons of room and the top doubles as a changing station. Dimensions: 54"W x 20"L x 39"H Gift Wrap not available. Shipping Note: This item ships via UPS Ground within contiguous United States only. Cannot be shipped to AK/HI, PO boxes, US territories, or APO/FPO addresses.

Kalani Combo Dresser / Changing Table - Honey Oak $409 A combo dresser / changing table is perfect for those who are small on space, big on style! Drawers and cabinet provide tons of room and the top doubles as a changing station. Dimensions: 54"W x 20"L x 39"H Gift Wrap not available. Shipping Note: This item ships via UPS Ground within contiguous United States only. Cannot be shipped to AK/HI, PO boxes, US territories, or APO/FPO addresses.

Da Vinci Changing Pad $39 Made from polyurethane foam, this changing pad is hand sewn and will fit all DaVinci changing tables. Dimensions:34"L x 17"W x 1"H Gift Wrap not available. Shipping Note: This item ships via UPS Ground within contiguous United States only. Cannot be shipped to AK/HI, PO boxes, US territories, or APO/FPO addresses.

Dekor Terry Changing Pad Cover - Blue $9.95 Dekor’s Terry Changing Pad Cover is made of ultra soft, high-quality terrycloth and makes a great addition to changing stations. Fits all standard "16 x 32" changing tables. Available in three colors. Machine washable.

Dekor Terry Changing Pad Cover - Natural $9.95 Dekor’s Terry Changing Pad Cover is made of ultra soft, high-quality terrycloth and makes a great addition to changing stations. Fits all standard "16 x 32" changing tables. Available in three colors. Machine washable.

Dekor Terry Changing Pad Cover - Pink $9.95 Dekor’s Terry Changing Pad Cover is made of ultra soft, high-quality terrycloth and makes a great addition to changing stations. Fits all standard "16 x 32" changing tables. Available in three colors. Machine washable.

Cariboo Classic Changing Table - Teak $394.95 Cariboo is a line of children's furniture that showcases elegant design with practical features. Designed and made in New Zealand, the Cariboo line is constructed of sustainable Radiata wood. The coordinating bassinets and changing tables blend easily with the most stylish home decor. Each piece will be a striking addition to any nursery or master bedroom. The timeless beauty of the Cariboo Classic Changing Table adds a touch of class to any nursery. The Classic Changing Table also has long term use as a stand for toys or books when a changing table is no longer needed. The Classic Changing Table is environmentally friendly, made from sustainable New Zealand Radiata wood. Comes complete with a changing table pad and fitted toweling cover. Specifications: Dimensions: 35" H x 32" D x 33" L Weight Limit: 45 lbs Gift Wrap not available. Shipping Note: This item ships via UPS Ground within contiguous United States only. Cannot be shipped to AK/HI, PO Boxes, US territories, or APO/FPO addresses.

Gia Combo Unit - White $598 A great addition to any nursery, the Gia Combo Unit by Sorelle features a 3 drawer chest with an extra storage cabinet on the right-hand side. This piece serves as both a handy diaper changing station and dresser that will help you stay organized too. There is plenty of room to store blankets, clothes, diapers, bunting bags and much more. This functional piece of timeless furniture creates a wonderful area for your nursery's decorative items like books, keepsakes, trinkets and picture frames. If you need extra storage or display space, Sorelle makes a coordinating hutch piece sold separately. The Gia Series by Sorelle is not only stylish, but also eco-friendly! These products are manufactured with a water-based paint, odorless glue, low levels of formaldehyde and Sorelle participates in a reforestation program. Features: Available in White and Espresso Crafted of Brazilian marupa hardwood Doubles as a changing station and dresser Four drawers and a cabinet Non-toxic finish Smooth surfaces and corners Optional Hutch with shelves sold separately Specifications: Dimensions: 53" x 19" x 34" Weight: 150 pounds Note: Hutch shown in picture is sold separately. Gift Wrap not available. Shipping Note: This item cannot be shipped to AK/HI, PO boxes, US territories, or APO/FPO addresses.