Printing Single invoice - Microsoft Access Expert 9


	Back to Access Expert 9 Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Printing Single invoice

Richard Van Wagoner

4 years ago

This applies to Expert Level 9 Lesson 5 at about 12:00 to 15:00. When I use =[Forms]![OrderF]!OrderID to the query (OrderQ) and set up my command button and try to run it. It puts me on a new order. I cannot figure out what I have done wrong. I have watched the Lesson many times but still no luck.

	Richard Van Wagoner OP @Reply 4 years ago
I forgot to mention this is for my database but I have built it according to the class instructions. I have built the class database and it works fine there.

	Richard Rost @Reply 4 years ago
Let's see some screen shots of your design and form views.

	Richard Van Wagoner OP @Reply 4 years ago

	Richard Van Wagoner OP @Reply 4 years ago

	Richard Van Wagoner OP @Reply 4 years ago

	Richard Van Wagoner OP @Reply 4 years ago
I removed the Command from the query so it could use the data base to fix the layout of my Invoice.

	Richard Van Wagoner OP @Reply 4 years ago
While I have your attention, I don't know if you have been following my question in Tech Help "Copying a Field". But I could really use your help on that issue as well.

	Richard Van Wagoner OP @Reply 4 years ago
It took me 5 Days but I finally got it. instead of using the query, I changed the embedded Macro on the Command Button adding a where condition it works fine.

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

Next Unseen

New Feature: Comment Live View