PC Review


Reply
Thread Tools Rate Thread

Close a report & Design Mode

 
 
petrucci
Guest
Posts: n/a
 
      25th Jan 2006
Hi.. i design a report via vba like this:
1) open the report in design mode
2) design
3) open the report in preview mode

Now if a user close this report with close button in the control box it
close but it ask user if he wants to save this report and other forms
that i dont wanna save. If i disable close button
in the control box and user close this report with other close button
(that i created) the report close but it stand open in design mode!!!

How can i do? thanks

 
Reply With Quote
 
 
 
 
Allen Browne
Guest
Posts: n/a
 
      25th Jan 2006
If you have multiple users, you *really* need to split the database, so that
each user has their own copy of the front end. If that is a new idea, see:
Split your MDB file into data and application
at:
http://allenbrowne.com/ser-01.html
That avoids the problems of what other objects you are working on at the
time, as well as a raft of concurrency issues.

Ideally, you will give each user an MDE rather than an MDB. This is a very
simple way to avoid all the issues with users tinkering with your form,
reports, or code. It also avoids the project decompiling, and the attendant
issues and corruptions that can happen with an MDB.

To be able to take advantage of an MDE, you need to use techniques that do
not require opening the report in design view.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"petrucci" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi.. i design a report via vba like this:
> 1) open the report in design mode
> 2) design
> 3) open the report in preview mode
>
> Now if a user close this report with close button in the control box it
> close but it ask user if he wants to save this report and other forms
> that i dont wanna save. If i disable close button
> in the control box and user close this report with other close button
> (that i created) the report close but it stand open in design mode!!!
>
> How can i do? thanks



 
Reply With Quote
 
petrucci
Guest
Posts: n/a
 
      25th Jan 2006
Allen Browne wrote:
>If you have multiple users, [CUT]

i dont have multiple users allen


>you will give each user an MDE rather than an MDB

i cant allen because that is a didactic project

however i appreciate ur response

 
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
Close sub-forms in design mode before attempting to open in formview? Chrisso Microsoft Access Form Coding 1 15th Oct 2008 11:16 AM
How to close form in Design mode Bob Vance Microsoft Access 4 11th Aug 2008 03:23 PM
On close, report goes to DESIGN view =?Utf-8?B?WFA=?= Microsoft Access Reports 2 19th Jun 2007 07:47 PM
Changing from Normal to Design Mode on Close Form chammock@merc.mercer.edu Microsoft Access Forms 0 6th Mar 2006 04:18 PM
How to permanantly close design mode in Word? =?Utf-8?B?T0Q=?= Microsoft Word Document Management 2 1st Feb 2006 09:49 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:35 PM.