Recent content by gregoryharvey

The following code gives me an error: Private Sub PRINT_Click() On Error GoTo Err_PRINT_Click DoCmd.RunSQL "INSERT INTO tblReport SELECT * FROM labels2006 WHERE Field='Something';" DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70 DoCmd.PrintOut acSelection...

no problem

thanks ill give it a try.

does anyone else know the code behind this that can help me out

ok i have created a report with the name you suggested

thanks, i really do need your help. i guess i just have to catch you online.

if you look at the file in the labels 2006 form. i want the user to put how many labels they want in that text box and when they click the print command button, want it to print the amount in the box on a single sheet. i tried to use a macro yesterday but it prints for example if a say 4 copies...

i have tried the reports all night ad it really only works on the numbers of pages of an entire table and i cant find a way for a user to edit the current record in a report.

im sorry its a form and i wanted the user to say how many labels to print because it changes often. i really dont know how to explain it so im sending an attachment to you. once open its the label 2006 button on the switchboard.thanks

banana im still fairly new to this. vba codes are over my head.

i wanted to use the text box as an indicator of how many labels to print for a selected record in a form. do you know of a better way?

newbie question Is there anyway to bound an unbound text box to a print command button ?

I have two threads posted and have many views but no replies. am I asking the right questions?

I have a form that i use to make labels. I want the user to be able to specify in the form the numbers of labels to print. After reading access for dummies and other manuals, google and calling my local IT guys, I've exhausted all examples I was given. CAN/ WILL ANYONE HELP ME?

I have a form that i use to make labels. I want the user to be able to specify in the form the numbers of labels to print. After reading access for dummies and other manuals, google and calling my local IT guys, I've exhausted all examples I was given. CAN/ WILL ANYONE HELP ME?