Open two forms at same time

  • Thread starter Thread starter tobesurveyor via AccessMonster.com
  • Start date Start date
T

tobesurveyor via AccessMonster.com

Good Morning to all,

For what I have read and experienced, when running a VBA command it follows a
line by line bases when running the code. I know this is a better way to
explain:

DoCmd.OpenForm "frmLogin", , , , , acHidden <-Runs first
DoCmd.OpenForm "frmMainSwitchboard", acNormal <- Runs second
DoCmd.OpenForm "frmFieldScheduler",acNormal <- Runs third


The forms, frmMainSwitchboard and frmFieldScheduler pull information from the
server backend and have multiple continous subforms so the load time for each
is extensive. The user has to wait form frmMainSwitchboard to load and then
do nothing with this form until frmFieldScheduler loads.

Is there a way to load both of these forms at the same time.


Thanks,
CF
 
tobesurveyor said:
Good Morning to all,

For what I have read and experienced, when running a VBA command it follows a
line by line bases when running the code. I know this is a better way to
explain:

DoCmd.OpenForm "frmLogin", , , , , acHidden <-Runs first
DoCmd.OpenForm "frmMainSwitchboard", acNormal <- Runs second
DoCmd.OpenForm "frmFieldScheduler",acNormal <- Runs third


The forms, frmMainSwitchboard and frmFieldScheduler pull information from the
server backend and have multiple continous subforms so the load time for each
is extensive. The user has to wait form frmMainSwitchboard to load and then
do nothing with this form until frmFieldScheduler loads.

Is there a way to load both of these forms at the same time.
Click to expand...

What you might consider doing is keeping Mainswitchboard hidden, and
then in the code of frmFieldScheduler setting it to visible when it's ok
to use it. Why are you loading FieldScheduler first, if it's required to
be loaded before they can use the switchboard?
 
right now that is how I have it, from the switchboard they can open
FieldScheduler, but it takes about 25-30 seconds to load. My idea as you
mentioned is to open the fieldscheduler on start up and have it hidden. The
problem now is the time to load the switchboard (20 sec) and fieldscheduler
(20 sec) is a bit extensive. I was hoping to be able to try and load both at
the same time to cut down on some of that load time.
Thanks for any ideas you may have in advance,
Chris

Duncan said:
Good Morning to all,
Click to expand...
[quoted text clipped - 12 lines]
Is there a way to load both of these forms at the same time.
Click to expand...

What you might consider doing is keeping Mainswitchboard hidden, and
then in the code of frmFieldScheduler setting it to visible when it's ok
to use it. Why are you loading FieldScheduler first, if it's required to
be loaded before they can use the switchboard?
Click to expand...
 
?A form that takes 25-30 seconds to load? I suspect you have ALL the
underlying records tied to that form. If you opened an "empty" form, it
should be much faster.

Just one person's opinion...


--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/

tobesurveyor via AccessMonster.com said:
right now that is how I have it, from the switchboard they can open
FieldScheduler, but it takes about 25-30 seconds to load. My idea as you
mentioned is to open the fieldscheduler on start up and have it hidden. The
problem now is the time to load the switchboard (20 sec) and fieldscheduler
(20 sec) is a bit extensive. I was hoping to be able to try and load both at
the same time to cut down on some of that load time.
Thanks for any ideas you may have in advance,
Chris

Duncan said:
Good Morning to all,
Click to expand...
[quoted text clipped - 12 lines]
Is there a way to load both of these forms at the same time.
Click to expand...

What you might consider doing is keeping Mainswitchboard hidden, and
then in the code of frmFieldScheduler setting it to visible when it's ok
to use it. Why are you loading FieldScheduler first, if it's required to
be loaded before they can use the switchboard?
Click to expand...
Click to expand...
 
That is not a problem with the switchboard...I will be changing the record
source of three subforms on this form instead of having eight load on open.
I can not do the same for the FieldScheduler for since it acts as a calendar
relating tasking my different crews are going to be completing for the next 5
days. Unless anyone has any ideas of a different approach to this. The
FieldScheduler has 10 subforms each one linked to a different query that
pulls out a date from a text box on the fieldscheduler form and the crewid
from two cmbboxes on the fieldscheduler form. These subforms are requeried
on form open. Because there are so many the time frame to load and requery
is around 20-30 seconds. I am planning on loading it only once in the next
version, but was hoping to not have it pre-load while the application loads.


Jeff said:
?A form that takes 25-30 seconds to load? I suspect you have ALL the
underlying records tied to that form. If you opened an "empty" form, it
should be much faster.

Just one person's opinion...
right now that is how I have it, from the switchboard they can open
FieldScheduler, but it takes about 25-30 seconds to load. My idea as you
Click to expand...
[quoted text clipped - 15 lines]
Click to expand...
 
Back
Top