Products Disappear from Orders - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Products Disappear from Orders

Michelle Seidelin

6 years ago

Hello Richard I'm wondering if you could tell me why the invoice details is not coming from order detailed table what is happening I discovered if you delete an item which is no longer available in product table when you pull up the invoice that item does not show up the quality does but not the item itself e.g. 3 TB hard drive wondering if you could tell me how do I get around this is some of my items are no longer available, the information is of course displaying perfectly on the screen I am guessing it is pulling the information from ProductT when it makes the invoice is it possible to change this to order detail T as the invoice does show everything properly I also noticed quite a few lessons back I think it was expert level IX when you teach how to make the invoice and show how you can put in items which are not in the table this is in lesson 22 but when you open the invoice it is blank I am guessing this is because it's got no reference number two Paul that information up for lighting invoice any help you can give me how to get around this problem as I am able to delete items which are no longer available to not have them in my list/combo box would be appreciated

Happy customer of New Zealand Michelle

Richard Rost @Reply

6 years ago

This all depends on how far along in the lessons you are. Early on, to keep things SIMPLE, I show you how to put products in the order details, but those items are still linked to the product table. If you change something in the product table (delete a product, for example, which you shouldn't do) then it is gone from order details.

Later on, in Access Expert 22, I show you how to "fix" the order entry system by copying that data from products to order details.

Michelle Seidelin OP @Reply

6 years ago

I have done the lesson 22 as I tried to explain in my first email the reason I want to delete items in the product table is that they are no longer available what I have done actually in the end is on the report where it was looking at product ID I have changed it to order detail T and selected product name and this keeps the information even when I delete an item from the ProductT which is what I was trying to do I fought about it after I had send you this email yesterday and this is what works

Just for it may be interesting for you to know what I did I have jumped from level 10 to level XXII just to do that part of the database to make the database up and running I know you say to follow a long with you and do it in order but this way I have are working database for my purposes

Thank you

Michelle send scratch at

	Richard Rost @Reply 6 years ago
I would recommend you never delete a product, a customer, an order, etc. Mark these things INACTIVE so you don't have to see them in your reports, lists, combo boxes, etc. But keep the data in your database for history reasons.

Michelle Seidelin OP @Reply

6 years ago

Hello Richard

I know I have already sent an email to you about is this but reading your reply again could you please tell me how to mark things INACTIVE as you say in your message what lesson teachers this I ham up to expert level 22 so please let me know where to find out how to do this thanks for putting up with all my messaging I am doublechecking my database from start to finish and changing a few things to make the database better things that I have missed out on when originally starting the database following you along with mom beginner level I thanks again for all your help Michelle

	Richard Rost @Reply 6 years ago
I'll add this to my TechHelp list and try to make a nice simple video showing how to do it.

	Michelle Seidelin OP @Reply 6 years ago
Thank you Richard it is really appreciated Your happy customer from New Zealand Michelle

Michelle Seidelin OP @Reply

6 years ago

I would appreciate you letting me know directly when you make this tech help video if you do finally get that done it would then make it a lot easier for me I think I know what you're saying in the previous message about making a field called as active yes no what I think you're saying as have a checkbox which you check on if it is active and off like you did when you showed how to do a callback form if that is what you are saying could you please direct me to that lesson again as I'm able to check it out again thank you in advance Michelle

Michelle Seidelin OP @Reply

6 years ago

Hello Richard

Do you have any idea how long it may take you before you are able to make this Tech help video showing how to hide things in product table which you said you were going to try to make for me

I would like to apologise for some funny words appearing and my messages because of my disability I use voice recognition and sometimes I don't see the mistakes so would like to apologise again and looking forward to hearing from you hopefully before Christmas

	Richard Rost @Reply 6 years ago
You're on the list. I've got a LOT of items on the list. You're higher up because you're a Developer student, but Members get their questions answered first. I'll get to it as soon as I can.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View