Re: No Results Running Parameter Query on Field Using Lookup Table

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

On Aug 7, 8:11 am, handyman1...@xxxxxxxxx wrote:
On Aug 6, 6:21 pm, John Spencer <spen...@xxxxxxxxxx> wrote:





One possibility is that you are using the ANSI-Compliant SQL setting.
   Try using "%" in place of "*"

'====================================================
  John Spencer
  Access MVP 2002-2005, 2007-2008
  The Hilltop Institute
  University of Maryland Baltimore County
'====================================================

Lord Kelvan wrote:
can you tell me what the lookup table is and how it is used so i can
test it on my system ebcause i am gettign to problems i added a value
into the table i am testing on as a lookup value to another table but
i am still getting no problem in all intensive purposes it should work- Hide quoted text -

- Show quoted text -

I tried the "%" but no luck exactly the same problem.  By the way once
I get this working I want to add text boxes to an existing form that
links to the parameter query.  I have two fields that work fine
already but these fields don't have a lookup table to reference but I
got to get the basic parameter query to work first.- Hide quoted text -

- Show quoted text -

BINGO!!!! WE HAVE A WINNER!

Rather than writing the Table queries "inside" the Lookup Properties
window of the table, I wrote stand alone queries and simply entered
the query name on the Lookup Row Source screen and now everything
works! Why it works I'm not sure but it works. The only difference
being that the queries are external from the table Lookup. Strange
but true.
.

Relevant Pages

  • Re: Service manuals and schematics
    ... since you can't do a DNS lookup to find the owner. ...    Do you know anything, other than how to put stolen intellectual ...  Then see if you can find the other 1000+ pages of documentation ... or qualified components for military grade designs? ...
    (sci.electronics.repair)
  • Re: iptables + multiple gateways not firewalling
    ...  from all fwmark 0x10 lookup mail ...       in the order of increasing priority. ... evaluation stops once a rule is matched. ...
    (Ubuntu)
  • Re: Modify existing table for more details?
    ... not a true location but a text description using a lookup of common names ... Location ID field, Location field, location size field and EstNo ...   ... Estno 200 can have a bedroom thats 100 sf. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: How to add a chosen value from a combo box into a text box
    ... empty column is a zero-length string. ...     If IsNull) ... lookup data that will change in the lookup table over time, but otherwise, ... tblCompany, with 3 columns: CompanyID, CompanyName, PIC. ...
    (comp.databases.ms-access)
  • Re: SSIS lookup across disparate servers / DBs
    ... across / join to two disparate servers / databases in my lookup. ...     FROM DB1.dbo.Country lir ... yeah this is part of a greater task of importing data. ...
    (comp.databases.ms-sqlserver)