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

A'2003; SourceObject = Query.MyQuery (BUG!) (?)

P: n/a
I have read last news, but not found same trouble ...

I have a form with subform control used to put in some report-querys ...

for example:

Private Sub List0_AfterUpdate()
Me.sfrm1.SourceObject = "Query." & Me.List0.Value
End Sub

if those querys are with subquerys:

Select ... From (Select ...) tmp Where ...

that access used to change them to:
Select ... From [Select ...]. as tmp Where ...

or Union:

Table qrView1
UNION ALL
Table qrView2
UNION ALL
Table qrView3
...

(or: Select * ... Union All Select * ...)
and if we change ColumnWidth or ColumnOrder of any column in that subform
manualy and save changes (lets say: clicking YES after closing main form)
the current query will be corrupted by setting its SQL to "empty"
"SELECT;"

I use polish version of A'2003 SP1
Do You have the same problem in other localized versions ?
Can You inform MS of that problem ?

--
KN
(sorry for my poor english)

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


P: n/a
Juzer Krzysztof Naworyta <k.********@datacomp.com.pl> napisał

thank You, anybody !

--
KN

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.