By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,686 Members | 2,392 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,686 IT Pros & Developers. It's quick & easy.

SourceObject relinking not working

P: n/a
I'm inherited a database that has a few issues. One of the less severe
issues, but the one the users bitch about is the speed across the LAN. So I
thought that I could unbind the NUMEROUS subforms on the tab control. So I
unbound the 25+ subforms and added an OnChange event to the Tab Control.
Only about 2/3 of the subforms have reappeared. I've been over the names
again and got a few more working, but there are some that just won't come
back.

Could this be an issue with the child/master links? BTW if I update the SO
in the subform's data properties in design mode the subform pops right back
up again. This db is in A2K.

Any thoughts appreciated.

Nov 13 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
To address your basic issue first: the best collection of information and
links dealing with performance of multiuser Jet databases and avoidance of
corruption is at MVP Tony Toews' site,
http://www.granite.ab.ca/accsmstr.htm.

I am not sure to what "this" refers in your question, "Could this be an
issue with the child/master links?"

In Access, there really isn't something called a "Subform", though we often
use that shortcut terminology. There are Subform Controls, which may display
data in datasheet view, or in which a Form may be embedded.

I also am not sure what you mean when you say you "unbound" the Subforms --
that could, but seems unlikely to, mean that you deleted the Source Object
for the Subform Control; it could also mean that you removed the
RecordSource from the Form embedded in the Subform Control. The
LinkMasterFields and LinkChildFields properties of the Subform Control do
control synchronization of the information displayed on the main Form and
that displayed in the Form embedded in the Subform Control.

Perhaps if you clarify, someone will be able to offer more specific
solutions.

Larry Linson
Microsoft Access MVP

"Bill Stock" <me*@privacy.net> wrote in message
news:39*************@individual.net...
I'm inherited a database that has a few issues. One of the less severe
issues, but the one the users bitch about is the speed across the LAN. So I thought that I could unbind the NUMEROUS subforms on the tab control. So I
unbound the 25+ subforms and added an OnChange event to the Tab Control.
Only about 2/3 of the subforms have reappeared. I've been over the names
again and got a few more working, but there are some that just won't come
back.

Could this be an issue with the child/master links? BTW if I update the SO
in the subform's data properties in design mode the subform pops right back up again. This db is in A2K.

Any thoughts appreciated.

Nov 13 '05 #2

P: n/a
25+ subforms. Good grief. :-)

Sounds like you already know that the name of the subform control may be
different from the name of the form loaded into it (its Source Object.)

When you assign the SourceObject to a subform control, Access will
automagically assign whatever it thinks is appropriate to the
LinkMasterFields/LinkChildFields. Frequently it is not what you want, so you
will need to assign these properties as well to get it to work correctly.

Name AutoCorrect could also interfere with these assignments, so uncheck the
boxes under:
Tools | Options | General | Name AutoCorrect.
For a partial list of the problems this disfeature causes, see:
http://allenbrowne.com/bug-03.html

If you actually only need 1 subform at any one time, another idea is to
place the subform control directly on the main form, i.e. not on a page of
the tab control. Use the same technique - Change event of tab control - to
assign the SourceObject of this generic subform control to the desired one.
That's really efficient on load time and on memory.

For general suggestions about performance, see Tony Toews "Performance FAQ"
at:
http://www.granite.ab.ca/access/performancefaq.htm

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Bill Stock" <me*@privacy.net> wrote in message
news:39*************@individual.net...
I'm inherited a database that has a few issues. One of the less severe
issues, but the one the users bitch about is the speed across the LAN. So
I thought that I could unbind the NUMEROUS subforms on the tab control. So
I unbound the 25+ subforms and added an OnChange event to the Tab Control.
Only about 2/3 of the subforms have reappeared. I've been over the names
again and got a few more working, but there are some that just won't come
back.

Could this be an issue with the child/master links? BTW if I update the SO
in the subform's data properties in design mode the subform pops right
back up again. This db is in A2K.

Any thoughts appreciated.

Nov 13 '05 #3

P: n/a

