Recent content by Freelak

D.J. That perameter was set to "none". I have cleared up the problem however. I had turned Report Header/Footer off, thinking this would completely remove these items. I turned them back on and set visible to "no" and height to "0". Now everything prints the way it should. Thank you for...

I tabbed through every item in the report. I found no "HeaderPageBreak". Just the Text, Fields and Picture I added. If I remove the Header or if I make the Page Header not visible, it starts the detail on the first page (but no header of coarse). Thank you for your input

I am having a problem with page headers. I have a report where the detail is over a full page. When I print the report, the first page is only the page header, the second shows the page header again and then the detail (which is what I want on the first page). The third page shows the Page...

Thank You! The report I was using was set for record lock. Changing this took care of the problem. Thank You Again!

Thank you for your reply! I did what you said, created a new form with just 2 fields and the command button. Still got the same error! I did come up with a work around however. Created 2 macros, 1 to copy the table to a "temp" table and another to delete it. I changed the report to use...

I really need some help. I'm getting an error when I try to print a record form a form. This works fine in another database. The database name is CUSTOMER. The command for the action is as follows: stDocName = "Normal" DoCmd.OpenReport stDocName, acViewPreview, , "[CUSTNUMBER] = '" &...

Yes..Yes..Yes! Thank you very much! And again! Freelak

Jack, Thank you very much for your response! I am still having problems… I have used the following line: DoCmd.OpenReport stDocName, acViewPreview, , "[FOOD] =" & Me![Recipe Name] I get the following error returned: Syntax error (missing operator) in query expression '([FOOD] = Greek...

I know this question has probably been asked before, but I just can't figure out how to do this. I want to create a button that will print a report for only the currently displayed record. The wizard creates a button that will print all records. I have triied for hours modifing the code to...