If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#21
|
|||
|
|||
creating a label report in access
"Chuck" wrote: jinh, I have a sample A97 database that will print any quantity of any number of labels starting at any location on a sheet of labels. It assumes that all the blank spaces on a sheet of labels start at the top left and work across then down. It also assumes that every sheet of labels after the first sheet is full. The mdb file is less than 300 KB. I'll send it as an attachment in an Email if you want. Give me an address. It is a very simple program. It's possible that it will run in A07. Chuck -- Hi Chuck, Thank you for joining in & providing your help. My email address is . Please email me as a zip file. Thanks again. |
#22
|
|||
|
|||
creating a label report in access
"fredg" wrote: On Fri, 29 Aug 2008 23:08:00 -0700, jinh wrote: "fredg" wrote: On Fri, 29 Aug 2008 22:23:00 -0700, jinh wrote: ** snipped ** Hi Jeff, Thank you for joining in to provide your help! I've changed the default view of the report to open in Print Preview, & I still get no luck. If you have any other advice, I will not mind to take it. Thanks again! Jin, I sent you a sample Access 2002 database. Did you get it? Were you able to open it? Were you able to see how it worked? -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail Hi Fred, No, I've not get it yet. When did you send it? Just in case, my email is Would there be a different in Access 2007? Because the database that I've email to you it's in Access 2007 & I don't know if I can down grade it to Access 2002 as my office are runing in Access 2007. Any other idea? Thanks again in advance! Yes, that was the address I sent it to. Perhaps it was not received because it had a .mdb file attached. Check your e-mail security settings. I re-sent it to the above address this morning. Hope you can open it. -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail Hi Fred, How are you doing? I'm sorry I still have not get you email. Please re-send it as a zip file. Thanks again! |
#23
|
|||
|
|||
creating a label report in access
On Tue, 2 Sep 2008 06:52:01 -0700, jinh wrote:
"fredg" wrote: On Fri, 29 Aug 2008 23:08:00 -0700, jinh wrote: "fredg" wrote: On Fri, 29 Aug 2008 22:23:00 -0700, jinh wrote: ** snipped ** Hi Jeff, Thank you for joining in to provide your help! I've changed the default view of the report to open in Print Preview, & I still get no luck. If you have any other advice, I will not mind to take it. Thanks again! Jin, I sent you a sample Access 2002 database. Did you get it? Were you able to open it? Were you able to see how it worked? -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail Hi Fred, No, I've not get it yet. When did you send it? Just in case, my email is Would there be a different in Access 2007? Because the database that I've email to you it's in Access 2007 & I don't know if I can down grade it to Access 2002 as my office are runing in Access 2007. Any other idea? Thanks again in advance! Yes, that was the address I sent it to. Perhaps it was not received because it had a .mdb file attached. Check your e-mail security settings. I re-sent it to the above address this morning. Hope you can open it. -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail Hi Fred, How are you doing? I'm sorry I still have not get you email. Please re-send it as a zip file. Thanks again! Resent it as a Zipped file. -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail |
#24
|
|||
|
|||
creating a label report in access
"fredg" wrote: On Tue, 2 Sep 2008 06:52:01 -0700, jinh wrote: "fredg" wrote: On Fri, 29 Aug 2008 23:08:00 -0700, jinh wrote: "fredg" wrote: On Fri, 29 Aug 2008 22:23:00 -0700, jinh wrote: ** snipped ** Hi Jeff, Thank you for joining in to provide your help! I've changed the default view of the report to open in Print Preview, & I still get no luck. If you have any other advice, I will not mind to take it. Thanks again! Jin, I sent you a sample Access 2002 database. Did you get it? Were you able to open it? Were you able to see how it worked? -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail Hi Fred, No, I've not get it yet. When did you send it? Just in case, my email is Would there be a different in Access 2007? Because the database that I've email to you it's in Access 2007 & I don't know if I can down grade it to Access 2002 as my office are runing in Access 2007. Any other idea? Thanks again in advance! Yes, that was the address I sent it to. Perhaps it was not received because it had a .mdb file attached. Check your e-mail security settings. I re-sent it to the above address this morning. Hope you can open it. -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail Hi Fred, How are you doing? I'm sorry I still have not get you email. Please re-send it as a zip file. Thanks again! Resent it as a Zipped file. -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail I got it Fred. I'll give it a try. Were you be able to take a look at mind? I just want to know if it'll do the same as me. Please let me know. Once again, thanks so much & I'll let you know after I've try your sample. |
#25
|
|||
|
|||
creating a label report in access
"fredg" wrote: On Tue, 2 Sep 2008 06:52:01 -0700, jinh wrote: "fredg" wrote: On Fri, 29 Aug 2008 23:08:00 -0700, jinh wrote: "fredg" wrote: On Fri, 29 Aug 2008 22:23:00 -0700, jinh wrote: ** snipped ** Hi Jeff, Thank you for joining in to provide your help! I've changed the default view of the report to open in Print Preview, & I still get no luck. If you have any other advice, I will not mind to take it. Thanks again! Jin, I sent you a sample Access 2002 database. Did you get it? Were you able to open it? Were you able to see how it worked? -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail Hi Fred, No, I've not get it yet. When did you send it? Just in case, my email is Would there be a different in Access 2007? Because the database that I've email to you it's in Access 2007 & I don't know if I can down grade it to Access 2002 as my office are runing in Access 2007. Any other idea? Thanks again in advance! Yes, that was the address I sent it to. Perhaps it was not received because it had a .mdb file attached. Check your e-mail security settings. I re-sent it to the above address this morning. Hope you can open it. -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail Hi Fred, How are you doing? I'm sorry I still have not get you email. Please re-send it as a zip file. Thanks again! Resent it as a Zipped file. -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail Hi Fred, Thank you very very much for all your helps. I don't know what's in your sample rptSkipLabels, but here is what I did. I unzipped you file. I double click to launch the rptSkipLabels. I open up the report & look at the number of skippes to verify it's working. I close your rptSkipLabels. I launch my application & everything works! Hahah, don't know what kind of magic you have in your rptSkipLabels, but it's all working now. Once again, thank you so much guys for all your helps! |
#26
|
|||
|
|||
creating a label report in access
Hi Fred,
It's me again. Once again thanks for sharing your wonderful codings. Anyway, I was trying to work on the Printing Duplicate Label on the same page, & I got this debugging error which I have no idea how to fix it. The error message says "Microsoft Office Access can't find the field "I" refered to in your expression", & when I click on the Debug button it toke me to the line where it coded as "If IsNull([RepeatCounter]) Then". Any idea what I can do to fix this error? Thanks in advance Fred! JH "fredg" wrote: On Tue, 22 Feb 2005 06:27:02 -0800, Melissa wrote: Thanks Fred, that worked for skipping labels...any suggestions on printing duplicate same page labels?? "fredg" wrote: *** snipped *** There are several different methods. Here is one that combines the skip missing labels with repeating them. This will permit you to enter the number of times to repeat the labels, as well as skip missing label positions on an already used sheet. First make sure your label report properly prints 1 label per record. Then add a Report Header to the label report. Add 3 unbound text boxes to the header. 1) Set the Control Source to: = [Skip how many] Name this control SkipCounter 2) Leave the second control unbound. Name this control SkipControl 3) Set the third control's Control Source to: =[Repeat how many] Name it RepeatCounter Next code the Report Header OnFormat event: Private Sub ReportHeader_Format(Cancel As Integer, FormatCount As Integer) [SkipControl] = "Skip" Cancel = True End Sub ======= Now code the Detail OnPrint Event: (Note that intMyPrint is Static!!) Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer) Static intMyPrint As Integer If PrintCount = [SkipCounter] And [SkipControl] = "Skip" Then Me.NextRecord = False Me.PrintSection = False intMyPrint = 0 Else [SkipControl] = "No" Me.PrintSection = True Me.NextRecord = True intMyPrint = intMyPrint + 1 If IsNull([RepeatCounter]) Then ElseIf intMyPrint Mod [RepeatCounter] = 0 Then Me.NextRecord = True intMyPrint = 0 Else Me.NextRecord = False End If End If End Sub ========= When you run the report, it will ask how many labels to skip, then how many times to repeat each label. -- Fred Please only reply to this newsgroup. I do not reply to personal email. |
#27
|
|||
|
|||
creating a label report in access
Hi Fred,
Don't worry about my last post, it's my own issue. I had a typo in my code. Sorry about that. Thanks anyway! JH "fredg" wrote: On Tue, 22 Feb 2005 06:27:02 -0800, Melissa wrote: Thanks Fred, that worked for skipping labels...any suggestions on printing duplicate same page labels?? "fredg" wrote: *** snipped *** There are several different methods. Here is one that combines the skip missing labels with repeating them. This will permit you to enter the number of times to repeat the labels, as well as skip missing label positions on an already used sheet. First make sure your label report properly prints 1 label per record. Then add a Report Header to the label report. Add 3 unbound text boxes to the header. 1) Set the Control Source to: = [Skip how many] Name this control SkipCounter 2) Leave the second control unbound. Name this control SkipControl 3) Set the third control's Control Source to: =[Repeat how many] Name it RepeatCounter Next code the Report Header OnFormat event: Private Sub ReportHeader_Format(Cancel As Integer, FormatCount As Integer) [SkipControl] = "Skip" Cancel = True End Sub ======= Now code the Detail OnPrint Event: (Note that intMyPrint is Static!!) Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer) Static intMyPrint As Integer If PrintCount = [SkipCounter] And [SkipControl] = "Skip" Then Me.NextRecord = False Me.PrintSection = False intMyPrint = 0 Else [SkipControl] = "No" Me.PrintSection = True Me.NextRecord = True intMyPrint = intMyPrint + 1 If IsNull([RepeatCounter]) Then ElseIf intMyPrint Mod [RepeatCounter] = 0 Then Me.NextRecord = True intMyPrint = 0 Else Me.NextRecord = False End If End If End Sub ========= When you run the report, it will ask how many labels to skip, then how many times to repeat each label. -- Fred Please only reply to this newsgroup. I do not reply to personal email. |
#28
|
|||
|
|||
creating a label report in access
I am running a label report in Access 2007 and entered this code for the
event procedure for the report header and the detail, and like JimH, have no luck. It prints with the label in the 0 position. I tried to add a breakpoint to watch the code, and though I could get it on the VBA page (highlighted with a bullet to the left), I do not know how to find what the values were. I hovered over the VBA page after running the report, but the report itself just runs without any sort of indications. Does this code not work in 2007? Is there something special that 07 wants? Am I just going crazy? Thanks, Claire "jinh" wrote: "fredg" wrote: *** snipped *** Thanks again! I followed your steps to set a breakpoint. But nothing happen after I entered 2 in the [Skip How Many?] box. It just take me to the report. Any other idea? Should I email you the whole access database? Please let me know. Thanks again in advance! Are you using Access 2000 or 2002? Are you using Access 2003? Saving data in the 2000 or 2002 format? Alright, you twisted my arm. ;-) Access 2007? Sorry, I have no way off running it as is. Perhaps you can Convert it into an earlier version... Tools + Database Utilities + Convert Database to 2002 version. It the Database is small, you can send it as is. If the database is large, strip everything out that is not needed to run the label report. All I need is enough records to print 2 pages of labels, or fewer. Compact the database to make sure it compiles. Try it before sending it. No need to Zip the file. Make sure it does not have workgroup security so that I can open it. Send it to jandf at roadrunner. com I'm sure you can properly reconstruct that address. MAKE SURE you write, as the subject line: "Skip Labels" otherwise I will never see it. I'll reply here in the newsgroup. -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail Hi Fred, I'm running access 2007. I've email the attached to you. Please let me know. Thanks, |
#29
|
|||
|
|||
creating a label report in access
On Fri, 12 Dec 2008 10:40:01 -0800, Claire wrote:
I am running a label report in Access 2007 and entered this code for the event procedure for the report header and the detail, and like JimH, have no luck. It prints with the label in the 0 position. I tried to add a breakpoint to watch the code, and though I could get it on the VBA page (highlighted with a bullet to the left), I do not know how to find what the values were. I hovered over the VBA page after running the report, but the report itself just runs without any sort of indications. Does this code not work in 2007? Is there something special that 07 wants? Am I just going crazy? Thanks, Claire "jinh" wrote: "fredg" wrote: *** snipped *** Thanks again! I followed your steps to set a breakpoint. But nothing happen after I entered 2 in the [Skip How Many?] box. It just take me to the report. Any other idea? Should I email you the whole access database? Please let me know. Thanks again in advance! Are you using Access 2000 or 2002? Are you using Access 2003? Saving data in the 2000 or 2002 format? Alright, you twisted my arm. ;-) Access 2007? Sorry, I have no way off running it as is. Perhaps you can Convert it into an earlier version... Tools + Database Utilities + Convert Database to 2002 version. It the Database is small, you can send it as is. If the database is large, strip everything out that is not needed to run the label report. All I need is enough records to print 2 pages of labels, or fewer. Compact the database to make sure it compiles. Try it before sending it. No need to Zip the file. Make sure it does not have workgroup security so that I can open it. Send it to jandf at roadrunner. com I'm sure you can properly reconstruct that address. MAKE SURE you write, as the subject line: "Skip Labels" otherwise I will never see it. I'll reply here in the newsgroup. -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail Hi Fred, I'm running access 2007. I've email the attached to you. Please let me know. Thanks, I remember this original post as he originally sent me the database in Access 2007 format and I wasn't able to open it, however I don't remember the outcome. It wasn't the code. If you found this old post perhaps you can go back and see if there is a follow-up reply sent AFTER I looked at his database. If you care to send me your database, I'll be happy to look at it. It MUST be sent as an Access 2000 MDB format, which is one of the options available in Tools + Database Utilities + Convert Database. Strip everything out of the database that is not needed to run the label report. I'll get back to you here in the newsgroup. Send it to jandf at roadrunner dot com Make sure you write "Skip Labels" as the Subject line, otherwise I will never see it. -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
from a FORM print a label report 3 labels per sheet for CURRENT re | babs | Setting Up & Running Reports | 7 | February 6th, 2005 06:38 PM |
exporting accress reports into word | marc | General Discussion | 8 | December 29th, 2004 04:40 PM |
Save Report With CreateReport Coding Issue | Jeff Conrad | Setting Up & Running Reports | 8 | July 12th, 2004 08:39 AM |
OT- label making | Erika | Publisher | 4 | May 26th, 2004 06:27 AM |