"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message
news:42***********************@per-qv1-newsreader-01.iinet.net.au...
25+ subforms. Good grief. :-)

Sounds like you already know that the name of the subform control may be
different from the name of the form loaded into it (its Source Object.)
Yeah, these guys never heard of naming conventions. I actually wrote some
code to ferret out the subforms, parent pages and sourceobjects. It was just
too painful doing it manually.

When you assign the SourceObject to a subform control, Access will
automagically assign whatever it thinks is appropriate to the
LinkMasterFields/LinkChildFields. Frequently it is not what you want, so
you will need to assign these properties as well to get it to work
correctly.
I wondered about this, although when I assign the missing ones manually they
pop back up? This will be the next thing I try.
Name AutoCorrect could also interfere with these assignments, so uncheck
the boxes under:
Tools | Options | General | Name AutoCorrect.
For a partial list of the problems this disfeature causes, see:
http://allenbrowne.com/bug-03.html
I've done some tuning on this thing, killing AutoCorrect was one of my first
tasks,
If you actually only need 1 subform at any one time, another idea is to
place the subform control directly on the main form, i.e. not on a page of
the tab control. Use the same technique - Change event of tab control - to
assign the SourceObject of this generic subform control to the desired
one. That's really efficient on load time and on memory.
This beast has up to three subforms per tab.

It will be getting a total rewrite once I can assure them I'm not going to
steal their baby (Rosemary's). :)

For general suggestions about performance, see Tony Toews "Performance
FAQ" at:
http://www.granite.ab.ca/access/performancefaq.htm

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Bill Stock" <me*@privacy.net> wrote in message
news:39*************@individual.net...
I'm inherited a database that has a few issues. One of the less severe
issues, but the one the users bitch about is the speed across the LAN. So
I thought that I could unbind the NUMEROUS subforms on the tab control.
So I unbound the 25+ subforms and added an OnChange event to the Tab
Control. Only about 2/3 of the subforms have reappeared. I've been over
the names again and got a few more working, but there are some that just
won't come back.

Could this be an issue with the child/master links? BTW if I update the
SO in the subform's data properties in design mode the subform pops right
back up again. This db is in A2K.

Any thoughts appreciated.


Nov 13 '05 #4

P: n/a

"Bill Stock" <me*@privacy.net> wrote in message
news:39*************@individual.net...
I'm inherited a database that has a few issues. One of the less severe
issues, but the one the users bitch about is the speed across the LAN. So
I thought that I could unbind the NUMEROUS subforms on the tab control. So
I unbound the 25+ subforms and added an OnChange event to the Tab Control.
Only about 2/3 of the subforms have reappeared. I've been over the names
again and got a few more working, but there are some that just won't come
back.

Could this be an issue with the child/master links? BTW if I update the SO
in the subform's data properties in design mode the subform pops right
back up again. This db is in A2K.

Any thoughts appreciated.


OK, this still does not work.

I added the master and child link updates, but still no go. I also tried to
requery the page, but it did not help.

What else could this be? The problem seems to occur more on pages with
multiple 'subforms'.

Nov 13 '05 #5

P: n/a

"Bill Stock" <me*@privacy.net> wrote in message
news:39*************@individual.net...

"Bill Stock" <me*@privacy.net> wrote in message
news:39*************@individual.net...
I'm inherited a database that has a few issues. One of the less severe
issues, but the one the users bitch about is the speed across the LAN. So
I thought that I could unbind the NUMEROUS subforms on the tab control.
So I unbound the 25+ subforms and added an OnChange event to the Tab
Control. Only about 2/3 of the subforms have reappeared. I've been over
the names again and got a few more working, but there are some that just
won't come back.

Could this be an issue with the child/master links? BTW if I update the
SO in the subform's data properties in design mode the subform pops right
back up again. This db is in A2K.

Any thoughts appreciated.


OK, this still does not work.

I added the master and child link updates, but still no go. I also tried
to requery the page, but it did not help.

What else could this be? The problem seems to occur more on pages with
multiple 'subforms'.

Never mind, brain fart. :)

Nov 13 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.