M
MBParker
MS Publisher "Select Table" won't list views (queries) containing
user-defined functions?!
What's wrong? And how to work around this?
Using the latest version of Microsoft Publisher and MS Access (2003 sp2
with all latest updates), I am trying to create physical asset labels,
with a unique serial number on each label.
And in Microsoft Publisher, when I go to "select data source" and
select my MS Access database "20060117pst2301pmb primary.mdb" (which
generates such serial numbers), I get a popup entitled "Select Table"
which lists all its tables, plus all its views *which do not have any
user-defined functions" (though it doesn't warn its making such a
filtering).
However, I am creating globally unique serial numbers on the fly (one
for each physical asset label), which requires (it would seem) a
user-defined function.
What's wrong? And how to work around this?
(1) I tried sneaking in my user-defined function into the view after
MS Publisher had linked with to the view, but then view becomes empty
and the connection breaks.
(2) Alternatively, every time I want to print asset labels, I could
first open the MS Access database and do a make-table query (to
physically store the view into a real table); but this is wasteful, and
problematic (what if the same serial number gets printed twice?).
(3) Or I could just produce the labels within MS Access, since
fortunately they're simple-enough in design. But I'm still curious...
What's wrong? And how to get MS Publisher to use as a data source a
view with user-defined functions? Thanks!
PS: Include your Paypal email and I'll send you some $ for good
answers!
-Mike Parker, www.Cytex.com
user-defined functions?!
What's wrong? And how to work around this?
Using the latest version of Microsoft Publisher and MS Access (2003 sp2
with all latest updates), I am trying to create physical asset labels,
with a unique serial number on each label.
And in Microsoft Publisher, when I go to "select data source" and
select my MS Access database "20060117pst2301pmb primary.mdb" (which
generates such serial numbers), I get a popup entitled "Select Table"
which lists all its tables, plus all its views *which do not have any
user-defined functions" (though it doesn't warn its making such a
filtering).
However, I am creating globally unique serial numbers on the fly (one
for each physical asset label), which requires (it would seem) a
user-defined function.
What's wrong? And how to work around this?
(1) I tried sneaking in my user-defined function into the view after
MS Publisher had linked with to the view, but then view becomes empty
and the connection breaks.
(2) Alternatively, every time I want to print asset labels, I could
first open the MS Access database and do a make-table query (to
physically store the view into a real table); but this is wasteful, and
problematic (what if the same serial number gets printed twice?).
(3) Or I could just produce the labels within MS Access, since
fortunately they're simple-enough in design. But I'm still curious...
What's wrong? And how to get MS Publisher to use as a data source a
view with user-defined functions? Thanks!
PS: Include your Paypal email and I'll send you some $ for good
answers!
-Mike Parker, www.Cytex.com