MS Access Calendar Error when Printing

[RockKandee]

Hi,

I am getting an error message when trying to print.

I am using the MS access calendar found here:

http://bytes.com/topic/access/answer...ccess-calendar

I have Windows 8 and Office/Access 2013. I am using this in a desk top database and would like to transfer it to a web database in the future.

I want to print this calendar. I haven't found a way to make a report so I tried to print the form. I get an error message when I select print and the same error message each time I open a table (or anything else) from then on. Once I close and reopen the database, all is good again until I try to print.

Error message:
Error inPopulateCalen dar()
Invalid use of Null

Is there a solution for this?

Thanks for your time.

[ADezii]

Have you tried:

Application.Printers("Printer Name").Orientation = acPRORLandscape
  DoCmd.PrintOut
Application.Printers("Printer Name").Orientation = acPRORPortrait

[RockKandee]

I am very, VERY new at this. No I hadn't tried but I have now - I think.

I am not sure what I was supposed to do with this code. I assumed I should pick either the landscape or portrait, not use both, though I did try with both. I used the printer name exactly how it is displayed on the printer drop down where I choose which printer to print with. I made a command button on the calendar form and entered the below code in the on click.

DoCmd.PrintOut "Application.Printers("HP Deskjet 3050A J611 series (Copy 1)").Orientation = acPRORLandscape"

I followed examples of other code to the best of my understanding. I received the following error

Compile Error: Syntax error

Not sure if the code has errors because of the spaces in the printer name and if so, I don't know what to do.

Thanks

[PPelle]

Remove the first and the last ", like this:

DoCmd.PrintOut Application.Printers("HP Deskjet 3050A J611 series (Copy 1)").Orientation = acPRORLandscape

[RockKandee]

I removed the first and last " like this

DoCmd.PrintOut Application.Printers("HP Deskjet 3050A J611 series (Copy 1)").Orientation = acPRORLandscape

I no longer receive an error message - Thank you.

It is going directly to print and printing 4 pages. I do not want 4 pages printed. I only want to print the current page. The print message that pops up after I click the print button flashes too fast for reading. Maybe I need to go to print preview instead of directly to print.


I found this in another post and tried it.

DoCmd.RunCommand acCmdPrintPreview

This results in giving me the original error message...

Error message:
Error inPopulateCalen dar()
Invalid use of Null

[PPelle]

The error is caused by the Form_Activate procedure. But printing the form is to no use anyway, since it is unbound, all fields will be empty in the printout. You will need to design a report based on the table which holds the data you want.

Maybe it would be easier for you to try another calendar, like this one, which has a nice report included.

[RockKandee]

Thanks for the link. That looks like a great calendar for anyone looking to replace their Outlook Calendar. I am sure I will find a use for it in the future.

Now back to the original calendar....If I print the calendar form, it DOES display the data. The error message is occurring with print preview only. No one else should need to preview, so I can live with the error.

I would like to avoid printing 4 pages though. Is their code to add to the print command so that only page 1 will print?

Thanks

[ADezii]

I use a primitive, but very effective means to Print the Access Calendar as long as there is no data that extends vertically beyond the Date Blocks.

1. Make sure that the Calendar Form is the Active Window and is centered.
2. Perform a Screen Capture of the Active Window (Calendar) via ALT+PRTSCRN.
3. Open Microsoft Word, set the Margins to .5 all around and Landscape Orientation.
4. Center the Cursor.
5. Paste the Image of the Active Window (Calendar) from the Clipboard (CTRL+V).
6. Of course I could use Automation Code to perform the above but it seems hardly worth it since the operation only takes a few seconds and the results are great.

[PPelle]

If I print the calendar form, it DOES display the data.

That's right, if you do a direct print. Printpreview will interfere with the data population, and give you the error you see and no data in the report.

This will open the print dialog (Access 2003, hopefully in 2013 also), where you can adjust margins so the form will fit on one page:

DoCmd.RunCommand acCmdPrint

[RockKandee]

I would rather not have users go through a process to print a page just to avoid 3 pieces of paper running through the printer.

DoCmd.RunCommand acCmdPrint

This command will not allow for margin adjustment in Access 2013. It will allow print range though, but the user would need to know to only print page 1.

I can't avoid the error message when setting margins, but they are already set and should remain fine unless I re-size the calendar again. The user will not need to use print preview so I will look into a way to disable the feature to avoid error messages.

I will continue looking around for printing code so only page 1 will print. Maybe this info is out there somewhere.

For now I will just deal with the extra 3 pages when printing.

Thank you all for the help and for your time.