jyrilepisto
New member
- Local time
- , 00:54
- Joined
- Apr 19, 2014
- Messages
- 6
I have report that i have in preview. In that report i have ribbon that has buttons close and print. Close works fine, with print it goes ok but when "printer selection" comes, i try to change printer it informs that not enough memory. All this code that is in ribbon buttons is in VBA.
What could be the reason for memory stuff or how could this be made that this inform wouldn´t come.
Code below:
Sub EnnakkoMyButtonCallbackOnAction(control As IRibbonControl)
Select Case control.ID
Case "MyBtn1"
DoCmd.OpenReport "Tuotanto Ennakko", acViewPreview
DoCmd.RunCommand acCmdPrint
Case "MyBtn2"
DoCmd.OpenForm "TuotantoEnnakko", acNormal, "", "", acEdit, acNormal
DoCmd.Close acReport, "Tuotanto Ennakko"
End Select
End Sub
Thank you for advance.
What could be the reason for memory stuff or how could this be made that this inform wouldn´t come.
Code below:
Sub EnnakkoMyButtonCallbackOnAction(control As IRibbonControl)
Select Case control.ID
Case "MyBtn1"
DoCmd.OpenReport "Tuotanto Ennakko", acViewPreview
DoCmd.RunCommand acCmdPrint
Case "MyBtn2"
DoCmd.OpenForm "TuotantoEnnakko", acNormal, "", "", acEdit, acNormal
DoCmd.Close acReport, "Tuotanto Ennakko"
End Select
End Sub
Thank you for advance.