I have a cell on a sub form which uses =Dlookup("[Invoice]","Query","[ProgID]="&nz([simid]),0)) this works fine and retrieves the value using the query from the relevant table. However, I would li...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_10099668.html
Zones:
MS AccessDate Answered: 03/12/2002 Grade: A Views: 0
I have two tables one as "Report" where the data is entered and the other as "Task" where some data is picked up from. When I click on the field TaskOrderNumber in Reports form (TaskOrderNumber is ...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_10175091.html
Zones:
MS AccessDate Answered: 06/27/1999 Grade: A Views: 0
I currently have developed a query that includes a DLookup function. It works, but the resulting datasheet view scrolls slowly and I would like to be able to simply build te relationship into the ...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_10899101.html
Zones:
MS AccessDate Answered: 08/03/2000 Grade: A Views: 0
AC97....
Getting "error" as the result on my report for the following:
=DLookUp("t2ttl","qryPropPrint"," Rm_RoomNum =1")
whereas, this gives the correct result:
=DLookUp("t2ttl","tblP...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_20033329.html
Zones:
MS AccessDate Answered: 02/06/2001 Grade: A Views: 0
I have a datasheet form that lists a bunch of orders, and then underneath each order are its child deliveries. On the order line, I am using DLookup() to sum the total quantities in all child deli...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_20589539.html
Zones:
MS AccessDate Answered: 04/22/2003 Grade: A Views: 0
I am currently doing a computing project in access, one part of this requires a query to look up grades from a certain mark. but for different subjects there are different reference codes. So what ...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_20590555.html
Zones:
MS AccessDate Answered: 04/22/2003 Grade: A Views: 0
I wanted to use DLookup to test and see if a value is in the DB but I get the error "Invalid Use of Null"
Here is my code.
Dim TaxID
'- Determine if Invoice exists.
TaxID = ...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_20600153.html
Zones:
MS AccessDate Answered: 04/29/2003 Grade: A Views: 0
I am trying to use the following DLookup in a report which is based on a query (but I don't see how that should affect it).
=DLookUp("[ShippingCompany]","[SHIPPING]","[ShippingID]=" & [ShippedBy...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_20801403.html
Zones:
MS AccessDate Answered: 11/21/2003 Grade: C Views: 0
Hi I have 4 fields that are all dlookup fields for the username , for currentrecord count and also total record count, they work fine however because i have refresh on lost focus for several looku...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_20879681.html
Zones:
MS AccessDate Answered: 02/11/2004 Grade: A Views: 0
I am trying to do a dlookup in a query, using Access 2002. In the criteria field I want to use a field from another query, but it won't accept it. I know you can do this with a forms field...ie f...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_21147045.html
Zones:
MS AccessDate Answered: 09/28/2004 Grade: A Views: 0
