Thread: Selecting and Printing Specific Records

Good Morning Al, I hope I did not screw up the Command Button. Yesterday, when I could not get it to work, I deleted it and put in a new command button. I was not aware that each time you put one in it gives it a new number such as Command 44 or Command 46. When I opened up properties of Reset Print in form view I see the following: Heading of the properties form is Command Button:Command46. However I renamed the Command Button to 'Reset...

Hank, Are you still out there? Any success... -- hth Al Campagna Microsoft Access MVP http://home.comcast.net/~cccsolutions/index.html "Find a job that you love... and you'll never work a day in your life." "HankL" wrote in message ... Al, I renamed my Update query to qryUpdatePrintNone I renamed my button to cmdUpdatePrintNone In design view of my Update query, this is the following...

Hi John, I attempted to rearrange the controls in Design View of the Form. That did not change the appearance of the form. However, I now have a scroll bar on the side of the form and allows me to scroll from one record to another in alphabetical order. Could this also be considered as a Continuous Form? If so, could you help me with the instructions as to how to setup a PRINTME check box on the form so that I can select which record will be...

On Tue, 10 Nov 2009 06:26:46 -0800, "HankL" wrote: John, At the present time, I have the following setup: 1) A continuous form. I can see two records at one time and when I click on the arrow it continues to scroll through my database 2) I have a PrintME yes/no checkbox on my table and it is on the form as well. If I select the checkbox for YES in the table, it also puts a check in the box on the form 3) I have set up a...

On Sun, 8 Nov 2009 13:53:09 -0800, "HankL" wrote: Hi John, I attempted to rearrange the controls in Design View of the Form. That did not change the appearance of the form. However, I now have a scroll bar on the side of the form and allows me to scroll from one record to another in alphabetical order. Could this also be considered as a Continuous Form? It almost certainly is. You should be able to rearrange the controls on...

Hank, Sounds like you added a Boolean field named PrintMe (True/False) to your Restaurant table. Now, this checking/unchecking of PrintMe is best done using a continous form, so you can see as many Restaurants as possible, as you browse and check PrintMe. You can do Single Form, but you'll have to... Find Record and check... find record and check... etc which can be a bit time consuming. OK... now make sure that PrintMe is included in...

"HankL" wrote: That did it. I can't tell you how much I appreciate your patience and working with me to help setup my being able to select and print a report just on the restaurants I need to print. You have really given me a much better understanding of how Access works using the databases. You're most welcome! Glad you were able to get it worked out. John, I do have one more question. Is there a way that I could...