473,322 Members | 1,480 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,322 software developers and data experts.

Pausing until a form has fully loaded

I have a form in a database that is opened by the start up property in
access, when this form is opened it fires off a batch of queries which all
do there job happily munching away on my data.
As I am starting these queries by the "on load" property of the form they
start running before the form has a chance to fully display on the screen.
Is there an easy way to pause the functions for a short time to allow the
form to display?
I have looked at the sleep cmd however I am not having much luck.

Any ideas would be greatly appreciated.

Sep 7 '06 #1
2 5191
Mark W wrote:
I have a form in a database that is opened by the start up property in
access, when this form is opened it fires off a batch of queries
which all do there job happily munching away on my data.
As I am starting these queries by the "on load" property of the form
they start running before the form has a chance to fully display on
the screen. Is there an easy way to pause the functions for a short
time to allow the form to display?
I have looked at the sleep cmd however I am not having much luck.

Any ideas would be greatly appreciated.
Try putting a line...

Me.Visible = True

....before the lines that run the queries.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
Sep 7 '06 #2
Thanks for the heads up!

"Mark W" <wi*****@dodo.com.auwrote in message
news:44***********************@lon-reader.news.telstra.net...
>I have a form in a database that is opened by the start up property in
access, when this form is opened it fires off a batch of queries which all
do there job happily munching away on my data.
As I am starting these queries by the "on load" property of the form they
start running before the form has a chance to fully display on the screen.
Is there an easy way to pause the functions for a short time to allow the
form to display?
I have looked at the sleep cmd however I am not having much luck.

Any ideas would be greatly appreciated.

Sep 7 '06 #3

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

Similar topics

12
by: Simon John | last post by:
I'm writing a PyQt network client for XMMS, using the InetCtrl plugin, that on connection receives a track length. To save on bandwidth, I don't want to be continually querying the server for...
1
by: Jehan | last post by:
At the end of my HTML page I have following..... <script> for (i = 0; i < document.section_entry.length;i++) { // some code } </script>
5
by: sonic_soul | last post by:
Hello, I am finishing up creating a fairly complex page that is very rich in DHTML. In addition to updating it self every couple of seconds, various components on it support sync and async...
0
by: Fenno | last post by:
I have an ASP.NET web application that contains some pictures that sometimes take several seconds to load. These pictures are contained in user controls on the page (if that makes any difference)....
2
by: Dave Harris | last post by:
I am having a bit of trouble with form manipulation. I am working on a program where the user opens one form and when all the processes are done, he/she clicks on "Continue" which opens the next...
10
by: B-Dog | last post by:
I want to run something once my form in completely loaded and drawn but running at the end of form load doesn't do I guess cause of the large dataset fill and the form isn't fully loaded. Where...
1
by: Chris | last post by:
Can anyone recomend the best way of disabling a button a page until it is fully loaded? Would it need to be done with Javacript?
0
by: Grayzag | last post by:
Hi there, As part of my Software course, i have to create a game. Since I originally started out with python, I was used to it being really easy to create a main loop to control the game with a...
12
by: greg | last post by:
Hi, Can anyone help me with the following issue: How can I pause the execution of a program until a given file is created (by another process) in a specified directory? Any ideas would be...
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...
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...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
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: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
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.