Search results

Thanks again for the great help. My project has really moved along much smoother and quicker since I've gotten help from the contacts in ACCESS WORLD. TO my issue now: I have a database that stores information for orders. My Order Form is performing great, (now). The data that is collected...

Uncle Gizmo: Thank you so much for your insight. (I also thank you for comments. I laugh sometimes by the comments - I often think people are too business like to add in humor, but for me, it is a GREAT thing. I learn better with relaxed attitudes.) I will definitely look into getting...

The =Format([ Combo Box Stuffed Animals].[column](2),"Currency") - Works Yes...I tried the first command - but it only worked with the first combo box. The Format command worked with the other 2 combo boxes. Thanking all of you. The project is now getting closer and closer to completion...

Oops. Still a problem. I have 3 combo boxes that need that function to work on. It works on the first combo box but the other two, not working at all.

To the DBGuy Yes Sir....works like a charm. I did not know about the Currency Function. It works very well. It really solved my problem sir. Thanks again a million time savers......

I have an issue with a text box. I have a Combo Box that have 4 fields. When I click the box, the correct drop down options appear. I store the Name in the combo box. Next, I have the text box below it, storing the Price of the Item: =[Combo Box Name].[Column](2). This is correct because the...

I have a question about doing a database program in relation to the internet. The following is a layout of what is required: I've been asked to do a database that takes Customer Orders. Here is my issue: After developing the database, what methods should I use to have it connect to the...

Uncle Gizmo: I tried it and it worked like a Magical Charm.... Thank you so much. I also read about subscribing to your channel. (I subscribed) Thank you again and Merry Christmas

Uncle Gizmo, This is exactly what I needed to get the job done. I'd gone into YouTube and seen a video similar and I could not remember how to do the setting of the 2 unbound boxes to the columns. I could not remember the video nor the correct code for identifying the Column. (I'm getting old)...

First, thank everyone for previous assistance. You all are really fantastic. Second, hope everyone has enjoyed the holidays. Peace and Love. I have a situation with a Subform that has 2 drop-down menus. The first drop-down selects a product from a list. The 2nd drop down displays a listing of...

Thank you for the assistance. I have not done any programming (if this is what I call it) in many many years. I did DB3+ when I was in college in the mid-late 80's. I've done a few desktop small database programs for a few professionals that needed reports. Saying thank you all for the help...

To theDBguy: I am laughing for several reasons: 1. The help that I get from here is totally out of this world. Great Help to me. 2. And yes, I took your advice and took out the command to requery. Works just great. Thanking you all once again for such great help.

Yes. You are so correct.

I have an Orders Form. After making a selection from Combo Box, a Subform is correctly updated. Once entering the Subform, I select the Product and the correct items are displayed in the Drop Down Menu. (Good So Far) After selection is made, Tab goes to the Price Column with the correct price...

It's called a "Thank"

June7: With your help, the problem has been resolved. The Join was causing all of the problems after the re-structure of the data. I really want to thank you for all of your patience and excellent help. One last thing. Please tell me how to Post a Like or what ever it's called. I've only...

June7: I think I've stumbled onto part of my problem. I've taken out the Tbl_Product Price from the Inner Join now. You suggested that. I've now taken it out and gotten rid of all of the 3 triple entries.

June7: Are you speaking of Requery after Update of Product ID to the Price Combo Box and making the Product Id in Tbl_Product Price being equal in the Subform? Yes, I did that also. I have to be missing something.

Each Product shows the 3 options: Low, Mid, and High Example: Roses - Dozen Roses - $50(Low) - 1 Quantity - Line Total $50 Roses - Dozen Roses - $60(Mid) - 1 Quantity - Line Total $60 Roses - Dozen Roses - $70(High) - 1 Quantity - Line Total $70 and this did the same thing for the 2 Product...

Followed all instructions. Thank you June7. Only issue now: In the datasheet on the form, the results show each level, low, mid, high price as if I selected each one per line. I've only tried to select 1 level but all 3 are showing up. Do you have suggestions on how to correct this problem...