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

What happens when one saves a form in design mode?

Using Access 2003.

For this application when one enters data and clicks a command button,
code gets run that does the following:

For 5 different combo box controls:
- create a querydef
- querydef is a pass-thru query that calls a stored procedure on a
SQL Server 2000 db
- set rowsource property of combo box to the just-created querydef
- run the requery method of the combo box control

I observed the following:

step 1: enter data and click command button; combo boxes repopulated
after about 4 seconds
step 2: go into design mode of form
step 3: save form (no changes made to form or to the code behind the
form)
step 4: exit Access
step 5: start Access and open app
step 6: enter data (same data st step 1) and click command button;
combo boxes repopulated after about 1/2 second
step 7: exit Access
step 8: start Access and open app
step 9: enter data (same data as step 1) and click command button;
combo boxes repopulated after about 4 seconds

I have replicated these results numerous times, and I have done these
steps at various times throughout the day (trying to rule out the
possibility that slow results were caused because they were run when
lots of system resources in use or network traffic was heavy).
Sometimes, I've run the sequence of steps one step right after
another...other times, I'll introduce a couple hour delay between
steps...same results as far as the time to repopulate combo box
controls.

Questions:
1) If one 'looked under the hood' what would one see Access doing when
one saves a form?
2) Which of the things that Access is doing when one saves the form is
causing the much snappier response time (from 4 seconds down to 1/2
second) the next time the app is run?
3) Is it possible to replicate in code whatever stuff that Access is
doing...the stuff that is causing the snappier response time?

Thank you.
Jan 8 '08 #1
0 1165

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

Similar topics

121
by: typingcat | last post by:
First of all, I'm an Asian and I need to input Japanese, Korean and so on. I've tried many PHP IDEs today, but almost non of them supported Unicode (UTF-8) file. I've found that the only Unicode...
2
by: Ray | last post by:
Stop me if you've heard this, but I am running Access 2002 and all of a sudden, if I design a particular form (it's been working fine for ages), Access crashes rather than open it in design view. ...
6
by: allyn44 | last post by:
HI--what I am trying to do is 2 things: 1. Open a form in either data entry mode or edit mode depending on what task the user is performing 2. Cancel events tied to fields on the form if I am in...
0
by: Ryan Liu | last post by:
I have a user control, it must set a property when it is just created, so I set it in its constructor, which has an parameter to specify the property . For example: public class ExecQuest :...
8
by: Ravi Ambros Wallau | last post by:
Hey guys: What can I do when an "Error Creating Control" is displayed on the form (instead of the control), and a tooltip indicating the error never is displayed? Is there some log, some hidden...
4
by: Altman | last post by:
I want to start a timer when an object loads, so I put the code to start it in the constructor. The problem I am having is that when I put the object on a form in development it starts the timer. ...
39
by: windandwaves | last post by:
Hi Folk I have to store up to eight boolean bits of information about an item in my database. e.g. with restaurant drive-through facility yellow windows
5
by: Bob Bridges | last post by:
Start with two tables, parent records in one and child records in the other, a one-to-many relationship. Create a select statement joining the two. Display the query in datasheet mode. When I...
7
by: Michiel Rapati-Kekkonen | last post by:
Hi, I would like my record to be saved only when my own close button (with all it's checks) is used. I made the winodws close button disappear, but you still can close using the right mouse...
0
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,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
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...
0
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...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
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...
0
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...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

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.