SubDataSheet ability comes and goes without reason

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

topmind - 22 Apr 2008 21:46 GMT

In Access 2003, I have a query that uses a SubDataSheet. The problem
is that the plus sign [+] selection column sometimes shows and
sometimes doesn't. In fact, it seems to alternate when I open the
query view. For example, the first time I open it, the plus won't
appear, but it will the second time, but not the third, etc. Very odd
(pun).

Rebooting didn't fix it.

Thanks
-T-

Reply to this Message

Evi - 01 May 2008 10:17 GMT

I see you haven't had a reply to this yet. I suspect that this may have
something to do with your database design - for instance, it is connecting
to a number which ought to be unique but isn't always.
More on subdatasheets here.
http://www.vb123.com/Toolshed/00_access/subdatasheet.htm

It's usually best to take control of Access's built in features.
Evi

> In Access 2003, I have a query that uses a SubDataSheet. The problem
> is that the plus sign [+] selection column sometimes shows and
[quoted text clipped - 7 lines]
> Thanks
> -T-

Reply to this Message

Evi - 01 May 2008 10:43 GMT

Also, ensure that none of the linking fields are Null by filtering them out
in your query. It's best to ensure that your subdatasheets are based on a
query and linked to other queries rather than directly on a table - but do
beware of this feature. It can slow down performance if used in tables. See
Allen Browne's article on this in
http://allenbrowne.com/bug-09.html

Evi

> I see you haven't had a reply to this yet. I suspect that this may have
> something to do with your database design - for instance, it is connecting
[quoted text clipped - 16 lines]
> > Thanks
> > -T-

Reply to this Message