Code:
Private Sub CommandBtn_Click() Dim MyForm As Form Set MyForm = Screen.ActiveForm DoCmd.SelectObject acForm, MyForm.Name,
nuwan1988
Last Activity: May 9 '14, 10:41 AM
Joined: Apr 21 '14
Location:
-
i want to print active form with its active record......
i want to print active form with active record in access 2010. i used the following cord to print my form, it's working, but it is always print first record of the database only. active record of the form didn't print. what is the reason for that. please give me the solution to fix my problem..
...Last edited by zmbd; Apr 26 '14, 03:16 PM. Reason: [Z{Please use the [CODE/] button to format posted script and formated text - Please read the FAQ}] -
in the printing of the access form get error dialog box
in the printing of the access form using following cord.. get error........
Code:Private Sub CommandBtn_Click() Dim MyForm As Form Set MyForm = Screen.ActiveForm DoCmd.SelectObject acForm, MyForm.Name, True DoCmd.PrintOut DoCmd.SelectObject acForm, MyForm.Name, False End Sub
the error is...
''the object you referenced in the visual basic procedure as an OLE object isn't an OLE...Last edited by Rabbit; Apr 25 '14, 05:30 PM. Reason: Please use [code] and [/code] tags when posting code or formatted data. -
how to put a code in to the on click event of the command button?
i want to print my access form page with its details. i have got the following code and now i want to put this code to the on click event...
Code:Private Sub CommandBtn_Click() Dim MyForm As Form Set MyForm = Screen.ActiveForm DoCmd.SelectObject acForm, MyForm.Name, True DoCmd.PrintOut DoCmd.SelectObject acForm, MyForm.Name, False End SubLast edited by Rabbit; Apr 21 '14, 03:34 PM. Reason: Please use [code] and [/code] tags when posting code or formatted data.
No activity results to display