Search results

Great thanks. I'll start working on it.

Thanks for the ideas! If I put the history in a separate database....... would I be able to add the curren't years orders to that history? (Never done that before so just wondering if it's possible.) (He wants to see every single order from the past and recent.) Thanks. Melanie

I am creating a database for a company that sells a product with a variety of options. They have all their previous orders in a works spreadsheet file. Each customer has their own file with every order for the past 15 years. There are probably about 1.5 million records. The company wants all...

Thanks. I'll study the example. The widths and heights options are about a thousand. The widths and heights can vary by 1/8" and start at about 14" on both. So lots of options! Melanie

I have a table that has the following fields: minimum width, maximum width, minimum height, maximum height, price I created a form where the user can input the width in a text box and a height in a text box. The next box I created is a price box that will pick up the price from the table...

Can you give me an example or anything for what you are talking about? (Thanks. my mind isn't pulling all this together today.) melanie

Can you give me an example of the table with minimum / maximum idea you have? My mind isn't totally grasping the whole thing. Then on the form, I create the Select statement? Thanks.

Thanks for the ideas. I'll see if I can think it through completely tonight when I have some more time to work through it. I appreciate the help. Melanie

That is a possibility. Thanks. There are too many possibilties for each one I think. For the 24-35 width range it could have 24 1/8, 24 1/2, 24 3/4, 24 7/8 and so forth..... so there could be just about anything. And to come up with each possibility for every width and height would thousands...

I have a form that allows employees to enter the width and height for a product on a form. The width and height are then combined with the type and sizing to make a unique id. That unique id is then looked up in the table to get the price for that specific product. The product is blinds which...

Private Sub PriceForm_GotFocus() Me.PriceForm = DLookup("[Price]", "Price1", "[WidthxHeight_ID] = Form![WidthxHeight_ID]") End Sub It worked without the " & Do I need to put that in there? (New at this of course)

Yes!!! It worked. (woo-hoo!!) Thanks so much. I've read a lot on the DLookup and it has all come together finally in my mind now that you've explained the difference between putting it in the the control source and the VBA code. Bless you. You made my day! :-)) Melanie

I would love the help. Thanks! I appreciate it. Melanie

Makes sense....... I'll work on it. Not sure exactly what to do as I'm new at this but I will work on it! Thanks.

Thank you. I will try this when I get home! I appreciate it.

Yes you are correct. It is record to record. (my terminology error!)

It works. The combined values come from other controls on the form. ---Width & "x" & [Height] (This comes from a width control and a height control on the form) ----& [Type] (This comes from whatever is selected in the Type combo box control) (The combo box gives them the options from a...

Here's the syntax =DLookUp("[Price]","Price1","[WidthxHeight_ID] = Form![WidthxHeight_ID]") The dlookup is on a control in the subform. It looks up "price" on the "price 1 table". (The table has the price for each widthxHeight_ID.) On the form, it's going to the widthxheight_ID control...

fixed that..... now another question I removed the on got focus and also added a missing bracket which helped to solve the problem. Just one little issue left. I have the DLookup in a subform. When I move from one main form to another, then go back, my subform price is updated. If I move...

I keep getting a "0" on a DLOOKUP and cannot figure out why..... =[OnGotFocus]=DLookUp("[Price]","Price1","[WidthxHeight_ID] = Form![WidthxHeight_ID]") This is the control source of a text box called PriceForm. The lookup goes out to the Price field in the Price1 table. WidthxHeight_ID is...