Search results

June7: Thank you for your suggestions. I am going to give it a try and from what I've seen in the past from the suggestions that I've gotten, things work out. I am hoping that this works also. Thanks also for being understanding. Will get back with you to let you know my results.

The Member is the person making the Order. I should rename Customer to Recipient. I think I do understand your question about that issue.

I did try placing the Product Price ID or the Price in the query but the query, when ran, would just result in the heading showing up.

The issue that I have is in Form Edit or View Orders. I know about the Line Total being in the Table. I only placed in there because once the calculation was done, and I tapped past the calculation onto the next line, the Line Total would disappear. (that was crazy) Never seen that ever happen...

June7: Thanking you again for your great assistance. Hope that I followed your instructions correctly.

June7, it worked. But there are still some issues. I did the query without the Product Cost Table included. Created a Combo Box that was based on the Product Cost Table. Made the Product ID Combo Box requery the Product Cost after Update. Enter my Quantity amount. Calculation goes into Line...

June7, thank you very much for your suggestion. You are correct about not using the Product Cost Table in the query. Seems to work fine without it. I did not have a way to get the 3 prices for each product. Using the cascading (depending on the Product combo box), works great when I had the 2...

Hello. I really need help with this problem. I have 4 tables: 1. OrderProduct Details: OrderProduct Details ID Order ID Product ID Quantity 2. Product Info: Product ID Name Description 3. Orders: Orders ID 4. Product Cost: Product Cost ID Product ID Price Level (This states the price level -...

June7, I tried your suggestion. It worked just perfect. Thank you so very much. This is the best group for getting help in regards to MS Access.

June7, I would like to thank you for the information. I will give this a try. Thank all of you for your help with questions regarding MS Access. I am learning from the advice that I get.

I want to set the number of records that can be entered into a datasheet to 3. How can this be done? Thanking you in advance.

I am working on an Order Form. My first Combo Box has a list of Members. The second Combo Box will display the list of Recipients that are associated with the Member that has been selected in the 1st Combo Box. That is working correctly. Here is the problem: Each time I move from this form but...

Let me better explain. I have the Item with the other fields. When I go to that Edit - View Item, I can see all those fields and edit them. Below that, I have a table that has Low, Mid, High with each price beside it. I can enter as many different rows but I only want those 3.

I have a form for each Item Cost. I can pull each one up and change the prices or price of each level

Thank you Pat Hartman. (I believe you have helped me also in the past.) I want to be sure I have this correct in what you are explaining to me: I need to have a foreign key in the Item Cost Table. That foreign key will be the Item ID from the Item Table. Is this correct?

June 7: Thanks for responding. I do have a first drop down that will allow the Data Entry person to select the Item. Once the Item is selected, the row is populated with info...Name, Description, Category, etc. When I initially set the Item table up, I had a Cost field. (Naturally, it was...

First, I'd like to thank those that have previously helped me in the past. This is one of the best groups to come for if a person has questions about MS Access.... I have a: Items Table Items Table has Item ID, Name, Cost, and Category. I am going to use this table when the Date Entry person...

Thank you so much. I was almost on the right track according to your suggestions. I will follow your suggestions and thank you all for the great help. This group is hard to beat when it comes to giving assistance. Thanks again Plog

I have an Item Table that needs to be changed and I need your assistance please. In my Item Table: Item ID Item Number Item Description Item Cost The problem arises with the Item Cost. As an example, I need to give the Data Entry person the ability to select 1 of 3 prices. Low - $60 Mid - $70...

TO arnelgp, Uncle Gizmo, Ranman256, and ridders. I gave it all that I could. I was working on using the HTML Workshop Help. The one thing that I tried was creating a new project for each topic and using the same format, just changing the topic each time. The only disadvantage was that with each...