PC Review


Reply
Thread Tools Rate Thread

Database window displays when cancelling the fax dialog box

 
 
=?Utf-8?B?QmFycnk=?=
Guest
Posts: n/a
 
      24th Feb 2006
The program i have created is used to create a fax and store the details in
the table. I am using the fax machine provided in the print dialog box that
can be used to send a fax from all microsoft programs but if the user presses
the cancel button on the fax dialog window before sending the fax it allows
the user access to the database window.

the code i am using on the send fax comand button is:

Private Sub cmdSendFax_Click()
On Error GoTo Err_cmdSendFax_Click

Dim stDocName As String
Dim MyForm As Form

stDocName = "FAX"
Set MyForm = Screen.ActiveForm
DoCmd.SelectObject acForm, stDocName, True
DoCmd.PrintOut
DoCmd.SelectObject acForm, MyForm.NAME, False
DoCmd.Close

Exit_cmdSendFax_Click:
Exit Sub

Err_cmdSendFax_Click:
MsgBox Err.Description
Resume Exit_cmdSendFax_Click

End Sub

Has anyone come accross this problem before or can anyone please send me a
fix for this becuase this problem could cause major data loss if users have
access to tables and forms

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Cancelling out of parameter dialog box Sue Microsoft Access 0 8th Jul 2009 07:45 PM
Cancelling directory dialog box Reena Microsoft Excel Programming 1 12th May 2005 07:49 PM
Browser crashes after cancelling Printer Dialog =?Utf-8?B?dmFk?= Microsoft Windows 2000 Fax 1 6th May 2005 10:22 PM
Formula window displays correct answer while cell displays incorre =?Utf-8?B?TU1W?= Microsoft Excel Worksheet Functions 3 10th Nov 2004 09:28 PM
end Macro after cancelling open dialog Microsoft Excel Programming 1 29th Jun 2004 08:58 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:03 PM.