Re: bound form data entry = yes network traffic
- From: "Albert D. Kallal" <PleaseNOOOsPAMmkallal@xxxxxxx>
- Date: Fri, 26 Jun 2009 03:26:27 -0600
I know that on a bound form setting the data entry property to yes
prevents
the form from displaying any records. I'm assuming this means no records
are
transferred over the WAN. Is that correct?
You can also open the form in add-mode. Eg:
DoCmd.OpenForm "Contacts", acNormal, , , acFormAdd
So, for the most part, yes you are correct.
In an effort to reduce network traffic, many of my colleagues use unbound
forms and vba/sql to insert the data entered into the form to an Access
back-end table (split database). But in so doing they lose the benefits of
bound forms.
Yes, and often this approach will save you any bandwidth.
lets see:
create query....open table...load data. (network traffic)
write bunch of code to fill up un-bound form
now, to save:
create query, open table ...write data.... (whole bunch more network
traffic). If one is not carful, all that code to open up and pull the data
will cause additional overhead then simply having the form bound in the
first place (you not be opening + closing the table).
All that opening and creating of queries can often wind up causing MORE
traffic then just using bound form. The trick here is ALWAYS open the form
to the ONE record you need. so, simply "ask" the user for the one record
first. I explain this concept here:
http://www.members.shaw.ca/AlbertKallal/Search/index.html
You might consider other solutions for wan...I explain the problems and
solutions here:
http://www.members.shaw.ca/AlbertKallal//Wan/Wans.html
--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKallal@xxxxxxx
.
- References:
- Prev by Date: Re: Command Button "Find"
- Next by Date: Re: Click Event for Subform
- Previous by thread: Re: bound form data entry = yes network traffic
- Next by thread: need form to start with new entry
- Index(es):
Relevant Pages
|
