473,326 Members | 2,175 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

Access 2000 Disable Close and Minimize Buttons

Hi Everybody

On Report Preview
Does anyone know of a way to disable the Minimum, Maximum and Close
buttons, so that the user cannot close by any other means that the
Toolbar button that I have supplied.

This is easy enough on Access 2000 FORMS in Properties>>Format etc, but
this is not available on a REPORT.

I am trying get the users to close the report USING the Toolbar button
that I have supplied

Regards Bob

Nov 13 '05 #1
3 2953
Hi,

maybe this link will be usefull for you.

http://www.mvp-access.com/accessvbaf....asp?pagina=71

there is a function called ActivateControlBox that deactivates/activates the
menu, close, minimize and maximize buttons of a standard window. It is
prepared to use it with Access main window, but it is easy to transform it
for using with reports or forms windows. You only have to change the value
of the hWnd variable:

hWnd = Access.hWndAccessApp

with the value of the hwnd property of your report or your form

HTH
--
Saludos,
Juan M Afan de Ribera
[MVP Access]
http://www.mvp-access.com/accessvbafaq
http://www.mvp-access.com/juanmafan

"bobdydd" <re**************@yahoo.co.uk> escribió en el mensaje
news:11**********************@g44g2000cwa.googlegr oups.com...
Hi Everybody

On Report Preview
Does anyone know of a way to disable the Minimum, Maximum and Close
buttons, so that the user cannot close by any other means that the
Toolbar button that I have supplied.

This is easy enough on Access 2000 FORMS in Properties>>Format etc, but
this is not available on a REPORT.

I am trying get the users to close the report USING the Toolbar button
that I have supplied

Regards Bob

Nov 13 '05 #2
Thanks for the reply Juan

I will certainly try this.

Bob

Nov 13 '05 #3
> On 23-10-05 13:57, in article
11**********************@g44g2000cwa.googlegroups. com, "bobdydd"
<re**************@yahoo.co.uk> wrote:
Hi Everybody

On Report Preview Does anyone know of a way to disable the Minimum, Maximum
and Close buttons, so that the user cannot close by any other means that the
Toolbar button that I have supplied.

This is easy enough on Access 2000 FORMS in Properties>>Format etc, but this
is not available on a REPORT.

I am trying get the users to close the report USING the Toolbar button that I
have supplied

Regards Bob

Nov 13 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

6
by: Peter Frost | last post by:
Please help I don't know if this is possible but what I would really like to do is to use On Error Goto to capture the code that is being executed when an error occurs. Any help would be much...
1
by: lauren quantrell | last post by:
Before getting pistol whipped, I know this is a well-worn topic but I don't see the answer... I know how to hide the Access window, I know how to disable the Access application's close button, but...
0
by: Bill | last post by:
Hi I have a parent child forms. I want the close, maximize, and minimize buttons to be removed. One the child form I have set the maximize and minimize buttons to false. I have the child form...
2
by: Sharon | last post by:
In the Form there is the Control/System menu. I wish to prevent this system menu from poping-up although the minimize, maximize and close buttons is still shown on the Form caption bar. How can...
3
by: Max Powers | last post by:
Hello all, we finally upgraded our system so now our data is on a SQL 2000 database and our front end is on an Access 2000 database. Everything's looking good so far, but there's this little issue...
15
by: ApexData | last post by:
Hello I'm using Access2000, SplitDB, ALL MenuBars are Off. The AccessTitleBar(BlueBar) displays at the top with its (Min/Max/) Controlbox. I have a MainMenuForm (Modal-On), that Calls a...
10
by: Walshi | last post by:
Hi all, I'm a relative newby to access and VBA etc. My forms and tables etc are working great and saving lots of time...However... I have two databases with the exact same table format. I want...
2
by: Wayne | last post by:
I've been having a click around Access 2007 this afternoon and have discovered some things that range from annoying to alarming. My Access 2003 menu bars, which I, like many others, use...
5
by: Tony | last post by:
I am continuing to develop an Access 2007 application which was originally converted from Access 2003. In Access 2003 I was able to disable the Access Close button in the top righthand corner of...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.