Thanx Clive...
Well....I just want to force user to can not do anything (like clicking the form...)
except print the report during the report is opened...
but as you said about acDialog,...i think i have to use acWindowNormal and add more line with Me.Visible=false
on the button on the form....thank you for the direction...
Regards
Hendra
________________________________
Dari: Clive <zctek@aol.com>
Kepada: MS_Access_Professionals@yahoogroups.com
Dikirim: Minggu, 22 April 2012 17:24
Judul: Re: Bls: [MS_AccessPros] MinMaxButtons in VBA
Hi Hendra,
If you use acDialog then you will only get the
Resize and Close Buttons. That is what a
DialogBox gives you.
Why can't/don't you use acWindowNormal?
Regards, Clive.
--- In MS_Access_Professionals@yahoogroups.com, Agestha Hendra <agesthahendra@...> wrote:
>
> Thank you Crystal..
> Yes, i always do that, but if we use "acDialog" like : Â Â Â DoCmd.OpenReport stDocName, acPreview, , , acDialog
> the MinMaxButtons is setted to "none" every time we open the report (the MinMaxButton is disappear).
> Please direct me...thank you
> Regards
> Hendra
>
>
>
> ________________________________
> Dari: Crystal <strive4peace2008@...>
> Kepada: "MS_Access_Professionals@yahoogroups.com" <MS_Access_Professionals@yahoogroups.com>
> Dikirim: Kamis, 19 April 2012 23:23
> Judul: Re: [MS_AccessPros] MinMaxButtons in VBA
>
>
> Â
> Hi Hendra,
>
> You can set the MinMaxButtons property only in form Design view.
>
> Warm Regards,
> CrystalMicrosoft MVP, Access
> remote training and programming
>
> www.AccessMVP.com/strive4peace
>
> www.YouTube.com/LearnAccessByCrystal
> www.YouTube.com/LearnByCrystal
>
> * (:Â have an awesome day :) *
>
> ________________________________
> From: "agesthahendra
>
> Hi All,,,
>
> How is the syntax to set MinMaxButtons Report Property in VBA...?
> I've tried to write the codes on Report Open like this :
>
> Private Sub Report_Open()
> Me.MinMaxButtons = "Both Enabled"
> 'or
> 'Me.MinMaxButtons = 3
>
> End Sub
>
> but it gives erorr...
> Thank you for your attention...
>
> Regards
> Hendra
>
> [Non-text portions of this message have been removed]
>
>
>
>
> [Non-text portions of this message have been removed]
>
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar