A2007 - open the same form several times

  • Thread starter Thread starter harmi
  • Start date Start date
H

harmi

Hi NG,

has anybody experience with the issue that it's possible to have
the same form opened up more than 1 time in the same Access-Session.

Should this be prevented, means not beeing allowed?

Should it be the standard, that it is only possible to open it once?

What could be the impact of this possible scenario?


Thanks for your input.
Regards
 
harmi said:
Hi NG,

has anybody experience with the issue that it's possible to have
the same form opened up more than 1 time in the same Access-Session.

Should this be prevented, means not beeing allowed?

Should it be the standard, that it is only possible to open it once?

What could be the impact of this possible scenario?

There are certainly some scenarios were allowing the same form to be open
more than once can be really very handy for your end users.

A good example is when they're doing data entry and the phone rings and they
have to bring up another customer using the same form. If you have a design
that allows a form to be open multiple times, then they can simply minimize
the current data form they're working on, and then launch another one and
deal with a customer on the phone.
Should it be the standard, that it is only possible to open it once?

I think it godo the way it is now. You would have a lot of problems in which
users would be opening the same form over and over. You would wind up with a
case in which by the end of the day a user would have the same form opened
25 times. That would mean 25 records that could potentially be opened and
ready to be written back to disk, but not yet saved. Then, you run some
stupid you-tube video and your pc crashes or freezes up. Now, you have 25
records that are not going to be saved.

I guess what I'm saying is that if you're building an application as can
allow the same form to be opened over and over, you better have a real
bulletproof solid stable and good performing application. Well behaved MS
access applications tend to be more reliable than a outlook or word or even
running a web browser.

It can also be confusing for the user because they can potentially open up
to the same record more than once, often a user does something, goes back to
work to do something else, then realizes they have to bring that same record
back up again. If they don't look at what they have open already, then they
simply launch another form. So, it can become like launching multiple web
browsers all day long.

Also keep in mind I think if you're going to allow multiple copies of the
same form to be opened, I think you should adopt a design in which you
launch the form to one record. In fact I explain this classic search for a
record displayed the list, then launch the form to one record in the
following article of mine:

http://www.members.shaw.ca/AlbertKallal/Search/index.html

In the above the user searches for a record, you display the result list,
then they can click on the one record and a form is opened to allow a
editing of that ONE record. This can design works quite well when you allow
the form to be open multiple times because the form only edits ONE reocrd. I
don't believe one should allow record navagation if you allow the same form
to be open multiple times as then they can trip over each other.

Another interesting thing is users tend to perform or prefer a sense of
closure. Thus they seach for a reocrd, display the reocrd, and then do their
work. When they close that form to seach for the next customer (or whatever
they are working with), then they are also FORCED to close the form. This
not only makes them feel better that they just completed a task, they also
are forced to save the reocred by closing the form.

By the way a number of my clients right now often need to open up another
form and I don't allow multiple copies of one form to be opend. So, when I
walk on site, I see them actually running multiple copies of the
application. So in place of modifying existing application to allow multiple
copies of one form to be opened, a simple solution is to just have the
customer launch another copy of your application and they can work with two
people on the phone at once (or whatever reason they don't want to back out
of the current data entry form).
 
Albert gave a really long reply & not sure if he is saying this, but what
about creating another form, using the same table or query? One called Data
Entry and another called Customers or whatever?

Curtis
 
Hello Albert,

thank you for very detailled reply.

I was very happy about that and it gave me the idea,
that i have to change my applications that way,
that one form can not be opened more than 1 time per application.
If it is needed more than a second Access-Session has to be opened.

It also gives me the better feeling because i wonder if ACCESS would
handle that case of the same form being open twice or more the right
way in any case. Maybe i am not too trustful but you never know.

Thanks again and best regards
 
harmi said:
Hello Albert,

thank you for very detailled reply.

I was very happy about that and it gave me the idea,
that i have to change my applications that way,
that one form can not be opened more than 1 time per application.


NO NO NO!!

I said you can allow a form to be opened multiple times, but there is some
ramifications to doing so. And, I made a long post explain that is more of a
user issue.

If it is needed more than a second Access-Session has to be opened.

NO NO NO!

I said if that DO NOT WANT TO MAKE CODE CHANGES TO your existing application
to ALLOW the form to be opened multiple times then a easy simple solution
WITHOUT ANY CODING CHANGES is to simply have the user launch he appcation
again. I did not say "has to be" I said opening the application is a WAY TO
AVOID HAVING TO CHANGE your code to allow a form to be opened multiple
times.

in summary:

It is most certainly possible to allow a form to be opened multiple times,
but I said if you going to allow that, you should have a user interface
designed that **encourages** the user to close that form after they're done
working with that reocrd. All I said in my post was if you don't have a
design that encourages the user to close that form when they're done, at the
end of the day the user will wind up having that same form opens 25 times a
25 different records (it just becomes a very messy situation that's all).

I also simply said that if you don't wanna make the extra effort in code to
allow a form to be open multiple times, then just have the user launch the
application again as that's a lot less work.

However you most certainly can set up your application and set up your
coding practices in which you allow the same form to be opened multiple
times.

So, it is entirely possible!

However, you also asked for my general thorughts on the issue. In other
words, you simply did not ask if this was possible, but you asked for
feedback on the whole idea and you even suggested or asked should it a
default in MS access to allow this. I simply gave the reasons why I thought
that allowing multiple instances of one form to be opened should not be a
default or normal function of MS access.
 
Back
Top