Search results

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?

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?

hi again if you rather the macro.in the db menu select macro, new in the drop down menu select open report.in the action arguments enter your report name, view ...etc.save it. open your form right click on that button to get properties menu. in the event tab go down to " on click" click your...

hi if you open your form in design view there's a toolbar, 11th from the left is a command buttin option. once selected and placed on the form a command button wizard will pop-up.select report operations then print report.then you will be ask for what report to print. select your report than...

I know reports are for printing records, but I've built a program that's a form. Its used to print labels for different patient medications and one user may need 1 label while other user quanities will vary constantly everything works fine except when a user clicks a print button i created using...

I know reports are for printing records, but I've built a program that's a form. Its used to print labels for different patient medications and one user may need 1 label while other user quanities will vary constantly everything works fine except when a user clicks a print button i created using...