Search results

Thanks Mile-O-Phile! Getting that query setup made it easy to put a button on the form that ouput the label report with the correct addresses! Thanks. I hadn't found any documentation that showed how to make query fields like that, rather than using actual fields in a table. I had written...

Re-posting this here instead of in the reports forum. Not sure where is the best place to ask this, but here goes! Here is what I am trying to accomplish: I need to print mailing labels, using a report. However, I have two different sets of addresses in each record of my table. The first...

Here is the code I settled on In case anyone else every wants to do this, here is the code I settled on to open one form from another using a button, then printing the form using the same record as the original source form. Private Sub PrintLicense_Click() On Error GoTo Err_PrintLicense_Click...

Well, I was surprised Access 97 has such limited control of form size within the application. I had to rely on using my HP print driver to setup a half of a 8.5 X 11 page (8.5 x 5.5). I called it HalfPage. Then I matched my report to that size, and everything was fine, except that the...

Thanks to Wayne, message for Rich Rich, I agree, a report was what I first designed, and used. I only switched to printing a form when the reports handling of the background graphics and custom page size screwed up constantly. It may just be crappy handling by Access97, and we are going to...

Spacepro, there is no option to do the following: Dim StrLinkCriteria As String Strlinkcriteria = forms!yourformname!yourPKField docmd.selectobject acform, stdocname,strlinkcriteria, true as the docmd.selectobject method does not allow an argument such as strlinkcriteria to specify a...

Thank you for the ideas. The second form, that is being printed, is a license that does not have all of the same information on it, and is not formatted like, the source form. It also has a background watermark, and is a half page license, so 8.5 inches wide by 5.5 long, a custom size, rather...

Used to be a programmer many years ago, from 1988-1992. Moved on to I.T., mainly network infrastructure and server and desktop design, engineering, and administration. Security, network backbone, server management, and application help desk are my current strengths. Now I also am being tasked...