Search results

Original link included a comma after the ".com" Take off the comma and it rolls right up. Thanks!

Just a thought here... Could your form not be saving the dates you have selected as your parameters before running the query for the report and therby finding null data for one of the parameters? May need to do a save before opening report...

In the database window, select "Macros" Under Macros, select the macro you want to edit and click on "Design" Select the first line in the macro and click on "Insert" (at the top of the screen), then Rows Under Action, select "SetWarnings" In Action Arguments (at bottom of macro design screen)...

Try this to prevent the auto print: DoCmd.OpenReport DocName, acPreview, , RptWhere Word should be opening upon output because of your "True" at the end of your OutputTo line. May need to try "RichTextFormat(*.rtf)" in place of acFormatRTF. Or you may be catching an error with your filename...

Nick, You can create a command button on your form to print a specific record (one that is displayed), by writing a macro to "OpenReport" with a Where statement isolating your report data to a unique field from your form (i.e. ID): "[ID]=[Forms]![FormName]![ID]. Then use "OutputTo" to...

Okay... Assuming your sub-report is based on a query, add a field to your query with a set value (i.e. Hold: "a"). Then on the sub-report, create a group set on "Hold" with a header. Set header to repeat section and you should be cooking with gas!:D

Why not just use Page Header??

Rotating the image before saving it is a little more user-intensive than what I was hoping for - picture the people at the counter at the DMV doing this for each ID / License they make... that's pretty much where I'm at. Any other possibilities?? Thanks though - appreciate any and all...

I managed to rotate all of my text just peachy for side 2 of my ID badge printing report - however... The sig image (image stored in the table) needs rotated 90 degrees as well. The rotation I used for the text (label) fields will not work on the image. Any suggestions here would be GREATLY...

Really appreciate the quick response and great suggestions. I will try to work with the text rotation idea and hope that it will apply equally as effectively to the image fields. The mail merge and "publish to Word" functions, however, do not import the image data fields as images. The pic...

I have an ID Badge-creating application outputting to a duplexing badge printer. The front is portrait and the back is landscape. The printer will not pause between front and back, and always prints a "page one" on a badge front, and a "page two" on a back; thus trying to force two...