Access XP weirdness ...

[JustMe]

I don't know if this has anything to do with AccessXP running on Terminal
Services with Access97/2000 also installed, but here is one example of a
query that does not work any longer:

SELECT DLookUp("MajorC ategory","AutoT ypes","[autoType]='1'") AS
MajorCategory, PreOwned.PaintC olor
FROM PreOwned;

When I try to run the above query I get the following error:

UNKNOWN FUNCTION NAME

If I execute the exact same dlookup from the immediate window, the proper
data is returned with no error.

Any suggestions? I have very little hair left on my head after this!!!

Thanks,
--Terry



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.516 / Virus Database: 313 - Release Date: 9/2/2003

[Wayne Morgan]

Re: Access XP weirdness ...

Even without a space in the name, I think it wants brackets around the field name.

DLookUp("[MajorCategory]", "Auto Types", [auto Type]='1'")

--
Wayne Morgan
Microsoft Access MVP


"JustMe" <temilson@saskt el.net> wrote in message news:vpir7hq6hq hg54@corp.super news.com...[color=blue]
> I don't know if this has anything to do with AccessXP running on Terminal
> Services with Access97/2000 also installed, but here is one example of a
> query that does not work any longer:
>
> SELECT DLookUp("MajorC ategory","AutoT ypes","[autoType]='1'") AS
> MajorCategory, PreOwned.PaintC olor
> FROM PreOwned;
>
> When I try to run the above query I get the following error:
>
> UNKNOWN FUNCTION NAME
>
> If I execute the exact same dlookup from the immediate window, the proper
> data is returned with no error.
>
> Any suggestions? I have very little hair left on my head after this!!!
>
> Thanks,
> --Terry
>
>
>
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.516 / Virus Database: 313 - Release Date: 9/2/2003
>
>[/color]

[JustMe]

Re: Access XP weirdness ...

Hi Wayne ...

Thanks for your reply. I tried surrounding ALL the fields with brackets
with no success. I still get the UNKNOWN FUNCTION NAME error.

Any other suggestions? Anyone?

The same query works fine on other machines running AccessXP. I've tried
uninstalling/reinstalling XP. I've tried everything I can think of.

Help!

"Wayne Morgan" <comprev_gothro ughthenewsgroup @hotmail.com> wrote in message
news:a8emb.1440 2$Qv6.12067@new ssvr33.news.pro digy.com...[color=blue]
> Even without a space in the name, I think it wants brackets around the[/color]
field name.[color=blue]
>
> DLookUp("[MajorCategory]", "Auto Types", [auto Type]='1'")
>
> --
> Wayne Morgan
> Microsoft Access MVP
>
>
> "JustMe" <temilson@saskt el.net> wrote in message[/color]
news:vpir7hq6hq hg54@corp.super news.com...[color=blue][color=green]
> > I don't know if this has anything to do with AccessXP running on[/color][/color]
Terminal[color=blue][color=green]
> > Services with Access97/2000 also installed, but here is one example of a
> > query that does not work any longer:
> >
> > SELECT DLookUp("MajorC ategory","AutoT ypes","[autoType]='1'") AS
> > MajorCategory, PreOwned.PaintC olor
> > FROM PreOwned;
> >
> > When I try to run the above query I get the following error:
> >
> > UNKNOWN FUNCTION NAME
> >
> > If I execute the exact same dlookup from the immediate window, the[/color][/color]
proper[color=blue][color=green]
> > data is returned with no error.
> >
> > Any suggestions? I have very little hair left on my head after this!!!
> >
> > Thanks,
> > --Terry
> >
> >
> >
> > ---
> > Outgoing mail is certified Virus Free.
> > Checked by AVG anti-virus system (http://www.grisoft.com).
> > Version: 6.0.516 / Virus Database: 313 - Release Date: 9/2/2003
> >
> >[/color]
>
>[/color]


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.516 / Virus Database: 313 - Release Date: 9/2/2003

[JustMe]

Re: Access XP weirdness ...

By the way, the exact same query works fine in Access 97 on the same
machine.

Terry
"JustMe" <temilson@saskt el.net> wrote in message
news:vpis7t8grk 4h66@corp.super news.com...[color=blue]
> Hi Wayne ...
>
> Thanks for your reply. I tried surrounding ALL the fields with brackets
> with no success. I still get the UNKNOWN FUNCTION NAME error.
>
> Any other suggestions? Anyone?
>
> The same query works fine on other machines running AccessXP. I've tried
> uninstalling/reinstalling XP. I've tried everything I can think of.
>
> Help!
>
> "Wayne Morgan" <comprev_gothro ughthenewsgroup @hotmail.com> wrote in[/color]
message[color=blue]
> news:a8emb.1440 2$Qv6.12067@new ssvr33.news.pro digy.com...[color=green]
> > Even without a space in the name, I think it wants brackets around the[/color]
> field name.[color=green]
> >
> > DLookUp("[MajorCategory]", "Auto Types", [auto Type]='1'")
> >
> > --
> > Wayne Morgan
> > Microsoft Access MVP
> >
> >
> > "JustMe" <temilson@saskt el.net> wrote in message[/color]
> news:vpir7hq6hq hg54@corp.super news.com...[color=green][color=darkred]
> > > I don't know if this has anything to do with AccessXP running on[/color][/color]
> Terminal[color=green][color=darkred]
> > > Services with Access97/2000 also installed, but here is one example of[/color][/color][/color]
a[color=blue][color=green][color=darkred]
> > > query that does not work any longer:
> > >
> > > SELECT DLookUp("MajorC ategory","AutoT ypes","[autoType]='1'") AS
> > > MajorCategory, PreOwned.PaintC olor
> > > FROM PreOwned;
> > >
> > > When I try to run the above query I get the following error:
> > >
> > > UNKNOWN FUNCTION NAME
> > >
> > > If I execute the exact same dlookup from the immediate window, the[/color][/color]
> proper[color=green][color=darkred]
> > > data is returned with no error.
> > >
> > > Any suggestions? I have very little hair left on my head after[/color][/color][/color]
this!!![color=blue][color=green][color=darkred]
> > >
> > > Thanks,
> > > --Terry
> > >
> > >
> > >
> > > ---
> > > Outgoing mail is certified Virus Free.
> > > Checked by AVG anti-virus system (http://www.grisoft.com).
> > > Version: 6.0.516 / Virus Database: 313 - Release Date: 9/2/2003
> > >
> > >[/color]
> >
> >[/color]
>
>
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.516 / Virus Database: 313 - Release Date: 9/2/2003
>
>[/color]


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.516 / Virus Database: 313 - Release Date: 9/2/2003

[Wayne Morgan]

Re: Access XP weirdness ...

If it works fine on other machines then it sounds like a References problem. Open a code
window (Alt+F11) and go to Tools|Reference s. Compare them with a machine that does work.
Also, make sure none of them are listed as MISSING.

--
Wayne Morgan
Microsoft Access MVP


"JustMe" <temilson@saskt el.net> wrote in message news:vpisdr9gsa jtfb@corp.super news.com...[color=blue]
> By the way, the exact same query works fine in Access 97 on the same
> machine.
>
> Terry
> "JustMe" <temilson@saskt el.net> wrote in message
> news:vpis7t8grk 4h66@corp.super news.com...[color=green]
> > Hi Wayne ...
> >
> > Thanks for your reply. I tried surrounding ALL the fields with brackets
> > with no success. I still get the UNKNOWN FUNCTION NAME error.
> >
> > Any other suggestions? Anyone?
> >
> > The same query works fine on other machines running AccessXP. I've tried
> > uninstalling/reinstalling XP. I've tried everything I can think of.
> >
> > Help!
> >
> > "Wayne Morgan" <comprev_gothro ughthenewsgroup @hotmail.com> wrote in[/color]
> message[color=green]
> > news:a8emb.1440 2$Qv6.12067@new ssvr33.news.pro digy.com...[color=darkred]
> > > Even without a space in the name, I think it wants brackets around the[/color]
> > field name.[color=darkred]
> > >
> > > DLookUp("[MajorCategory]", "Auto Types", [auto Type]='1'")
> > >
> > > --
> > > Wayne Morgan
> > > Microsoft Access MVP
> > >
> > >
> > > "JustMe" <temilson@saskt el.net> wrote in message[/color]
> > news:vpir7hq6hq hg54@corp.super news.com...[color=darkred]
> > > > I don't know if this has anything to do with AccessXP running on[/color]
> > Terminal[color=darkred]
> > > > Services with Access97/2000 also installed, but here is one example of[/color][/color]
> a[color=green][color=darkred]
> > > > query that does not work any longer:
> > > >
> > > > SELECT DLookUp("MajorC ategory","AutoT ypes","[autoType]='1'") AS
> > > > MajorCategory, PreOwned.PaintC olor
> > > > FROM PreOwned;
> > > >
> > > > When I try to run the above query I get the following error:
> > > >
> > > > UNKNOWN FUNCTION NAME
> > > >
> > > > If I execute the exact same dlookup from the immediate window, the[/color]
> > proper[color=darkred]
> > > > data is returned with no error.
> > > >
> > > > Any suggestions? I have very little hair left on my head after[/color][/color]
> this!!![color=green][color=darkred]
> > > >
> > > > Thanks,
> > > > --Terry
> > > >
> > > >
> > > >
> > > > ---
> > > > Outgoing mail is certified Virus Free.
> > > > Checked by AVG anti-virus system (http://www.grisoft.com).
> > > > Version: 6.0.516 / Virus Database: 313 - Release Date: 9/2/2003
> > > >
> > > >
> > >
> > >[/color]
> >
> >
> > ---
> > Outgoing mail is certified Virus Free.
> > Checked by AVG anti-virus system (http://www.grisoft.com).
> > Version: 6.0.516 / Virus Database: 313 - Release Date: 9/2/2003
> >
> >[/color]
>
>
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.516 / Virus Database: 313 - Release Date: 9/2/2003
>
>[/color]

[JustMe]

Re: Access XP weirdness ...

Hi Wayne ...

I've already tried this. All references are identical to my other machine.
None are missing.

Any other suggestions?
--Terry
"Wayne Morgan" <comprev_gothro ughthenewsgroup @hotmail.com> wrote in message
news:O%lmb.1129 7$rv5.7541@news svr16.news.prod igy.com...[color=blue]
> If it works fine on other machines then it sounds like a References[/color]
problem. Open a code[color=blue]
> window (Alt+F11) and go to Tools|Reference s. Compare them with a machine[/color]
that does work.[color=blue]
> Also, make sure none of them are listed as MISSING.
>
> --
> Wayne Morgan
> Microsoft Access MVP
>
>
> "JustMe" <temilson@saskt el.net> wrote in message[/color]
news:vpisdr9gsa jtfb@corp.super news.com...[color=blue][color=green]
> > By the way, the exact same query works fine in Access 97 on the same
> > machine.
> >
> > Terry
> > "JustMe" <temilson@saskt el.net> wrote in message
> > news:vpis7t8grk 4h66@corp.super news.com...[color=darkred]
> > > Hi Wayne ...
> > >
> > > Thanks for your reply. I tried surrounding ALL the fields with[/color][/color][/color]
brackets[color=blue][color=green][color=darkred]
> > > with no success. I still get the UNKNOWN FUNCTION NAME error.
> > >
> > > Any other suggestions? Anyone?
> > >
> > > The same query works fine on other machines running AccessXP. I've[/color][/color][/color]
tried[color=blue][color=green][color=darkred]
> > > uninstalling/reinstalling XP. I've tried everything I can think of.
> > >
> > > Help!
> > >
> > > "Wayne Morgan" <comprev_gothro ughthenewsgroup @hotmail.com> wrote in[/color]
> > message[color=darkred]
> > > news:a8emb.1440 2$Qv6.12067@new ssvr33.news.pro digy.com...
> > > > Even without a space in the name, I think it wants brackets around[/color][/color][/color]
the[color=blue][color=green][color=darkred]
> > > field name.
> > > >
> > > > DLookUp("[MajorCategory]", "Auto Types", [auto Type]='1'")
> > > >
> > > > --
> > > > Wayne Morgan
> > > > Microsoft Access MVP
> > > >
> > > >
> > > > "JustMe" <temilson@saskt el.net> wrote in message
> > > news:vpir7hq6hq hg54@corp.super news.com...
> > > > > I don't know if this has anything to do with AccessXP running on
> > > Terminal
> > > > > Services with Access97/2000 also installed, but here is one[/color][/color][/color]
example of[color=blue][color=green]
> > a[color=darkred]
> > > > > query that does not work any longer:
> > > > >
> > > > > SELECT DLookUp("MajorC ategory","AutoT ypes","[autoType]='1'") AS
> > > > > MajorCategory, PreOwned.PaintC olor
> > > > > FROM PreOwned;
> > > > >
> > > > > When I try to run the above query I get the following error:
> > > > >
> > > > > UNKNOWN FUNCTION NAME
> > > > >
> > > > > If I execute the exact same dlookup from the immediate window, the
> > > proper
> > > > > data is returned with no error.
> > > > >
> > > > > Any suggestions? I have very little hair left on my head after[/color]
> > this!!![color=darkred]
> > > > >
> > > > > Thanks,
> > > > > --Terry
> > > > >
> > > > >
> > > > >
> > > > > ---
> > > > > Outgoing mail is certified Virus Free.
> > > > > Checked by AVG anti-virus system (http://www.grisoft.com).
> > > > > Version: 6.0.516 / Virus Database: 313 - Release Date: 9/2/2003
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> > > ---
> > > Outgoing mail is certified Virus Free.
> > > Checked by AVG anti-virus system (http://www.grisoft.com).
> > > Version: 6.0.516 / Virus Database: 313 - Release Date: 9/2/2003
> > >
> > >[/color]
> >
> >
> > ---
> > Outgoing mail is certified Virus Free.
> > Checked by AVG anti-virus system (http://www.grisoft.com).
> > Version: 6.0.516 / Virus Database: 313 - Release Date: 9/2/2003
> >
> >[/color]
>
>[/color]


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.516 / Virus Database: 313 - Release Date: 9/2/2003

[Douglas J. Steele]

Re: Access XP weirdness ...

Here's my standard blurb on fixing reference problems:

On the machine(s) where it's not working, open any code module (or open the
Debug Window, using Ctrl-G, provided you haven't selected the "keep debug
window on top" option). Select Tools | References from the menu bar. Examine
all of the selected references.

If any of the selected references have "MISSING:" in front of them, unselect
them, and back out of the dialog. If you really need the reference(s) you
just unselected (you can tell by doing a Compile All Modules), go back in
and reselect them.

If none have "MISSING:", select an additional reference at random, back out
of the dialog, then go back in and unselect the reference you just added. If
that doesn't solve the problem, try to unselect as many of the selected
references as you can (Access may not let you unselect them all), back out
of the dialog, then go back in and reselect the references you just
unselected. (NOTE: write down what the references are before you delete
them, because they'll be in a different order when you go back in)


--
Doug Steele, Microsoft Access MVP

http://I.Am/DougSteele

(No private e-mails, please)



"JustMe" <temilson@saskt el.net> wrote in message
news:vpjtvtk2vk hu38@corp.super news.com...[color=blue]
> Hi Wayne ...
>
> I've already tried this. All references are identical to my other[/color]
machine.[color=blue]
> None are missing.
>
> Any other suggestions?
> --Terry
> "Wayne Morgan" <comprev_gothro ughthenewsgroup @hotmail.com> wrote in[/color]
message[color=blue]
> news:O%lmb.1129 7$rv5.7541@news svr16.news.prod igy.com...[color=green]
> > If it works fine on other machines then it sounds like a References[/color]
> problem. Open a code[color=green]
> > window (Alt+F11) and go to Tools|Reference s. Compare them with a machine[/color]
> that does work.[color=green]
> > Also, make sure none of them are listed as MISSING.
> >
> > --
> > Wayne Morgan
> > Microsoft Access MVP
> >
> >
> > "JustMe" <temilson@saskt el.net> wrote in message[/color]
> news:vpisdr9gsa jtfb@corp.super news.com...[color=green][color=darkred]
> > > By the way, the exact same query works fine in Access 97 on the same
> > > machine.
> > >
> > > Terry
> > > "JustMe" <temilson@saskt el.net> wrote in message
> > > news:vpis7t8grk 4h66@corp.super news.com...
> > > > Hi Wayne ...
> > > >
> > > > Thanks for your reply. I tried surrounding ALL the fields with[/color][/color]
> brackets[color=green][color=darkred]
> > > > with no success. I still get the UNKNOWN FUNCTION NAME error.
> > > >
> > > > Any other suggestions? Anyone?
> > > >
> > > > The same query works fine on other machines running AccessXP. I've[/color][/color]
> tried[color=green][color=darkred]
> > > > uninstalling/reinstalling XP. I've tried everything I can think of.
> > > >
> > > > Help!
> > > >
> > > > "Wayne Morgan" <comprev_gothro ughthenewsgroup @hotmail.com> wrote in
> > > message
> > > > news:a8emb.1440 2$Qv6.12067@new ssvr33.news.pro digy.com...
> > > > > Even without a space in the name, I think it wants brackets around[/color][/color]
> the[color=green][color=darkred]
> > > > field name.
> > > > >
> > > > > DLookUp("[MajorCategory]", "Auto Types", [auto Type]='1'")
> > > > >
> > > > > --
> > > > > Wayne Morgan
> > > > > Microsoft Access MVP
> > > > >
> > > > >
> > > > > "JustMe" <temilson@saskt el.net> wrote in message
> > > > news:vpir7hq6hq hg54@corp.super news.com...
> > > > > > I don't know if this has anything to do with AccessXP running on
> > > > Terminal
> > > > > > Services with Access97/2000 also installed, but here is one[/color][/color]
> example of[color=green][color=darkred]
> > > a
> > > > > > query that does not work any longer:
> > > > > >
> > > > > > SELECT DLookUp("MajorC ategory","AutoT ypes","[autoType]='1'") AS
> > > > > > MajorCategory, PreOwned.PaintC olor
> > > > > > FROM PreOwned;
> > > > > >
> > > > > > When I try to run the above query I get the following error:
> > > > > >
> > > > > > UNKNOWN FUNCTION NAME
> > > > > >
> > > > > > If I execute the exact same dlookup from the immediate window,[/color][/color][/color]
the[color=blue][color=green][color=darkred]
> > > > proper
> > > > > > data is returned with no error.
> > > > > >
> > > > > > Any suggestions? I have very little hair left on my head after
> > > this!!!
> > > > > >
> > > > > > Thanks,
> > > > > > --Terry
> > > > > >
> > > > > >
> > > > > >
> > > > > > ---
> > > > > > Outgoing mail is certified Virus Free.
> > > > > > Checked by AVG anti-virus system (http://www.grisoft.com).
> > > > > > Version: 6.0.516 / Virus Database: 313 - Release Date: 9/2/2003
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > > > ---
> > > > Outgoing mail is certified Virus Free.
> > > > Checked by AVG anti-virus system (http://www.grisoft.com).
> > > > Version: 6.0.516 / Virus Database: 313 - Release Date: 9/2/2003
> > > >
> > > >
> > >
> > >
> > > ---
> > > Outgoing mail is certified Virus Free.
> > > Checked by AVG anti-virus system (http://www.grisoft.com).
> > > Version: 6.0.516 / Virus Database: 313 - Release Date: 9/2/2003
> > >
> > >[/color]
> >
> >[/color]
>
>
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.516 / Virus Database: 313 - Release Date: 9/2/2003
>
>[/color]

[JustMe]

Re: Access XP weirdness ...

Hi Douglas ...

Thanks for your suggestions. Unfortunately still a no-go. I've tried
everything with no success.

Any other ideas? Anyone?

--Terry


"Douglas J. Steele" <NOSPAM_djsteel e@NOSPAM_canada .com> wrote in message
news:tjtmb.76$7 B1.21@news04.bl oor.is.net.cabl e.rogers.com...[color=blue]
> Here's my standard blurb on fixing reference problems:
>
> On the machine(s) where it's not working, open any code module (or open[/color]
the[color=blue]
> Debug Window, using Ctrl-G, provided you haven't selected the "keep debug
> window on top" option). Select Tools | References from the menu bar.[/color]
Examine[color=blue]
> all of the selected references.
>
> If any of the selected references have "MISSING:" in front of them,[/color]
unselect[color=blue]
> them, and back out of the dialog. If you really need the reference(s) you
> just unselected (you can tell by doing a Compile All Modules), go back in
> and reselect them.
>
> If none have "MISSING:", select an additional reference at random, back[/color]
out[color=blue]
> of the dialog, then go back in and unselect the reference you just added.[/color]
If[color=blue]
> that doesn't solve the problem, try to unselect as many of the selected
> references as you can (Access may not let you unselect them all), back out
> of the dialog, then go back in and reselect the references you just
> unselected. (NOTE: write down what the references are before you delete
> them, because they'll be in a different order when you go back in)
>
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (No private e-mails, please)
>
>
>
> "JustMe" <temilson@saskt el.net> wrote in message
> news:vpjtvtk2vk hu38@corp.super news.com...[color=green]
> > Hi Wayne ...
> >
> > I've already tried this. All references are identical to my other[/color]
> machine.[color=green]
> > None are missing.
> >
> > Any other suggestions?
> > --Terry
> > "Wayne Morgan" <comprev_gothro ughthenewsgroup @hotmail.com> wrote in[/color]
> message[color=green]
> > news:O%lmb.1129 7$rv5.7541@news svr16.news.prod igy.com...[color=darkred]
> > > If it works fine on other machines then it sounds like a References[/color]
> > problem. Open a code[color=darkred]
> > > window (Alt+F11) and go to Tools|Reference s. Compare them with a[/color][/color][/color]
machine[color=blue][color=green]
> > that does work.[color=darkred]
> > > Also, make sure none of them are listed as MISSING.
> > >
> > > --
> > > Wayne Morgan
> > > Microsoft Access MVP
> > >
> > >
> > > "JustMe" <temilson@saskt el.net> wrote in message[/color]
> > news:vpisdr9gsa jtfb@corp.super news.com...[color=darkred]
> > > > By the way, the exact same query works fine in Access 97 on the same
> > > > machine.
> > > >
> > > > Terry
> > > > "JustMe" <temilson@saskt el.net> wrote in message
> > > > news:vpis7t8grk 4h66@corp.super news.com...
> > > > > Hi Wayne ...
> > > > >
> > > > > Thanks for your reply. I tried surrounding ALL the fields with[/color]
> > brackets[color=darkred]
> > > > > with no success. I still get the UNKNOWN FUNCTION NAME error.
> > > > >
> > > > > Any other suggestions? Anyone?
> > > > >
> > > > > The same query works fine on other machines running AccessXP.[/color][/color][/color]
I've[color=blue][color=green]
> > tried[color=darkred]
> > > > > uninstalling/reinstalling XP. I've tried everything I can think[/color][/color][/color]
of.[color=blue][color=green][color=darkred]
> > > > >
> > > > > Help!
> > > > >
> > > > > "Wayne Morgan" <comprev_gothro ughthenewsgroup @hotmail.com> wrote[/color][/color][/color]
in[color=blue][color=green][color=darkred]
> > > > message
> > > > > news:a8emb.1440 2$Qv6.12067@new ssvr33.news.pro digy.com...
> > > > > > Even without a space in the name, I think it wants brackets[/color][/color][/color]
around[color=blue][color=green]
> > the[color=darkred]
> > > > > field name.
> > > > > >
> > > > > > DLookUp("[MajorCategory]", "Auto Types", [auto Type]='1'")
> > > > > >
> > > > > > --
> > > > > > Wayne Morgan
> > > > > > Microsoft Access MVP
> > > > > >
> > > > > >
> > > > > > "JustMe" <temilson@saskt el.net> wrote in message
> > > > > news:vpir7hq6hq hg54@corp.super news.com...
> > > > > > > I don't know if this has anything to do with AccessXP running[/color][/color][/color]
on[color=blue][color=green][color=darkred]
> > > > > Terminal
> > > > > > > Services with Access97/2000 also installed, but here is one[/color]
> > example of[color=darkred]
> > > > a
> > > > > > > query that does not work any longer:
> > > > > > >
> > > > > > > SELECT DLookUp("MajorC ategory","AutoT ypes","[autoType]='1'")[/color][/color][/color]
AS[color=blue][color=green][color=darkred]
> > > > > > > MajorCategory, PreOwned.PaintC olor
> > > > > > > FROM PreOwned;
> > > > > > >
> > > > > > > When I try to run the above query I get the following error:
> > > > > > >
> > > > > > > UNKNOWN FUNCTION NAME
> > > > > > >
> > > > > > > If I execute the exact same dlookup from the immediate window,[/color][/color]
> the[color=green][color=darkred]
> > > > > proper
> > > > > > > data is returned with no error.
> > > > > > >
> > > > > > > Any suggestions? I have very little hair left on my head[/color][/color][/color]
after[color=blue][color=green][color=darkred]
> > > > this!!!
> > > > > > >
> > > > > > > Thanks,
> > > > > > > --Terry
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > ---
> > > > > > > Outgoing mail is certified Virus Free.
> > > > > > > Checked by AVG anti-virus system (http://www.grisoft.com).
> > > > > > > Version: 6.0.516 / Virus Database: 313 - Release Date:[/color][/color][/color]
9/2/2003[color=blue][color=green][color=darkred]
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > > > ---
> > > > > Outgoing mail is certified Virus Free.
> > > > > Checked by AVG anti-virus system (http://www.grisoft.com).
> > > > > Version: 6.0.516 / Virus Database: 313 - Release Date: 9/2/2003
> > > > >
> > > > >
> > > >
> > > >
> > > > ---
> > > > Outgoing mail is certified Virus Free.
> > > > Checked by AVG anti-virus system (http://www.grisoft.com).
> > > > Version: 6.0.516 / Virus Database: 313 - Release Date: 9/2/2003
> > > >
> > > >
> > >
> > >[/color]
> >
> >
> > ---
> > Outgoing mail is certified Virus Free.
> > Checked by AVG anti-virus system (http://www.grisoft.com).
> > Version: 6.0.516 / Virus Database: 313 - Release Date: 9/2/2003
> >
> >[/color]
>
>[/color]


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.516 / Virus Database: 313 - Release Date: 9/3/2003

[Wayne Morgan]

Re: Access XP weirdness ...

Let's go back a step, you said you surrounded ALL the field with brackets as a try. It
doesn't like brackets around the table's name, did you bracket that one also?

--
Wayne Morgan
Microsoft Access MVP


"JustMe" <temilson@saskt el.net> wrote in message news:vpjtvtk2vk hu38@corp.super news.com...[color=blue]
> Hi Wayne ...
>
> I've already tried this. All references are identical to my other machine.
> None are missing.
>
> Any other suggestions?
> --Terry
> "Wayne Morgan" <comprev_gothro ughthenewsgroup @hotmail.com> wrote in message
> news:O%lmb.1129 7$rv5.7541@news svr16.news.prod igy.com...[color=green]
> > If it works fine on other machines then it sounds like a References[/color]
> problem. Open a code[color=green]
> > window (Alt+F11) and go to Tools|Reference s. Compare them with a machine[/color]
> that does work.[color=green]
> > Also, make sure none of them are listed as MISSING.
> >
> > --
> > Wayne Morgan
> > Microsoft Access MVP
> >
> >
> > "JustMe" <temilson@saskt el.net> wrote in message[/color]
> news:vpisdr9gsa jtfb@corp.super news.com...[color=green][color=darkred]
> > > By the way, the exact same query works fine in Access 97 on the same
> > > machine.
> > >
> > > Terry
> > > "JustMe" <temilson@saskt el.net> wrote in message
> > > news:vpis7t8grk 4h66@corp.super news.com...
> > > > Hi Wayne ...
> > > >
> > > > Thanks for your reply. I tried surrounding ALL the fields with[/color][/color]
> brackets[color=green][color=darkred]
> > > > with no success. I still get the UNKNOWN FUNCTION NAME error.
> > > >
> > > > Any other suggestions? Anyone?
> > > >
> > > > The same query works fine on other machines running AccessXP. I've[/color][/color]
> tried[color=green][color=darkred]
> > > > uninstalling/reinstalling XP. I've tried everything I can think of.
> > > >
> > > > Help!
> > > >
> > > > "Wayne Morgan" <comprev_gothro ughthenewsgroup @hotmail.com> wrote in
> > > message
> > > > news:a8emb.1440 2$Qv6.12067@new ssvr33.news.pro digy.com...
> > > > > Even without a space in the name, I think it wants brackets around[/color][/color]
> the[color=green][color=darkred]
> > > > field name.
> > > > >
> > > > > DLookUp("[MajorCategory]", "Auto Types", [auto Type]='1'")
> > > > >
> > > > > --
> > > > > Wayne Morgan
> > > > > Microsoft Access MVP
> > > > >
> > > > >
> > > > > "JustMe" <temilson@saskt el.net> wrote in message
> > > > news:vpir7hq6hq hg54@corp.super news.com...
> > > > > > I don't know if this has anything to do with AccessXP running on
> > > > Terminal
> > > > > > Services with Access97/2000 also installed, but here is one[/color][/color]
> example of[color=green][color=darkred]
> > > a
> > > > > > query that does not work any longer:
> > > > > >
> > > > > > SELECT DLookUp("MajorC ategory","AutoT ypes","[autoType]='1'") AS
> > > > > > MajorCategory, PreOwned.PaintC olor
> > > > > > FROM PreOwned;
> > > > > >
> > > > > > When I try to run the above query I get the following error:
> > > > > >
> > > > > > UNKNOWN FUNCTION NAME
> > > > > >
> > > > > > If I execute the exact same dlookup from the immediate window, the
> > > > proper
> > > > > > data is returned with no error.
> > > > > >
> > > > > > Any suggestions? I have very little hair left on my head after
> > > this!!!
> > > > > >
> > > > > > Thanks,
> > > > > > --Terry
> > > > > >
> > > > > >
> > > > > >
> > > > > > ---
> > > > > > Outgoing mail is certified Virus Free.
> > > > > > Checked by AVG anti-virus system (http://www.grisoft.com).
> > > > > > Version: 6.0.516 / Virus Database: 313 - Release Date: 9/2/2003
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > > > ---
> > > > Outgoing mail is certified Virus Free.
> > > > Checked by AVG anti-virus system (http://www.grisoft.com).
> > > > Version: 6.0.516 / Virus Database: 313 - Release Date: 9/2/2003
> > > >
> > > >
> > >
> > >
> > > ---
> > > Outgoing mail is certified Virus Free.
> > > Checked by AVG anti-virus system (http://www.grisoft.com).
> > > Version: 6.0.516 / Virus Database: 313 - Release Date: 9/2/2003
> > >
> > >[/color]
> >
> >[/color]
>
>
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.516 / Virus Database: 313 - Release Date: 9/2/2003
>
>[/color]

[Tom van Stiphout]

Re: Access XP weirdness ...

On Fri, 24 Oct 2003 12:14:10 -0600, "JustMe" <temilson@saskt el.net>
wrote:

Very curious. Can you repeat this with a similar query in the
Northwind sample database?

I'm assuming this works fine:
SELECT "test" AS
MajorCategory, PreOwned.PaintC olor
FROM PreOwned;

-Tom.


[color=blue]
>I don't know if this has anything to do with AccessXP running on Terminal
>Services with Access97/2000 also installed, but here is one example of a
>query that does not work any longer:
>
>SELECT DLookUp("MajorC ategory","AutoT ypes","[autoType]='1'") AS
>MajorCategor y, PreOwned.PaintC olor
>FROM PreOwned;
>
>When I try to run the above query I get the following error:
>
>UNKNOWN FUNCTION NAME
>
>If I execute the exact same dlookup from the immediate window, the proper
>data is returned with no error.
>
>Any suggestions? I have very little hair left on my head after this!!!
>
>Thanks,
>--Terry
>
>
>
>---
>Outgoing mail is certified Virus Free.
>Checked by AVG anti-virus system (http://www.grisoft.com).
>Version: 6.0.516 / Virus Database: 313 - Release Date: 9/2/2003
>[/color]

[Steve Jorgensen]

Re: Access XP weirdness ...

I just recently was called in to fix a similar problem at a client site
with Access 2000. It seems, machines with some of the newest updates from
Microsoft can no longer execute certain built-in functions from within
queries or calculated controls (things that use the "Expression Service").
In my case, the original author had been using the Dir$ function from a
query.

Like you, I tried all the usual fixes, going so far as to try it in a new,
blank database created on the problem machine. Finally, I ended up simply
deciding this was a "feature" of a new update from Microsoft, and working
around it by writing my own user-defined function to call Dir$. I suspect
your situation may be the same issue.

On Sat, 25 Oct 2003 07:58:11 -0600, "JustMe" <temilson@saskt el.net> wrote:
[color=blue]
>Hi Douglas ...
>
>Thanks for your suggestions. Unfortunately still a no-go. I've tried
>everything with no success.
>
>Any other ideas? Anyone?
>
>--Terry
>
>
>"Douglas J. Steele" <NOSPAM_djsteel e@NOSPAM_canada .com> wrote in message
>news:tjtmb.76$ 7B1.21@news04.b loor.is.net.cab le.rogers.com.. .[color=green]
>> Here's my standard blurb on fixing reference problems:
>>
>> On the machine(s) where it's not working, open any code module (or open[/color]
>the[color=green]
>> Debug Window, using Ctrl-G, provided you haven't selected the "keep debug
>> window on top" option). Select Tools | References from the menu bar.[/color]
>Examine[color=green]
>> all of the selected references.
>>
>> If any of the selected references have "MISSING:" in front of them,[/color]
>unselect[color=green]
>> them, and back out of the dialog. If you really need the reference(s) you
>> just unselected (you can tell by doing a Compile All Modules), go back in
>> and reselect them.
>>
>> If none have "MISSING:", select an additional reference at random, back[/color]
>out[color=green]
>> of the dialog, then go back in and unselect the reference you just added.[/color]
>If[color=green]
>> that doesn't solve the problem, try to unselect as many of the selected
>> references as you can (Access may not let you unselect them all), back out
>> of the dialog, then go back in and reselect the references you just
>> unselected. (NOTE: write down what the references are before you delete
>> them, because they'll be in a different order when you go back in)
>>
>>
>> --
>> Doug Steele, Microsoft Access MVP
>> http://I.Am/DougSteele
>> (No private e-mails, please)
>>
>>
>>
>> "JustMe" <temilson@saskt el.net> wrote in message
>> news:vpjtvtk2vk hu38@corp.super news.com...[color=darkred]
>> > Hi Wayne ...
>> >
>> > I've already tried this. All references are identical to my other[/color]
>> machine.[color=darkred]
>> > None are missing.
>> >
>> > Any other suggestions?
>> > --Terry
>> > "Wayne Morgan" <comprev_gothro ughthenewsgroup @hotmail.com> wrote in[/color]
>> message[color=darkred]
>> > news:O%lmb.1129 7$rv5.7541@news svr16.news.prod igy.com...
>> > > If it works fine on other machines then it sounds like a References
>> > problem. Open a code
>> > > window (Alt+F11) and go to Tools|Reference s. Compare them with a[/color][/color]
>machine[color=green][color=darkred]
>> > that does work.
>> > > Also, make sure none of them are listed as MISSING.
>> > >
>> > > --
>> > > Wayne Morgan
>> > > Microsoft Access MVP
>> > >
>> > >
>> > > "JustMe" <temilson@saskt el.net> wrote in message
>> > news:vpisdr9gsa jtfb@corp.super news.com...
>> > > > By the way, the exact same query works fine in Access 97 on the same
>> > > > machine.
>> > > >
>> > > > Terry
>> > > > "JustMe" <temilson@saskt el.net> wrote in message
>> > > > news:vpis7t8grk 4h66@corp.super news.com...
>> > > > > Hi Wayne ...
>> > > > >
>> > > > > Thanks for your reply. I tried surrounding ALL the fields with
>> > brackets
>> > > > > with no success. I still get the UNKNOWN FUNCTION NAME error.
>> > > > >
>> > > > > Any other suggestions? Anyone?
>> > > > >
>> > > > > The same query works fine on other machines running AccessXP.[/color][/color]
>I've[color=green][color=darkred]
>> > tried
>> > > > > uninstalling/reinstalling XP. I've tried everything I can think[/color][/color]
>of.[color=green][color=darkred]
>> > > > >
>> > > > > Help!
>> > > > >
>> > > > > "Wayne Morgan" <comprev_gothro ughthenewsgroup @hotmail.com> wrote[/color][/color]
>in[color=green][color=darkred]
>> > > > message
>> > > > > news:a8emb.1440 2$Qv6.12067@new ssvr33.news.pro digy.com...
>> > > > > > Even without a space in the name, I think it wants brackets[/color][/color]
>around[color=green][color=darkred]
>> > the
>> > > > > field name.
>> > > > > >
>> > > > > > DLookUp("[MajorCategory]", "Auto Types", [auto Type]='1'")
>> > > > > >
>> > > > > > --
>> > > > > > Wayne Morgan
>> > > > > > Microsoft Access MVP
>> > > > > >
>> > > > > >
>> > > > > > "JustMe" <temilson@saskt el.net> wrote in message
>> > > > > news:vpir7hq6hq hg54@corp.super news.com...
>> > > > > > > I don't know if this has anything to do with AccessXP running[/color][/color]
>on[color=green][color=darkred]
>> > > > > Terminal
>> > > > > > > Services with Access97/2000 also installed, but here is one
>> > example of
>> > > > a
>> > > > > > > query that does not work any longer:
>> > > > > > >
>> > > > > > > SELECT DLookUp("MajorC ategory","AutoT ypes","[autoType]='1'")[/color][/color]
>AS[color=green][color=darkred]
>> > > > > > > MajorCategory, PreOwned.PaintC olor
>> > > > > > > FROM PreOwned;
>> > > > > > >
>> > > > > > > When I try to run the above query I get the following error:
>> > > > > > >
>> > > > > > > UNKNOWN FUNCTION NAME
>> > > > > > >
>> > > > > > > If I execute the exact same dlookup from the immediate window,[/color]
>> the[color=darkred]
>> > > > > proper
>> > > > > > > data is returned with no error.
>> > > > > > >
>> > > > > > > Any suggestions? I have very little hair left on my head[/color][/color]
>after[color=green][color=darkred]
>> > > > this!!!
>> > > > > > >
>> > > > > > > Thanks,
>> > > > > > > --Terry
>> > > > > > >
>> > > > > > >
>> > > > > > >
>> > > > > > > ---
>> > > > > > > Outgoing mail is certified Virus Free.
>> > > > > > > Checked by AVG anti-virus system (http://www.grisoft.com).
>> > > > > > > Version: 6.0.516 / Virus Database: 313 - Release Date:[/color][/color]
>9/2/2003[color=green][color=darkred]
>> > > > > > >
>> > > > > > >
>> > > > > >
>> > > > > >
>> > > > >
>> > > > >
>> > > > > ---
>> > > > > Outgoing mail is certified Virus Free.
>> > > > > Checked by AVG anti-virus system (http://www.grisoft.com).
>> > > > > Version: 6.0.516 / Virus Database: 313 - Release Date: 9/2/2003
>> > > > >
>> > > > >
>> > > >
>> > > >
>> > > > ---
>> > > > Outgoing mail is certified Virus Free.
>> > > > Checked by AVG anti-virus system (http://www.grisoft.com).
>> > > > Version: 6.0.516 / Virus Database: 313 - Release Date: 9/2/2003
>> > > >
>> > > >
>> > >
>> > >
>> >
>> >
>> > ---
>> > Outgoing mail is certified Virus Free.
>> > Checked by AVG anti-virus system (http://www.grisoft.com).
>> > Version: 6.0.516 / Virus Database: 313 - Release Date: 9/2/2003
>> >
>> >[/color]
>>
>>[/color]
>
>
>---
>Outgoing mail is certified Virus Free.
>Checked by AVG anti-virus system (http://www.grisoft.com).
>Version: 6.0.516 / Virus Database: 313 - Release Date: 9/3/2003
>[/color]

[Tom van Stiphout]

Re: Access XP weirdness ...

On Sat, 25 Oct 2003 16:05:33 GMT, "Wayne Morgan"
<comprev_gothro ughthenewsgroup @hotmail.com> wrote:

Wayne, bracketing field names or table names is not needed (although
harmless) when they are single words without funny characters.
-Tom.

[color=blue]
>Let's go back a step, you said you surrounded ALL the field with brackets as a try. It
>doesn't like brackets around the table's name, did you bracket that one also?[/color]

[David W. Fenton]

Re: Access XP weirdness ...

nospam@nospam.n ospam (Steve Jorgensen) wrote in
<r2elpvs1rj5ntb c9qevbl4vfpt295 9vg10@4ax.com>:
[color=blue]
>I just recently was called in to fix a similar problem at a client
>site with Access 2000. It seems, machines with some of the newest
>updates from Microsoft can no longer execute certain built-in
>functions from within queries or calculated controls (things that
>use the "Expression Service"). In my case, the original author had
>been using the Dir$ function from a query.
>
>Like you, I tried all the usual fixes, going so far as to try it
>in a new, blank database created on the problem machine. Finally,
>I ended up simply deciding this was a "feature" of a new update
>from Microsoft, and working around it by writing my own
>user-defined function to call Dir$. I suspect your situation may
>be the same issue.[/color]

Would that be Jet 4 SP7? One of the things it does is do something
to the security of Jet that disallows certain kinds of VBA calls
from SQL. At least, that was my understanding when it initially
came out.

Has *anyone* found SP7 to be a good thing? I know it causes
problems with replication, for one, and many people have rolled
back to SP6.

Is there anythign that SP7 fixes that is essential?

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc

[David W. Fenton]

Re: Access XP weirdness ...

temilson@saskte l.net (JustMe) wrote in
<vpir7hq6hqhg54 @corp.supernews .com>:
[color=blue]
>I don't know if this has anything to do with AccessXP running on
>Terminal Services with Access97/2000 also installed, but here is
>one example of a query that does not work any longer:
>
>SELECT DLookUp("MajorC ategory","AutoT ypes","[autoType]='1'") AS
>MajorCategor y, PreOwned.PaintC olor
>FROM PreOwned;
>
>When I try to run the above query I get the following error:
>
>UNKNOWN FUNCTION NAME
>
>If I execute the exact same dlookup from the immediate window, the
>proper data is returned with no error.
>
>Any suggestions? I have very little hair left on my head after
>this!!![/color]

Er, why not do this with SQL?

SELECT AutoTypes.Major Category, PreOwned.PaintC olor
FROM AutoTypes, PreOwned
WHERE AutoTypes.AutoT ype = '1'

Of course, why not hardwire the result in the first place? If you
know that the relevant AutoType is 1, don't you know what the
MajorCategory is? Or is AutoType stored in PreOwned? If so, then
you could join the two tables.

Something looks wrong here -- I can't think of a case where it
makes sense to use a DLookup in a query, myself.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc

[Tom van Stiphout]

Re: Access XP weirdness ...

On Sat, 25 Oct 2003 21:09:57 GMT, dXXXfenton@bway .net.invalid (David
W. Fenton) wrote:

SP8 just came out. I quickly read the what's new section, and it
seemed to fix some SP7 bugs.
-Tom.

[color=blue]
>nospam@nospam. nospam (Steve Jorgensen) wrote in
><r2elpvs1rj5nt bc9qevbl4vfpt29 59vg10@4ax.com> :
>[color=green]
>>I just recently was called in to fix a similar problem at a client
>>site with Access 2000. It seems, machines with some of the newest
>>updates from Microsoft can no longer execute certain built-in
>>functions from within queries or calculated controls (things that
>>use the "Expression Service"). In my case, the original author had
>>been using the Dir$ function from a query.
>>
>>Like you, I tried all the usual fixes, going so far as to try it
>>in a new, blank database created on the problem machine. Finally,
>>I ended up simply deciding this was a "feature" of a new update
>>from Microsoft, and working around it by writing my own
>>user-defined function to call Dir$. I suspect your situation may
>>be the same issue.[/color]
>
>Would that be Jet 4 SP7? One of the things it does is do something
>to the security of Jet that disallows certain kinds of VBA calls
>from SQL. At least, that was my understanding when it initially
>came out.
>
>Has *anyone* found SP7 to be a good thing? I know it causes
>problems with replication, for one, and many people have rolled
>back to SP6.
>
>Is there anythign that SP7 fixes that is essential?[/color]