Hi Could someone assist -
When user preview the Report, he or she can right-click to change the report.
how can I disable the Report Design option to prevent them from changing ?
After closing the preview report and return to the main form, I notice the main form size or position change, is there anyway I can maintain the original size of the main form?
5  4673  
Hi Could someone assist -
When user preview the Report, he or she can right-click to change the report.
how can I disable the Report Design option to prevent them from changing ?
After closing the preview report and return to the main form, I notice the main form size or position change, is there anyway I can maintain the original size of the main form?
1. to prevent the design button from showing up on the shortcut menu, you need to customize the toolbar and menubar to what you want the users to have access to. To customize, go to the command menu, click view> toolbars> check one of the default toolbars or customize your own. Further, you can set the startup properties of your application by clicking Tools>Startup> unchceck allow toolbar changes <and other items as desired. this will prevent the user from being able to go to the Command menu, click View and override your settings.
2. to prevent size or position changes on the main form, place form in design view, invoke property sheet and set the following properties:
Auto Resize = No
Auto Center = No
Min Max buttons = NO
1. to prevent the design button from showing up on the shortcut menu, you need to customize the toolbar and menubar to what you want the users to have access to. To customize, go to the command menu, click view> toolbars> check one of the default toolbars or customize your own. Further, you can set the startup properties of your application by clicking Tools>Startup> unchceck allow toolbar changes <and other items as desired. this will prevent the user from being able to go to the Command menu, click View and override your settings.
2. to prevent size or position changes on the main form, place form in design view, invoke property sheet and set the following properties:
Auto Resize = No
Auto Center = No
Min Max buttons = NO
when you have satisfied yourself that your db is where you want it to be functionally, explore splitting the database into front and backends and distributing an mde file instead which will prevent users changing anything of your form or report designs. You can keep the mdb file then for development only as the master file
Regards
Jim :)
1. to prevent the design button from showing up on the shortcut menu, you need to customize the toolbar and menubar to what you want the users to have access to. To customize, go to the command menu, click view> toolbars> check one of the default toolbars or customize your own. Further, you can set the startup properties of your application by clicking Tools>Startup> unchceck allow toolbar changes <and other items as desired. this will prevent the user from being able to go to the Command menu, click View and override your settings.
2. to prevent size or position changes on the main form, place form in design view, invoke property sheet and set the following properties:
Auto Resize = No
Auto Center = No
Min Max buttons = NO
Hi, thank you for your prompt reply, I follow your method to disable the print design it work ! as for setting the 3 options,it seem to shrink after closing the Report Preview.
when you have satisfied yourself that your db is where you want it to be functionally, explore splitting the database into front and backends and distributing an mde file instead which will prevent users changing anything of your form or report designs. You can keep the mdb file then for development only as the master file
Regards
Jim :)
Thanks you so much will try it out
Hi, thank you for your prompt reply, I follow your method to disable the print design it work ! as for setting the 3 options,it seem to shrink after closing the Report Preview.
Did you try sizing the form to the size you want, saving it, and then testing print preview?
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Ranman |
last post by:
Hi all,
I have a simple problem that hopefully has a simple solution, but I
have yet to figure it out. In a patient database, I have a physician
test order form that populates a report that is...
|
by: Nathan Bloomfield |
last post by:
Does anyone know if there is any documentation which relates to Access2k + ?
or can anyone help adjust the code?
I am having trouble converting the DAO references.
TITLE :INF: How to...
|
by: Regnab |
last post by:
I've made an access report which shows the number of people in 5
activities. As you can imagine, it only takes up about a quater of the
page. I have to give a copy of this report to two people, and...
|
by: Thad |
last post by:
I'm new to C# and I was trying to create a Crystal Report. I've
designed a simple report and I've used several methods for attaching
fields to the report at design time. I've used a DataSet that...
|
by: Lars Netzel |
last post by:
Hello,
Making your own WebCustomControl, how you do disable properties in the
design view?
For example my WebCustomControl does not use text, so the default property
Font is missleading when...
|
by: vermutmb |
last post by:
I'm totally stuck. When I click on the "Preview" button for a report
on the
database window, pressing the <ESCAPEkey simply closes the report.
But
when I use DoCmd.OpenReport with acPreview on a...
|
by: DeniseY |
last post by:
I have an Access report that is created on the fly by the user selecting the fields to be included. The Access report comes out fine, but I want it to automatically output to an Excel spreadsheet....
|
by: creative1 |
last post by:
Here is how you create a complex data report that involves parent and child commands and you can update information at runtime. Its pretty straight forward to work with simple queries; however,...
|
by: Tudor |
last post by:
Hi All. I'm new to this forum (as a registree) although I do come by here to find answers which I do always find. I thought I'd post a question and see if anyone can help!
I'm developing a DB in...
|
by: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
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: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
| |
