Search results

OK. I tride printing on a different printer. It worked fine. So I guess I need to resolve a problem with the printer. Thanks for your help. This problem has been resolved.

Sorry guys, I attached the wrong file in the previous post. Please use the file attached below. Thanks.

I was able to zip the file using WinZip. I hope you can unZip the file and get a functional DB. Let me know. What you will see if this works might rasie your eye brows. Feel free to add suggestions. I am still trying to figure out how to execute Refresh and Requiry commands to update my edits to...

Sorry it has taken so long to get back to you guys. I tried to upload the DB but my file was too large, 4.4 MB. The limit is 2,0 MB. Any suggestions?

jdraw, The message box returns tblAddresses which is the correct table.

Thanks Mihail, but the result is the same. The printed report consists of only ten rows, to columns each. It should be 90 plus rows of 10 columns each.

I am working a simple address project which generates a report of addresses and the address information. The report looks great on the screen in Report mode. I have a button on the report called "Print". When executed "on_Click", the following code executes: Private Sub Command32_Click()...

I have a project which produces a report of names, addresses, etc. I added a print button to the form to send the report to the printer. The code is as follows: Private Sub Command32_Click() Docmd.SetWarnings False 'Docmd.OpenReport "rptAddresses", acViewNormal Docmd.RunCommand...

Thanks plog. I often get confused between VBA and SQL. Your solution did the trick.

I have a simple MyAddress Project. It consists of one main table, a couple of queries, some forms and reports. Most fields in the table are typical text fields. The project allows me to select records from the table and print labels for those selected records. One field is a "yes/no" field. If...

I am a new user. I retired from the working world the end of May - 2013. I now play with Access as a hobby. I have years of experience with Access using versions prior to 2007. I am self taught. I do have trouble with the conversion to Access 10. Although I have done a bit of Access programing...