Error Codes: 2950 & 3270 (1 Viewer)

mlr

Registered User.
Local time
Today, 10:15
Joined
Feb 26, 2011
Messages
16
I got these Errors 2950 (Access 2007) & 3270 (Access 2010) when trying to open a Print Preview of an Active Form.

Did a search and most sites suggest to check the Macro Security, add a Folder as safe in the Trust Centre or to change the setting of the Sandbox Mode in your Registry from 3 to 2.
(Location is safe and the Registry settings are 2)

Playing around a bit I noticed by having my Form Modal set to Yes generate these errors… but as I want it on and an Active Form Print Preview I now have to create a Report for each of them.

Was hoping for a shortcut, is there any way to set the Active Forms Modal back to Yes once the Preview Closes?

'Access 2007
Private Sub PreView_Click()

Me.Modal = False '(Works)
DoCmd.RunCommand acCmdPrintPreview
DoCmd.SelectObject acForm, Screen.ActiveForm.Name, False

End sub

Where can I turn it Back On?

With Access 2010, the above code doesn’t work, db just crashes, (or on a quest to find a solution) - solution now closing db & creating a backup.

Thanks
Mark
 

blu_macey

Registered User.
Local time
Today, 00:15
Joined
Apr 1, 2015
Messages
31
I hope the experts would see these post, for I'm also having this error on my database.
 

JHB

Have been here a while
Local time
Today, 09:15
Joined
Jun 17, 2012
Messages
7,732
Which error do you get, when do you get it and where?
 

blu_macey

Registered User.
Local time
Today, 00:15
Joined
Apr 1, 2015
Messages
31
I have a macro that goes like this,


Code:
OpenReport
  ReportName = Voucher_rpt
  View = Print
  Window Mode = Dialog

RunMenuCommand
  Command SelectRecord

RunMenuCommand
  Command PrintPreview

RunMenuCommand
  Command PrintSelection

And then when I hit the button a dialouge box appear with Macro Single Step as title, then
Action Name: RunMenuCommand
Error Number: 3270
Arguments: 54

Sorry I'm having a hard time posting a Print Screen of the image.

Cheers!
Chino
 

JHB

Have been here a while
Local time
Today, 09:15
Joined
Jun 17, 2012
Messages
7,732
Why do you have:
Code:
  RunMenuCommand  
Command SelectRecord
RunMenuCommand  
  Command PrintPreview
RunMenuCommand  
Command PrintSelection
 

blu_macey

Registered User.
Local time
Today, 00:15
Joined
Apr 1, 2015
Messages
31
Hello JHB,

here is the screen caps.
RunMenuComand came from the print button wizard.
I just copied it to other forms.
macro1.png

macro2.png

macro3.png

Cheers!
Chino
 

JHB

Have been here a while
Local time
Today, 09:15
Joined
Jun 17, 2012
Messages
7,732
What happen if you remove them?
 

Users who are viewing this thread

Top Bottom