Course List - Access 302

Student Interaction: Microsoft Access 302

Richard on 1/1/2007: Continue Order Entry, Build Product Table & Form, Combo Box to Select Products, DLOOKUP, More VBA Functions

�Bob on 10/3/2008: Richard.I have learned so much with your series..thanks. However, I'm confused; I add a new customer; then go to orders - I see my new customer name. Then, after adding my products I hit the x to close the window and return to the customer form. I then return to the order form and my order is gone...happens no matter which lesson in 301-305 etc. If I want to really save my order it appears I need to click on the customer combo box and reselect my customer name. Note this is only for the FIRST order for that customer. Why does this happen and how can I avoid clicking on the customercombo? Sorry If I am missing something simple...this happens in my own application I am building too.

Richard Rost on 10/3/2008: Bob, I just noticed something interesting, but kind of unrelated. While I was trying to figure out what's happening for YOU, I noticed that there needs to be a Me.Refresh in the "ADD ORDER" button on the CustomerF form. I just added a customer and hit ADD ORDER and did NOT see the customer in the dropdown because the customer record was still dirty (pencil - being edited). Make sure to add a Me.Refresh into that button. I'll add an addendum to the latest class about that. As far as what's happening to YOU, I can't seem to recreate that problem. Are you adding the order from the ADD ORDER button on the CustomerF form? Or are you closing the CustomerF form and then going straight to the OrderF form? In any case, it's the CustomerCombo box that creates the relationship between customers and orders. If you don't fill that in first, it won't save the order properly under that customer. If you use the ADD ORDER button, it should automatically fill in the CustomerCombo for you. Aside from that little bug I mentioned before, everything appears to be working fine. I anyone else experiencing this problem?

Bob Veenstra on 10/10/2008: Richard: I got back at this, and after many tries and reloading of the lesson databases - I have been able to reproduce the error. As best as I could remember, here is the sequence. I think it has to do with the problem you addressed creating the order before its ready...thanks for helping: I can send my screen caps if you would like: used the 304 file. 1. Added me.refresh to add button on customerf form per your instructions. 2. opened customer list � clicked on id 7 Barker; 3. Open selected Customer selected sales rep Jane, and lead source Newspaper; 4. Show customer orders � none present closed window with x 5. On customerf clicked add new order 6. Order id 17 GamerSkum combo is already filled in as is order date; 7. Stopped by 'select a sales rep first'; OK - did that; 8. Add product � added t-shirt 17 closed with �x� 9. Back on customerf � clicked show customer orders worked fine; 10. Second Customer Alan Watson 11. Selected Joe for sales rep; screen26; 12. add new order 13. order form has sales rep joe; and tech rep joe...already filled in 14. Add product t-shirt - no pencil and order_id = 19 screen 27 15. closed with an x 16. returned to customers and �show customer orders� � no orders screen 28 Seems to get the sales rep info from the first person�s order; then the second persons order carried over the data�too confusing for me�.I am building a system that must be accurate...could you give a little more iinsight to avoid this problem.

Richard Rost on 10/25/2008: Bob, i went through your directions step-by-step and I couldn't reproduce the problem. Did you make sure that you put a Me.Refresh in BOTH the "show orders" and "add new order" buttons? Try deleting all of the orders and order details in the system and start fresh. See if that helps. It worked perfectly for me and I tried it 3 times with the AC304.ZIP database.

Bin�Chen on 3/26/2009: Hi Richard, I am having a hard time getting the Dlookup to work on my form per Access 302. I am trying to get the address field (a combobox) on my form to automatically populate by entering the Name. Here is my statment Address = DLookup("Address", "[PatientData Table]", "Name=" & NameCombo). I put this in the Address_AfterUpdate. But it doesn't work. Please help - Bin

Richard Rost on 4/1/2009: Bin, first of all, you wouldn't put this in the Address_AfterUpdate. You can't look up the field you're updating. You'd put this in the Name_AfterUpdate. Second, I strongly recommend AGAINST naming any field "Name." It's a reserved word in Access. Finally, make sure you put quotes around any string in your parameters: "[Name]='" & NameCombo & "'" Hope this helps. If not, follow the lessons again and do exactly what I do.

Ruth�Spohr on 11/13/2009: 6:50 on the video shows error in Handbook (page 18), s is missing from Notes = DLookup etc. Whilst mentioning Handbook 302 on the footer it says Windows 120 instead of Access 305. Enjoying these lessons heaps.

Add Your Questions or Comments