Printing just one label - how to ? "Rob" <noreply[ at ]thank.you> 11/18/2008 7:39:21 PM Hi all :) I have an Access 2007 application where I want people to fill in a form with 6 text fields and one field that contains the number of copies. Those text fields are not related to any table. When they are done filling in the fields , they can press the print button and those 6 text lines should end up on some label-printer's label. Now I thought I could somehow make a report with 6 lines in it and use VB to transfer the form's data into the reports fields and print the report. But after several hours of trying and failing I am at a end. Has someone a good solution to my problem? Thanks in advance, Rob.

Re: Printing just one label - how to ? "Pete D." <pduffy211AT[ at ]coxDOT.net> 11/19/2008 12:09:16 AM Why use VBA. Make a simple report using the wizard with just the fields needed. Put report in design mode and move the fields around to work with your label size the page right. Done "Rob" <noreply[ at ]thank.you> wrote in message news:76184A69-2A8B-41CE-8117-45CBB631EE28[ at ]microsoft.com... [Quoted Text] > Hi all :) > > I have an Access 2007 application where I want people to fill in a form > with 6 text fields and one field that contains the number of copies. > Those text fields are not related to any table. > When they are done filling in the fields , they can press the print button > and those 6 text lines should end up on some label-printer's label. > > Now I thought I could somehow make a report with 6 lines in it and use VB > to transfer the form's data into the reports fields and print the report. > But after several hours of trying and failing I am at a end. > > Has someone a good solution to my problem? > > Thanks in advance, > > Rob.

RE: Printing just one label - how to ? Clifford Bass 11/20/2008 5:50:02 AM Hi Rob, It would be easier to relate/store them in a table. But if you really don't want to do that, you can do the following, which does not need VBA. Assume your entry form is named "frmEnter a Label" and a couple of the controls on it are named "txtName" and "txtCity". In your report, you might have a control, also named "txtName" and another, also named "txtCity". For the first, you would set its Control Source to [Forms]![frmEnter A Label]![txtName]. Likewise the Control Source for "txtCity" would be [Forms]![frmEnter a Label]![txtCity]. The enter-a-label form must remain open for the report to be able to get the values from it. Hope this helps, Clifford Bass "Rob" wrote: [Quoted Text] > Hi all :) > > I have an Access 2007 application where I want people to fill in a form with > 6 text fields and one field that contains the number of copies. > Those text fields are not related to any table. > When they are done filling in the fields , they can press the print button > and those 6 text lines should end up on some label-printer's label. > > Now I thought I could somehow make a report with 6 lines in it and use VB to > transfer the form's data into the reports fields and print the report. > But after several hours of trying and failing I am at a end. > > Has someone a good solution to my problem? > > Thanks in advance, > > Rob.

Re: Printing just one label - how to ? "Rob" <noreply[ at ]thank.you> 11/20/2008 6:21:57 PM Clifford, your idea about the table proved to be very usefull :) Thanks. "Clifford Bass" <CliffordBass[ at ]discussions.microsoft.com> schreef in bericht news:A826A621-0EAF-4A13-AFE7-B1146A929007[ at ]microsoft.com... [Quoted Text] > Hi Rob, > > It would be easier to relate/store them in a table. But if you really > don't want to do that, you can do the following, which does not need VBA. > Assume your entry form is named "frmEnter a Label" and a couple of the > controls on it are named "txtName" and "txtCity". In your report, you > might > have a control, also named "txtName" and another, also named "txtCity". > For > the first, you would set its Control Source to [Forms]![frmEnter A > Label]![txtName]. Likewise the Control Source for "txtCity" would be > [Forms]![frmEnter a Label]![txtCity]. The enter-a-label form must remain > open for the report to be able to get the values from it. > > Hope this helps, > > Clifford Bass > > "Rob" wrote: > >> Hi all :) >> >> I have an Access 2007 application where I want people to fill in a form >> with >> 6 text fields and one field that contains the number of copies. >> Those text fields are not related to any table. >> When they are done filling in the fields , they can press the print >> button >> and those 6 text lines should end up on some label-printer's label. >> >> Now I thought I could somehow make a report with 6 lines in it and use VB >> to >> transfer the form's data into the reports fields and print the report. >> But after several hours of trying and failing I am at a end. >> >> Has someone a good solution to my problem? >> >> Thanks in advance, >> >> Rob.

Re: Printing just one label - how to ? "Rob" <noreply[ at ]thank.you> 11/20/2008 6:25:06 PM Handling the data from a form to the report was my problem and then printing it. I use a table now to do this which works well. Thanks for your reply though! "Pete D." <pduffy211AT[ at ]coxDOT.net> schreef in bericht news:O7IIPsdSJHA.5344[ at ]TK2MSFTNGP06.phx.gbl... [Quoted Text] > Why use VBA. Make a simple report using the wizard with just the fields > needed. Put report in design mode and move the fields around to work with > your label size the page right. Done > "Rob" <noreply[ at ]thank.you> wrote in message > news:76184A69-2A8B-41CE-8117-45CBB631EE28[ at ]microsoft.com... >> Hi all :) >> >> I have an Access 2007 application where I want people to fill in a form >> with 6 text fields and one field that contains the number of copies. >> Those text fields are not related to any table. >> When they are done filling in the fields , they can press the print >> button and those 6 text lines should end up on some label-printer's >> label. >> >> Now I thought I could somehow make a report with 6 lines in it and use VB >> to transfer the form's data into the reports fields and print the report. >> But after several hours of trying and failing I am at a end. >> >> Has someone a good solution to my problem? >> >> Thanks in advance, >> >> Rob. > >