Re: #Name? - Killing Me

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

VBA Help and this link should give you a better understanding of the Domain
function syntax. The other suggestion you received is a good one and should
be considered.

http://www.mvps.org/access/general/gen0018.htm

JudyB wrote:
Thank you for quick response. I had also tried using DLookup, but was not
successful with that either. I typed:
=DLookUp"[ServiceTime]","[ServiceRecordQuery]") and the end result was
#Error. Have any idea where I went wrong?
You can not just point to a field in an existing static query to get the data.
The data is only available when the query is running. In this case I believe
[quoted text clipped - 10 lines]
form, but really wanted to use it in the query so that I can use it in other
places.

--
RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/200804/1

.

Relevant Pages

  • Re: R. ponticums repatriated.
    ... grey squirrels the species is of overseas origin but, ... you seem incapable of understanding the fact. ... Lack of understanding again Angus. ... Now when it is a serious suggestion you have gone very quiet on the ...
    (uk.environment.conservation)
  • Re: [RFC][PATCH 00/11] track files for checkpointability
    ... But the point was that it wasn't Dave not understanding Alexey's ... suggestion or some other way of doing a true may-be-checkpointed test). ... Ingo's concern is that this turn into a toy feature ... For repeatedly checking the checkpointability of large ...
    (Linux-Kernel)
  • Re: [RFC][PATCH 00/11] track files for checkpointability
    ... But the point was that it wasn't Dave not understanding Alexey's ... but Greg not understanding Ingo's. ... suggestion or some other way of doing a true may-be-checkpointed test). ...
    (Linux-Kernel)
  • Re: Rollover problem with text anchor
    ... adjust to taste ... I've updated the mock-up at http://tinyurl.com/5vbko5 with my ... understanding of your suggestion, and it half works in standards- ...
    (comp.infosystems.www.authoring.stylesheets)
  • Re: Question about a default table or method
    ... Take a look at "Understanding the Lifetime of Variables" in the VBA help to ... Visio MVP ...
    (microsoft.public.access.tablesdbdesign)